Problem
When attempting to complete one of the following processes in SDM on one specific Sage company
- Archive
- Print Bar-code
- Capture a Document
You may get the following "Errors" appear in the log file
Message: HandlingInstanceID: db43bd6e-a20a-4a63-93c6-131bad6965f4
An exception of type 'System.InvalidOperationException' occurred and was caught.
--------------------------------------------------------------------------------
05/09/2019 12:26:28
Type : System.InvalidOperationException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Sequence contains more than one element
Source : System.Core
Help link :
Data : System.Collections.ListDictionaryInternal
TargetSite : TSource SingleOrDefault[TSource](System.Collections.Generic.IEnumerable`1[TSource])
HResult : -2146233079
Applies to
Spindle Document Capture v1
Spindle Document Management v7
Spindle Document Management v8
Resolution:
This issue occurs as there are duplicate Dataset IDs present in the Draycir.SDC Database. The program has run a SQL query and is expecting a single record returned, but the database returns more than one.
As shown above there are Duplicate HostID's. In this instance we need to define from Sage which company is the erroneous company. We tend to determine this by the "CreatedOn" date which is should be different from the company in use.
In this case once the correct company is located, please backup the Draycir.SDC DB and proceed to change the HostID for the Erraneous Duplicate Company to "999"
Once completed, please shut Sage down on the local machine, end the process SDCUIHost.exe in Windows Task Manager.
Access the company in Sage and proceed to Capture a document, this issue should now be resolved
Knowledge Base Article Details
Related Product | Spindle Document Management |
Ref Number | KBA-05-03-012 |
Document Date | 09/05/2019 |
Original Author | Vijay Mistry |
Document Version | v1.0 |
Last updated | 09/05/2019 |
Update Author | Vijay Mistry |