Database timeout for CA Process Automation

Products

• CA Service Desk Manager

Issue/Introduction

When the PAM databases are offline, the system hangs on the connection indefinitely. Is it possible to set a timeout?

Environment

Release : 17.1

Component : PROCESS AUTOMATION CONTENT FOR SDM

Resolution

The database connection definitions for the three main PAM database schemas (runtime, library, reporting) are in the PAM\server\c2o\.config\OasisConfig.properties file. In it you'll find lines like this:

#Defines parameters that are used to create the database connection.
oasis.database.additionalparamurl=;responseBuffering=full;SelectMethod=cursor;socketTimeout=0

#Defines the additional parameters to use for creating the database connection.
oasis.reporting.database.additionalparamurl=;responseBuffering=full;SelectMethod=cursor;socketTimeout=0

#Defines the additional parameters that are used to create the database connection.
oasis.runtime.database.additionalparamurl=;responseBuffering=full;SelectMethod=cursor;socketTimeout=0

As you can see, the default is for no timeout on the connection.

This timeout is specified in milliseconds, as per the Microsoft documentation: https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15