search cancel

RA Banner Agent does not start after changing database password


Article ID: 109831


Updated On:


CA Automic Workload Automation - Automation Engine


After changing the password for the Banner database user Banworx, the RA Banner Agent fails with the following error in the logs:

20180801/163427.842 - U02000107 Connection object 'CONN.NAME' with time stamp '1533155624000' was successfully transferred to the Agent. 
20180801/163443.282 - Database login error 
20180801/163443.282 - Error connecting to the database. Check the JDBC login assigned to the agent and verify that it is correct. 

A forced stack trace is created with the error: 

java.sql.SqlRecoverableException: IO error: Connection reset


Release: AOMWSA99000-3.X-Automic Operations Manager-Web Services Base-Pack Agent (Incl. 5


Either the connection object passwords have not been changed, or the password is cached in the jdbc. 


Ensure that the passwords are changed in the connection objects. If this has already been done, then load a fresh JDBC following the steps below:

-Stop the RA Banner Agent
-Navigate to the Agent's bin/lib directory
-Copy the jdbc jar file to another folder as a backup
-Download the relevant .jar file for the database being used
-Delete the old file and replace it with the new jdbc jar file
-Restart the Agent