Developer forum

Hi

I've tried to reproduce the issue via creating new database by wizard under 9.13.5 (to have EcomGroups without the field) and moving to 9.14.3 but was not able to catch it - the field is added successfully. I see "SqlUpdate.AddColumn("2", this, "EcomGroups", "GroupType", "[int] NULL")," code exists in C:\Projects\Dynamicweb\src\77 - Ecommerce\Dynamicweb.Ecommerce\Updates\EcommerceUpdateProvider.cs in fact and performed successfully per log (attached). So, the issue is specific one related to your solution only. Please, have a look at Monitoring-Event viewer's logs, 'Application/Update' or 'Application/Database' category to find error(s) related to the upgrade and show here if possible.

BR, Oleg QA 

Hi Oleg

Hmm weird, I was browsing the .aspx files in admin/update folder that was previously used for updating database, did you change this on 9.14.x to not use this anymore?

This is a solution that has been updated multiple times, and is not a fresh install of 9.13.5, and also running with Rapido as well, I don't know if that could have any impact. 

Where does the information found in "Monitoring" --> "Event Viewer" come from, is it from a table in the database or from files or somewhere else. Because my log indicate that an update script ran on 20. september, and we did run an update on this solution on 20. september, but it was on another environment and therefore another database.

Could this be the problem, that the solution thinks that this update already ran, but just not on this database?

The update applied last week skips these steps, because it seems like those we're run on 20. september:

• 1 Dynamicweb.Ecommerce.Updates.EcommerceUpdateProvider
• 2 Dynamicweb.Ecommerce.Updates.EcommerceUpdateProvid

​

BR Chris

Hi Chris,

Yup, old upgrade via script is not longer used, it's implemented using provider instead now. I've extra digged the issue and see the upgrade version (2) is specific one where upgrade was codded in not correct way initially (the version was related to other db change and changed to current one later). Probably, your db took initial upgrade but was not able to take correct last one. Sorry for inconvience, I supose the case like yours won't be exist in future. Thanks for commenting.

BR, Oleg QA 

Hi,

Did you manage to solve this? and how?

I have the same issue. Upgraded from 9.8.7 -> 9.13.13 -> 9.14.5.

Have tried to rerun upgrade scripts but it doesn't solve the issue

[IndexOutOfRangeException: GroupType]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +2158379
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +141
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +21
   Dynamicweb.Ecommerce.Products.GroupRepository.ExtractGroup(IDataReader dataReader) +3505
   Dynamicweb.Ecommerce.Products.GroupRepository.GetGroups() +212
   Dynamicweb.Ecommerce.Products.GroupService.InitializeCache() +122
   Dynamicweb.Caching.DictionaryCache`2.InitializeCacheDictionary() +155

Thanks. Worked like a charm