KBA-02-03-009 - Extend The SQL Command Timeout When Document Search Fails

Modified on Thu, 1 Feb, 2018 at 11:25 AM

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




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article