Question:
How to set Timeouts for Database Connections and Commands?
Answer:
Settings for the database connections are contained in the file DocuWare.DAL.dll.config. (DAL = Data Access Layer)
There is a separate copy of this file for DocuWare Server and other components (e.g. DocuWare Local Data Connector). Find below an overview of places, where the file can be found (DocuWare 7.x)
Important files in C:\Program Files (x86)\DocuWare are highlighted below:
Within C:\Program Files\DocuWare you will be able to find / modify the following files:
Timeout for Connections and Commands
Apart from the regular commands, DocuWare also has commands with a long expected run-time.
These commands are usually run for administrative operations, e.g. creating a new column, column index or fulltext.
These commands take longer than regular commands because the size of the tables involved determines how long they take to run. If necessary, you can adjust the values, which are all in seconds.
ConnectionTimeout="x" | Timeout for creating a connection to the database, |
CommandTimeout="y" | Timeout for standard commands, default value: 30 sec. |
LongCommandTimeout="z" | Timeout for commands with a long expected run-time, |
If you use a DocuWare version older than 5.1b SP3…
- … and large fulltext file cabinets, you should go to the DocuWare.DAL.dll.config file in the Workflow Server and manually set the LongCommandTimeout value to 1200.
- … and would like to add file cabinet fields or column indexes later, you should go to the DocuWare.DAL.dll.config file in the Content Server and manually set the LongCommandTimeout value to 1200. A higher value is particularly useful if you are using MySQL.
What is the important part within DocuWare.DAL.dll.config?
The significant lines are line 2 and 3 – here in green (commented) and starting with the <dataSettings> tag (Notepad++ XML language highlighting)
Line 2 contains all default values. Those values can be copied and applied to line three. See below an example with increased ConnectionTimeout and CommandTimeout. (below example has an additional line break to include all default parameters)
In the above example, the default values ConnectionTimeout and CommandTimeout have now been set to 60 and respective 240 seconds. Do not forget to save the file after your modification and restart DocuWare.