DBMaint - Failing with exit code 100

Products

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

Issue/Introduction

DBMaint script is failing with status code '100'. Error encountered while running DBMaint script:

Error message: 

$ grep DBMaint event_demon.PR1.04272020
[04/27/2020 03:30:01]      CAUAJM_I_20218 Executing Command: exec $AUTOSYS/bin/DBMaint, DBMaint 0.
[04/27/2020 03:32:33]      CAUAJM_I_40266 DBMaint is ended with: normal termination, exit status = 100
[04/27/2020 03:32:33]      <Error encountered while running DBMaint script!>

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

DBMaint runs daily and returns the following error messages:

CAUAJM_I_85000 Compliance Application running
CAUAJM_E_85100 Unable to open database connection.

Error details:

* IO Error: could not resolve the connect identifier "autsysprod"
CAUAJM_E_85002 Compliance Application terminated with error [100]


The encountered problem is related to the “Compliance Application”.

The recommended solution is to comment out the following line:

cmplapp.sh -runquery $AUTOSYS/config/cmplapp/batch.properties -dbconparam $AUTOSYS/config/cmplapp/connection.properties -outfmt $AUTOSYS/config/cmplapp/output.properties >> $outfile 2>&1


This change needs to be performed in “DBMaint” script under $AUTOSYS/bin directory.


This will be taken account automatically on the next run of DBMaint.