Database Test For New AutoSys Instance Config Failing

Document ID : KB000112364
Last Modified Date : 28/08/2018
Show Technical Document Details
Issue:
The Oracle database connection test for a new AutoSys instance configuration in iDash is failing with no specific error.
Resolution:
The specific error encountered when iDash attempts to connect with Oracle for an AutoSys database connection test will be logged in either the <IDASH_HOME>/log/info.log or <IDASH_HOME>/log/error.log. Check these logs to determine specific error and address based on the error content. Typical root causes are...

Incorrect jdbc connection string leading to Oracle network/connection error
Incorrect schema owner specification. This should be "aedbadmin" for all 11.3+ AutoSys instances
Incorrect database user password