Question:
How do I 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 the DocuWare Server and other components (e.g., DocuWare Local Data Connector). Please refer to the following guide for an overview of locations where the DocuWare.DAL.dll.config file can be found in DocuWare version 7 and higher;
The DocuWare.DAL.dll.config for the Authentication and Workflow server can be found in C:\Program Files (x86)\DocuWare;
Within C:\Program Files\DocuWare, you will be able to find/modify the DocuWare.DAL.dll.config files for the Background Process Server, Web Settings, Web Processes, Web Platform, etc.;
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?
Refer to the following lines when reviewing the DocuWare.DAL.dll.config.
<?xml version="1.0" encoding="utf-8" ?>
<!--<dataSettings LikeIgnoreCase="true" AutoTempTableListSize="200" LongCommandTimeout="600" UseAutoParameters="true" Pooling="True" MaxPoolSize="-1" ConnectionTimeout="30" ConnectionLifetime="-1" CommandTimeout="120" MaxBulkInserts="500" AutoParamGuidConversion="None ToLowerCase ToUpperCase" TimeBetweenDeadlockRetries="50" NumOfDeadLockRetries="5">-->
<dataSettings AutoTempTableListSize="200" LongCommandTimeout="1800" UsePerformanceCounters="true" UseAutoParameters="true">
<dataProviders>
Line 2 contains all default values. Those values can be copied and applied to the next line that begins with <dataSettings. In the below example, the default values ConnectionTimeout and CommandTimeout have now been set to 60 and 240 seconds, respectively.
<?xml version="1.0" encoding="utf-8" ?>
<!--<dataSettings LikeIgnoreCase="true" AutoTempTableListSize="200" LongCommandTimeout="600" UseAutoParameters="true" Pooling="True" MaxPoolSize="-1" ConnectionTimeout="30" ConnectionLifetime="-1" CommandTimeout="120" MaxBulkInserts="500" AutoParamGuidConversion="None ToLowerCase ToUpperCase" TimeBetweenDeadlockRetries="50" NumOfDeadLockRetries="5">-->
<dataSettings AutoTempTableListSize="200" LongCommandTimeout="1800" UsePerformanceCounters="true" UseAutoParameters="true" ConnectionTimeout="60" CommandTimeout="240" >
<dataProviders>
After you modify the file, remember to save it and restart DocuWare.
KBA is applicable to On-premise Organizations ONLY.