AAI Scheduler fails to update Job Definitions due to ORA-28000 (Account Locked)

Products

• Automation Analytics & Intelligence

Issue/Introduction

Problem The AAI scheduler is failing to retrieve or update Job Definitions from the AutoSys database. The AAI logs show connection failures, specifically the following Oracle error: ORA-28000: The account is locked.

Symptom

• Job definitions in AAI have not updated for an extended period.
• The jaws.log or conversion service logs contain ORA-28000 errors related to the database account used by AAI to connect to AutoSys.
• The following error sequence may be present in logs: WARN [BasicResourcePool] ... ORA-28000: The account is locked. AutosysDataFactoryImpl.getDataSource → ConnectionFailureException → SessionUnavailableException → JawsException: Cannot open connection.

Environment

AAI with AutoSys scheduler

Cause

The database account credentials configured in AAI to connect to the AutoSys (Oracle) database have been locked by the database administrator or have exceeded failed login attempts, preventing AAI from establishing a valid connection to pull job definitions.

Resolution

1. Unlock the Account: Coordinate with your AutoSys database administrator (DBA) to unlock the database account being used by AAI and ensure the password is reset/current.
2. Take Scheduler Offline in AAI:
   • Open the AAI Configuration tool.
   • Navigate to the Other tab.
   • Set the scheduler to Offline (it is recommended to do this with the AAI service stopped).
3. Update Credentials in AAI:
   • Edit the scheduler configuration.
   • Update the password to match the newly reset password in Oracle.
   • Click Test Connection to verify that AAI can successfully communicate with the database.
4. Restore Connectivity:
   • If the test connection is successful, save the configuration.
   • Set the scheduler back to Online.
   • Click Update to force AAI to refresh the job definitions.
5. Verify: Monitor the jaws.log or conversion logs to confirm that the scheduler is communicating with the database and that job definitions are updating as expected.