IO Error: could not resolve the connect identifier "<identifier>"

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• Autosys Workload Automation

Issue/Introduction

DBMaint contains the command below:

cmplapp.sh -runquery $AUTOSYS/config/cmplapp/batch.properties -dbconparam $AUTOSYS/config/cmplapp/connection.properties -outfmt $AUTOSYS/config/cmplapp/output.properties

 

It gets the error below:

CAUAJM_I_85000 Compliance Application running

CAUAJM_E_85100 Unable to open database connection.

Error details:

* IO Error: could not resolve the connect identifier  "<identifier>"

CAUAJM_E_85002 Compliance Application terminated with error [100]

 

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Cause

This problem is related to using the fully qualified TNS alias in the tnsnames.ora file. The SID value is extracted from the CA Workload Automation AE configuration file and using the TNS short name.

Resolution

DBMaint uses jdbc to connect to the Oracle DB.

The AutoSys Scheduler and AutoSys Application Server use the Oracle client to connect to the Oracle DB.

Please see the following tech doc on troubleshooting DBMaint DB connection errors: 
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/troubleshooting/troubleshooting-ae/cauajm-e-85100-dbmaint-connection-failure.html