Autosys Scheduler stops updating events in AAI: ORA-28000: the account is locked

Products

• Automic Automation Intelligence

Issue/Introduction

 

The hibernate.log file in the AAI /<install dir>/jboss/standalone/log directory shows:

INFO [AbstractDbSessionHandler] Testing connection with default syntax for scheduler "AutoSys"

 

WARN [BasicResourcePool] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@179be8d9 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (1). Last acquisition attempt exception: : java.sql.SQLException: ORA-28000: the account is locked

 

Environment

Release : 6.2.0-2

Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR BMC

Resolution

The error below indicates the Oracle database user configured in AAI to connect to an Autosys scheduler running Oracle is locked out.

ORA-28000: the account is locked

 

You will need your Autosys DBA to unlock the account that AAI is using to connect to the Autosys database.

Then if the password gets changed it would need to be updated in AAI on the Admin->Schedulers tab and select "Test Connection" to verify the connection is successful.

 

Once the db account is unlocked and the password is updated in AAI for that scheduler, I would try another Test Connection and if it succeeds it should start updating the events for Autosys again.