How to handle database connection failures in ADSelfService Plus
Objective
This article explains how to configure ADSelfService Plus to extend the retry period before halting its service in case of database connection failures. By default, ADSelfService Plus retries the database connection for 10 seconds before stopping the service. Increasing this timeout enhances resilience, especially in environments where database failover or temporary network issues may require longer recovery times.
Prerequisites
Steps to follow
Go to the following directory on the ADSelfSelfService Plus server: <installation_dir>\conf\ (replace <installation_dir> with the actual installation path of ADSelfService Plus; by default, the path is C:\Program Files\ManageEngine\ADSelfService Plus).
Locate the file named configuration.properties within the conf folder. Open this file using a text editor with administrative privileges.
Add the following line to the configuration.properties file. If the line check.dbcrash.delay already exists, modify its value:
check.dbcrash.delay= xSet x to the number of seconds ADSelfService Plus should wait and retry the database connection before it halts the service due to a persistent connection failure.

Note: A value of 40 seconds is recommended as a starting point, increasing the default retry period.
Save the changes to the configuration.properties file.
Restart the ADSelfService Plus service for the new setting to take effect.
Validation and confirmation
Simulate a database downtime and monitor the ADSelfService Plus logs. Observe the wrapper.log file (located in <installation_dir>\logs) for messages related to database connection attempts.
Verify that the application now attempts to reconnect for the configured duration (e.g., 40 seconds) before displaying a critical error or halting.
Check the service status after the retry window to verify if it recovers or shuts down.
Tips
Adjust the value based on your database availability and failover setup. For example: Set the value as 300 if you need the application to wait for five minutes before halting.
Always maintain a backup of the configuration file before making changes.
Regularly monitor application logs (located in the logs folder of the installation directory) to diagnose connection issues promptly.
Consider setting up alerts or integrating monitoring tools to detect database issues proactively.
How to reach support
If the issue persists, contact our support team here.
New to ADSelfService Plus?