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?
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
TEC1147347: After running pdm_options_mgr command to add a variable to NX.env or NX.env_tpl files, an existing last line of those files is replaced with a new variable added by the command.
TEC612988: Using the 'pdm_options_mgr' command to change content within the CA Service Desk Manager (CA SDM) NX.ENV file