I have updated a DW solution for our client from 9.13.5 to 9.14.3. This will result in an similar to this when trying to navigate the group structure:
System.IndexOutOfRangeException: GroupType at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) at System.Data.SqlClient.SqlDataReader.get_Item(String name) at Dynamicweb.Ecommerce.Products.GroupRepository.ExtractGroup(IDataReader dataReader) at Dynamicweb.Ecommerce.Products.GroupRepository.GetGroups()
This is caused by a missing column in the database. The missing column is:
- EcomGroups --> GroupType (int, null)
This does not seem to be included in the update scripts to add this column. I have added of course added the column manually, but I thought you might want to know.