An unexpected error using Web

Hi Forum.

A customer is getting this kinda error-messages when using 8.4 Web - On windows client there is no problems.

'An unexpected error occured'

It appears different for different users - for example with my admin user, I can't access the following

  • Sale where Owner is a certain other associate
  • Note tab on person

I've tried to run a consistency check in dbSetup without luck.

I've trid extented loggin in netserver, but it doesn't give me much more than shown in the error message below.

So do you have any idea why this is happening?

 

Object reference not set to an instance of an object.
Source: SoDataBase
Click here to see stacktrace
at SuperOffice.CRM.Lists.VisibleForListProvider.CompareGroupsByName(Int32 leftId, Int32 rightId)
at System.Collections.Generic.ArraySortHelper`1.InsertionSort(T[] keys, Int32 lo, Int32 hi, IComparer`1 comparer)
at System.Collections.Generic.ArraySortHelper`1.IntrospectiveSort(T[] keys, Int32 left, Int32 length, IComparer`1 comparer)
at System.Collections.Generic.GenericArraySortHelper`1.Sort(T[] keys, Int32 index, Int32 length, IComparer`1 comparer)


Click here for more information
Failed to compare two elements in the array.
Source: mscorlib
Click here to see stacktrace
at System.Collections.Generic.GenericArraySortHelper`1.Sort(T[] keys, Int32 index, Int32 length, IComparer`1 comparer)
at System.Array.Sort[T](T[] array, Int32 index, Int32 length, IComparer`1 comparer)
at System.Collections.Generic.List`1.Sort(Comparison`1 comparison)
at SuperOffice.CRM.Lists.VisibleForListProvider.AddItems()
at SuperOffice.CRM.Lists.LiteralsOnlyBase.Construct(String listName, String additionalInfo, Int32[] historyIDs, Boolean onlyReadHistory, String searchValue, Boolean forceFlatList)
at SuperOffice.CRM.Lists.SoListProviderFactory.SuperOffice.Factory.IPrivateFactory.Create(Type type, Type[] constructorArgumentTypes, Object[] constructorArguments)
at SuperOffice.Factory.TypeFactories.Create(Type type, Type[] constructorArgumentTypes, Object[] constructorArguments)
at SuperOffice.Factory.ClassFactory.Create(Type type, Type[] constructorArgumentTypes, Object[] constructorArguments)
at SuperOffice.CRM.Lists.SoListProviderFactory.Create(String listName, String additionalInfo, Int32[] historyIDs, Boolean onlyReadHistory, String searchValue, Boolean forceFlatList)
at SuperOffice.CRM.Lists.SoListProviderFactory.Create(String listName, String additionalInfo, Boolean readOnlyHistory, Boolean forceFlatList)
at SuperOffice.CRM.Services.Implementation.MDOAgentLocal.GetList(String name, Boolean forceFlatList, String additionalInfo, Boolean onlyHistory)

Service call MDO.GetList failed with exception
MDO.GetList
Source: SuperOffice.Services.Implementation
Click here to see stacktrace
at SuperOffice.CRM.Services.Implementation.MDOAgentLocal.GetList(String name, Boolean forceFlatList, String additionalInfo, Boolean onlyHistory)
at SuperOffice.CRM.Web.UI.Controls.SoVisibleForList.DataBind()
at SuperOffice.DCF.Web.UI.PageBuilderHelper.DataBindControls(ICard card)
at SuperOffice.DCF.Web.UI.Controls.PageBuilder.OnPreRender()
at SuperOffice.DCF.Web.UI.Controls.PageBuilder._page_LoadComplete(Object sender, EventArgs e)

 

 

RE: An unexpected error using Web

Hello Kasper,

Could you run the following SQL querys:

SELECT * FROM crm.VISIBLEFOR 
WHERE forGroupId > 0
AND forGroupId NOT IN (SELECT crm.USERGROUP.UserGroup_id FROM crm.USERGROUP)

SELECT * FROM crm.ASSOCIATE 
WHERE group_idx > 0
AND group_idx NOT IN (SELECT crm.USERGROUP.UserGroup_id FROM crm.USERGROUP)

SELECT * FROM crm.ASSOCIATEGROUPLINK 
WHERE group_id > 0
AND group_id NOT IN (SELECT crm.USERGROUP.UserGroup_id FROM crm.USERGROUP)

Based on the error messages you provided it looks like the VisibleForListProvider is trying to compare the names of two user groups, where one could be null because it doesnt exist anymore.

So if one of these query's gives a result there are references to non-existing usergroups.

Av: David Hollegien 2. sep 2020

RE: An unexpected error using Web

Hi David - thank you for your suggestion.

Unfortunately this doesn't results in any rows.

Av: Kasper Rosenlund 3. sep 2020