Oracle error when running Compliance Application

Products

• CA Workload Automation AE - Scheduler (AutoSys)

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?

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