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.


1. Open SQL Server Management Studio. 

2. Expand the tables in the Draycir.SDC Database

2. Locate the "dbo.DataSets table

3. Right click on the table and "select Top 1000 Rows"



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