ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Compliance App Fails from Scheduler but works from command line

book

Article ID: 214144

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

When the Scheduler runs DBMaint, the Compliance App portion fails with the following error...

CAUAJM_I_85000 Compliance Application running
CAUAJM_E_85100 Unable to open database connection.
CAUAJM_E_85002 Compliance Application terminated with error [100]

If DBMaint is run manually from the command line, the Compliance App works without error. 

Environment

Release : 12

Component : AUTOSYS WORKLOAD AUTOMATION

Resolution

Ensure the TNS_ADMIN variable that is read into the Scheduler environment is pointing to the correct location for the tnsnames.ora file. For UNIX, check $AUTOUSER/autosys.sh.<hostname> for the variable setting. On Windows, check the System tab in the AutoSys Administrator.