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
- Administrative privileges to the ADSelfService Plus server
- A text editor such as Notepad or Notepad++
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
New to ADSelfService Plus?
Related Articles
Migrating from ADSelfService Plus 32-bit to ADSelfService Plus 64-bit
This article will help you migrate from ADSelfService Plus 32-bit version to the 64-bit version. Before you begin 32-bit to 64-bit migration is possible only between the same builds. For example, you cannot migrate from a 32-bit version of build 5310 ...Configuring high availability in ADSelfService Plus
ADSelfService Plus utilizes automatic failover to support high availability in case of system and product failures. Essentially, this means that when the ADSelfService Plus service on one machine fails, another instance of ADSelfService Plus running ...Encryption and data storage in ADSelfService Plus database
Encryption in the ADSelfService Plus database ADSelfService Plus' database uses the following encryption methods to store sensitive data: Database Encryption method PostgreSQL AES-256-CBC Microsoft SQL AES-256-CBC The following sensitive information ...How to migrate the ADSelfService Plus installation from one machine to another
Description This article will guide you through the process for migrating the ADSelfService Plus installation from one machine to another. Important: Before you start the migration process, please update your ADSelfService Plus installation to the ...Automatically backup the ADSelfService Plus database
Description The database used in ADSelfService Plus houses some important information that is crucial for the proper functioning of the tool. As a proactive measure against the loss of data, the ADSelfService Plus application provides you Automatic ...