Oracle error when running Compliance Application

book

Article ID: 128048

calendar_today

Updated On:

Products

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

Issue/Introduction

In DBMaint.out we see following error message:

CAUAJM_I_85000 Compliance Application running
CAUAJM_E_85100 Unable to open database connection.
Error details:
* ORA-28002: the password will expire within 7 days

CAUAJM_E_85002 Compliance Application terminated with error [100]

However when I logon to DB with aedbadmin user there's no such message.
Which userid is being used that runs the Compliance Application?

Environment

Release:
Component: UWCC

Resolution

It is not aedbadmin user that is being used but the user specified in $AUTOUSER/config.$AUTOSERV in the following parameter:
# Keyword: DBAccess=username/password

Use sqlplus with this userid/password and you will get the warning as well.

You can run 'autosys_secure' and choose option 3 "Change database password'. This will update accordingly the config file.
 

Additional Information

Or you can check with your Oracle DBA to change the life time of the password to never expire/unlimited for this particular user