PRD IDM Down - will not start. IJ000453: Unable to get managed connection for java:/iam/im/jdbc/jdbc/idm

Products

• CA Identity Governance

Issue/Introduction

Vapp Identity Manager will not start.

2022-04-25 03:43:44,508 ERROR [ims.Main] (ServerService Thread Pool -- 97) The IAM FW Startup was not successful
2022-04-25 03:43:44,508 ERROR [ims.Main] (ServerService Thread Pool -- 97) java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/iam/im/jdbc/jdbc/idm

Environment

Release : 14.4

Component : Virtual Appliance.

Resolution

This can be caused by the following. 

1.  The Database is down.  Check with the DBA to confirm the SQL or Oracle database is up and running.

2.  Database password was changed or changes once every 6 months.  Change password configurations to never expire or set a schedule so teams using the database are aware and can prepare for the change. 

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-suite/14-4/virtual-appliance/Change-the-Password-of-Symantec-IGA-Components.html#concept.dita_6599601b-9f72-4020-924e-461f4ce8109c_ChangeDatabasePassword

Standalone:

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-manager/14-5/configuring/relational-database-management/create-a-jdbc-data-source.html

• Open login-cfg.xml in 

  jboss_home

  \server\default\conf.

3.  Max-pool-size on the database limit is reached. The values are found in ca-standalone-full-ha.xml (/opt/CA/wildfly-idm/standalone/configuration). Increase as needed.  I set to 1000.