Currently experiencing an issue with the Splunk (version 6.4.4) connection timing out with ChangeGear. We have integrated Splunk to monitor ChangeGear (version 6) ticketing. We run a ChangeGear database and ChangeGear application on separate servers.
The error we are receiving is:
Exception(' java.sql.SQLTransientConnectionException: ChangeGear-db2 - Connection is not available, request timed out after 30000ms..',).
Common Answers seem to be:
https://answers.splunk.com/answers/337702/splunk-db-connect-2-why-am-i-getting-error-cannot.html
⎝ Increase max connections.
https://answers.splunk.com/answers/488736/why-does-splunk-dbconnect-execute-query-transactio.html
⎝ useConnectionPool = false
https://answers.splunk.com/answers/475392/splunk-db-connect-how-to-resolve-dbxquery-error-fa.html
⎝ upgrade to 2.4.0
⎝ maxWaitMillis = 60000