Autosys event server database password expires or is forgotten

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

The application generated a message that the database password expired.
The DBA reset the password and the error was gone.

The application server log still shows the following errors:

CAUAJM_E_18407 Failed to connect to Oracle server:
CAUAJM_E_18408 Invalid connect string specified. 
CAUAJM_E_10649 Server (EventServer) was not available during the connection operation. , 

Environment

Autosys 12.x

Resolution

The Autosys Config file contains an encrypted string for the AutoSys database user's password.
Linux:
$AUTOUSER/config.$AUTOSERV

Windows:
%AUTOUSER%\config.%AUTOSERV%

Example:
DBAccess=<Username>/<Enrtyptedpassword>

To get the encrypted string for the new password do the following:

• Run the CLI: autosys_secure
• Choose option 6 (Get Encrypted password).
• Then choose option 1 (Encrypt password for instance configuration (using AES).
  Enter the new password for the autosys database user and confirm the password.
  
  You should get the encrypted string for the password back to standard out and then copy this encrypted string to the below key:
  DBAccess=<Username>/<Enrtyptedpassword>
  
  in the Autosys Config file.
  
  
• Restart the AutoSys Scheduler and Application server.

Additional Information

The same process can be followed if the old database password is unknown and the database password must be updated.