How to set connection login timeout for all Information Services data sources

Product:TIBCO Spotfire Server
Versions:10.10 and Above

Summary:
This article provides information on how to set connection login time for all the Information Services data sources (JDBC) .

Details:

When all available connections in the connection pool to the particular data source are occupied and the maximum allowed connection has been reached and the server cannot get a free connection within 10 seconds(default waiting timeout), any new connection to the data source would give an error.

The login timeout can be set across all Information Services data sources (that doesn't have values configured for the particular data source) using the information-services.jdbc.connection-login-timeout configuration property (the value is given in seconds, the default is 10).

Note: <connection-login-timeout> is the global setting for all information link data sources if no data source level login timeout is configured. The data source level login timeout value can be set in data source template " $m{loginTimeoutSeconds} ".
Value for the $m{loginTimeoutSeconds} comes from the configuration information-services.jdbc.connection-login-timeout, which has default value of 10. Data source would use this default value unless you have set some custom value in place of $m{loginTimeoutSeconds}.

Document: Information Services settings 
https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/information_services_settings.html

Resolution:
Please follow the below steps to set the Information Services login timeout in the Tibco Spotfire Server configuration using command line.

1. On the computer running Spotfire Server, open a command line as an administrator and change the directory to the location of the config.bat file (config.sh on Linux). The default location is <installation dir>/tomcat/spotfire-bin.
2. Export the active configuration to a configuration.xml file by using the export-config command.
3. The configuration.xml file appears in your working directory.
4. Run the following command in command prompt and update with your required value:    
   • config set-config-prop --name=information-services.jdbc.connection-login-timeout --value=10
5. Import the configuration using import-config command.
6. Command prompt would show the message of successfully importing configuration file.
7. Restart the TIBCO Spotfire server

Another way to update using the Configuration tool UI:

1. Go to the XML view tab. Edit the configuration.
2. Find and update the following tag to required value: <connection-login-timeout>10</connection-login-timeout>
3. Click Update button to update the configuration.
4. Click "Save Configuration" in the Configuration tab.
5. Restart the TIBCO Spotfire Server.