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