How to troubleshoot database exception? Connection authorization failure occurred. Reason: Password expired. ERRORCODE=-4214, SQLSTATE=28000.

Document ID : KB000023894
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction/Summary: 

The CA Workload Automation DE (dSeries) server could not be started due to the error message as the server could not connect to the DB2 database.

Background:  

This is a DB2 database exception error reported in the CA Workload Automation DE (dSeries) server tracelog file.

20100209 10:25:33.821 [ID:   0] CybEspressoRdbFailOverHandler:  com.ibm.db2.jcc.b.mm: 
   [jcc][t4][2012][11248][3.50.152] Connection authorization failure occurred. 
   Reason: Password expired. ERRORCODE=-4214, SQLSTATE=28000

Environment:  

IBM DB2 database on supported versions (with the CA Workload Automation DE server installed on AIX and z/Linux only)

Instructions: 

The error message points to database connection issue. To resolve the issue, please liaise with your Database Administrator (DBA) and check the following;

  1. The database is running and connection to the database server is working.

  2. The database user ID and password are valid and functional.

If the database user's password is reported as expired, do either of the following options;

  1. a) Change the password in the DB2 database configuration.

    b) Change the CA (dSeries) Workload Automation database connection properties using 'setdbparm' utility (the parameter to change is rdbms.password')

  2. Extend the expiration of the database user's password.

Additional Information:

Configuring the Database Connection