How often does Service Desk Manager try to reconnect to a database server? How many times does Service Desk Manager retry to establish the connection?
Service Desk Manager 14.x and 17.x
All Supported SQL databases
When Service Desk fails to connect to a database server, it retries to connect to the database server 5 times every 5 seconds by default. In order to change the values, please add the following variables to NX.env and NX.env_nt.tpl by running pdm_options_mgr command.
Maximum number of retries:
NX_SQL_CONNECTION_RETRY= (desired value)
e.g. Change the maximum number of retry to 10 times
pdm_options_mgr -c -s SQL_CONNECTION_RETRY -v 10 -a pdm_option.inst
How many seconds to wait for retry:
NX_SQL_CONNECTION_WAIT= (desired value)
e.g. Change the frequency to retry to 10 seconds
pdm_options_mgr -c -s SQL_CONNECTION_WAIT -v 10 -a pdm_option.inst -t