IDM startup: "The datasource configuration of Task Persistence is invalid.: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/iam/im/jdbc/jdbc/idm"

Products

• CA Identity Suite

Issue/Introduction

Getting the following error during IDM start up

2023-02-10 10:30:00,492 INFO  [ims.Main] (ServerService Thread Pool -- 132) ################################################
2023-02-10 10:30:00,492 INFO  [ims.Main] (ServerService Thread Pool -- 132) ---- CA IAM FW Startup Sequence Initiated. ----
2023-02-10 10:30:00,500 INFO  [ims.Main] (ServerService Thread Pool -- 132) * Startup Step 1 : Attempting to start ServiceLocator.
2023-02-10 10:30:00,691 ERROR [ims.tmt.CreateDatabaseSchema] (ServerService Thread Pool -- 132) The datasource configuration of Task Persistence is invalid.: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/iam/im/jdbc/jdbc/idm

Environment

Release :  Identity Manager 14.4

Cause

This is caused by IDM failing to connect to the Task Persistence database.

Resolution

Modified database to use the correct database name and make sure the user has proper database privileges

Additional Information

We saw this issue when the database had too many connections from another source than IM.

Check with your DBA which system is using most connections of your database and troubleshoot (restart of this system worked - but this is not long term solution)