Developer forum

Forum » Dynamicweb 9.0 Upgrade issues » Upgrading from 9.12.5 to 9.13.10 causes a AccessUserTreeSection error

Upgrading from 9.12.5 to 9.13.10 causes a AccessUserTreeSection error

E-mail notifications
Claus Kølbæk
Claus Kølbæk
Reply
Posted on 09/08/2022 15:01:03

Hi

I have upgraded a local install, to 9.13.10 and the usermanagement tab is wierdly completely empty. If I select "change password" through the upper right short cut, I instead get the following error:

[IndexOutOfRangeException: AccessUserTreeSection]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +205
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +138
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +21
   Dynamicweb.Security.UserManagement.GroupRepository.Fill(Group group, IDataReader reader) +1421
   Dynamicweb.Security.UserManagement.GroupRepository.GetGroups() +254
   Dynamicweb.Security.UserManagement.Group.get_AllGroups() +174
   Dynamicweb.Admin.UserManagement.EditUser.Page_Load(Object sender, EventArgs e) +339
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +154
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4082

The solution is using custom user and group types, though I don't know if that has any effect on this problem. 

I also tried upgrading the Dynamiweb.Security to 12.5.0 but also no effect here.

- Anyone know what this relates to and how to fix it? 

 


Replies

 
Nicolai Pedersen
Posted on 09/08/2022 17:18:14
Reply
This post has been marked as an answer

That fields is a new one for DW10 - AccessUserTreeSection.

The reason you get the error is that the field changes to DB is now being pushed in a new way. So in order to get that DB change, you need the latest Admin package that now references Dynamicweb.Updates (a new package) - and admin will ensure that the updates are being applied. 

But - you can just create that field on the database:
"ALTER TABLE [AccessUser] ADD [AccessUserTreeSection] [nvarchar](255) NULL"

Votes for this answer: 1
 
Nicolai Pedersen
Posted on 09/08/2022 17:18:33
Reply

Or roll back to a security package that is before June 22nd.

 
Claus Kølbæk
Claus Kølbæk
Posted on 09/08/2022 23:23:14
Reply

Hi Nicolai

I am (as far as I know) already running the latest admin package (9.13.10), and also have a version 1.0.0 of Dynamicweb.Updates - but it does not seem the admin ensures the updates have been applied.

Running the sql script worked however, so thank you for a solution.

 
Nicolai Pedersen
Posted on 10/08/2022 01:42:00
Reply

Hm - do you have a custom global.asax?

 
Claus Kølbæk
Claus Kølbæk
Posted on 10/08/2022 09:16:10
Reply

Nope, it was a fresh nuget install where I had just moved in the files folder and matched to a copy of the live database.

 
Nicolai Pedersen
Posted on 10/08/2022 11:26:29
Reply

Thanks for clarifying. Will have release manager look into it!

 

You must be logged in to post in the forum