K2 and SQL connection attempts
kbt157701
PRODUCTObjective
When K2 temporarily loses its connection to the SQL server hosting the K2 database, it will try to re-establish the connection for a number of times. After subsequent failed attempts, only then will the K2 service stop.
There are settings in the K2HostServer.exe.config file that we can tweak to set the number of attempts as well as the interval between each attempt.
Before You Begin
Make a backup of the K2HostServer.exe.config.How-to Steps
The following settings in the K2HostServer.exe.config file determines:
- dbconnretries: The number of times K2 will attempt to re-establish its connection to the SQL server
- dbconnretrydelay: The interval between each attempt (in milliseconds)
<add key="dbconnretries" value="100" />
<add key="dbconnretrydelay" value="30000" />