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

book

Article ID: 142598

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Workload Automation AE

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]

 

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.

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

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