Connection Timeout Interval Customization
Copyright © 2020 EarthSoft, Inc • Modified: 24 Feb 2020
The connection timeout can be modified with an Application-Level Security (ALS) login (aka EQuIS Enterprise login) for users running reports in EQuIS Professional. To modify the timeout setting, you must have Administrator permissions in the ST_ROLE table.
Modify the ALS Login Timeout Setting:
1.Make a backup of your database.
2.Login to EQuIS Professional.
3.Navigate to the ST_ROLE table and select the ALS user whose timeout period needs to be modified.
4.Append the desired connection timeout period in seconds to ST_ROLE.CONNECTION_STRING:
Data Source=XXXX;User ID=XXXX;Password=XXXX;Database=;Connection Timeout=600;
5.Save your changes.
•Modifying the connection timeout in ST_ROLE.CONNECTION_STRING for an ALS user applies to the tasks that the user does in Professional while logged in to Professional with their Enterprise ALS credentials, for example, running reports in Professional. This will not apply to the tasks that the user does in the Enterprise web application (e.g., running reports in Enterprise).
The timeout settings are based on SQL Server; EQuIS does not limit the timeouts. Theoretically, the maximum timeout setting for .NET v4 SQL Server connections is 2147483647 seconds. Refer to this Microsoft article on Connection Strings for more information.
The timeout should be set with caution as it effects database performance. For example, values of multiple hours will not cause any immediate problems, but big queries will continue to run until they are finished or until the timeout is reached.
Note: In EQuIS Enterprise 7, if an ALS connection string has been configured for the Admin role (or any other role to which the administrator belongs), then that connection string will be used. However, if none of the administrator's roles has an ALS connection string configured, then the main Enterprise connection string will be used.
The Enterprise Connection Timeout Setting can be changed in the connectionStrings.config file. This will need to be changed on the server.
Modify the Enterprise Timeout Setting:
1.Navigate to the connectionStrings.config file located in the \Program Files\EarthSoft\Enterprise7\bin folder.
2.Make a copy of the file so there is a backup to restore. Make sure to rename the copy.
3.Navigate to the following text:
<add name="localhost" connectionString="Data Source=localhost;User ID=username;Password=pwd;Database=demo;Pooling=true;Connection Timeout=300;"
a.If the connectionstring is encrypted, contact email@example.com to get an unencrypted version of the connectionstring.
4.Append the Connection Timeout period in seconds. EarthSoft normally keeps this timeout setting lower to reduce issues with server performance. For example, if a user runs a large report that takes several minutes, the timeout would normally stop the process so the performance is not impacted.
5.Restart your Worfklow Service.
6.Additionally, EarthSoft recommends restarting the Services in the IIS Manager after making any adjustments to the connectionstrings.config file.