NetServer Error when adding a field, can not view a Company in Service

Hello,

I was adding an Extra Field to the Company-table (contact). When I added it I got a sort of time out. I did it again and it was OK. Restart of NetServer was also OK. But now when I view a Company in Service, it fails with "A Netserver exception occured". 

I also deleted the field using Service and restartet NetServer. Still the same error. The field does not exist physical in table so the delete worked.

But the field exists twice in the Extra_Fields table.

Any ideas what to do?

We are using version 8.1 and NetServer version: SuperOffice 8.1 Build Release81_C-2017.11.23-01

The NetServer log says:

Message: Service call Archive.GetArchiveListByColumnsWithHeader failed with exception
Archive.GetArchiveListByColumnsWithHeader
Type: SuperOffice.Exceptions.SoException
Details:
at SuperOffice.CRM.Services.Implementation.ArchiveAgentLocal.GetArchiveListByColumnsWithHeader(String providerName, String[] columns, ArchiveOrderByInfo[] sortOrder, ArchiveRestrictionInfo[] restriction, String[] entities, Int32 page, Int32 pageSize, String options)
at SuperOffice.Services84.WcfService.WcfArchiveService.<>c__DisplayClass14_0.<GetArchiveListByColumnsWithHeader>b__0(ArchiveAgent agent, GetArchiveListByColumnsWithHeaderResponse response)
at SuperOffice.Services84.WcfService.SoWcfService`1.Execute[TRequest,TResponse](String methodName, TRequest request, OnExecute`1 execute)

Inner Element:
Message: Stack empty.
Type: System.InvalidOperationException
Details:
at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
at System.Collections.Generic.Stack`1.Pop()
at SuperOffice.CRM.ArchiveLists.RestrictionParsingHelper.PopConnectPush()
at SuperOffice.CRM.ArchiveLists.RestrictionParsingHelper.ParseTokenList(List`1 tokens)
at SuperOffice.CRM.ArchiveLists.RestrictionParsingHelper.GenerateSqlRestrictionFromExpansions(ArchiveRestrictionInfo[] restrictions, Dictionary`2 expansion)
at SuperOffice.CRM.ArchiveLists.QueryProviderBase`1.<GetRows>d__63.MoveNext()
at SuperOffice.CRM.Services.Implementation.BL.ArchiveListImplementation.GetArchiveListItems(Int32 pageSize, IArchiveProvider provider, String options, ArchiveResultInformation& resultInfo)
at SuperOffice.CRM.Services.Implementation.BL.ArchiveListImplementation.GetArchiveListByColumnsWithHeaderWithContext(String providerName, String[] columns, ArchiveOrderByInfo[] sortOrder, ArchiveRestrictionInfo[] restriction, String[] entities, Int32 page, Int32 pageSize, String options, String context)
at SuperOffice.CRM.Services.Implementation.ArchiveAgentLocal.GetArchiveListByColumnsWithHeader(String providerName, String[] columns, ArchiveOrderByInfo[] sortOrder, ArchiveRestrictionInfo[] restriction, String[] entities, Int32 page, Int32 pageSize, String options)

RE: NetServer Error when adding a field, can not view a Company in Service

It was solved when I deleted my View Company profile in Service. 

Av: Frode Follerås 1. mar 2018

RE: NetServer Error when adding a field, can not view a Company in Service

Was about to comment that you should try removing the profile.

 

I've seen this issue in some cases when upgrading SuperOffice, that in cases where there are some extra fields, and some of them might have been deleted, you'll get an error message when trying to browse the View - screen.

Good job in finding it out :) 

Av: Simen Mostuen Iversen 1. mar 2018