Introduction


In some instances when using Document Search there could be a timeout with SQL, the following error will be present:


image  



Applies to

  • Spindle Document Capture v1.20 and newer
  • SDM

Resolution


1. Before making any changes in the XML file please stop the SDC service first (take a backup if required)

2. Please navigate to the folder where the SDC Data is


image


C:\ProgramData\Draycir\Spindle Document Capture\Server\Data


Open up the DatabaseConfiguration.XML


image

<SqlCommandTimeout>0</SqlCommandTimeout>

From 0 to 300 as shown below are re-start the service
<SqlCommandTimeout>300</SqlCommandTimeout>

Once the changes have been made re-start the service and please try to Search



This should resolve the issue with document search 


Related Product
SDC/SDM
Ref Number
KBA-02-03-009
Document Date
01-02-2018
Original Author
Vijay Mistry
Document Version
v1.0
Last updated
01-02-2018
Update Author
Vijay Mistry