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)