Request access from Identity Portal causes an error "Request Failed"

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

When user tries to request access to any role receives a popup message "Request Failed"

Environment

Identity Portal 14.x

Cause

The "Request Failed" message has a different root cause.

In this case, analyzing the Identity Portal log file there are the following messages:

===============================

2020-06-08 09:41:00,007 ERROR [com.idmlogic.sigma.workers.utils.ExceptionsHelper] (default task-20) : javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
 at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) [hibernate-entitymanager-5.0.3.Final.jar:5.0.3.Final]
 at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602) [hibernate-entitymanager-5.0.3.Final.jar:5.0.3.Final]

...

Caused by: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection

...

Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction

===============================

Resolution

In this case, the root cause was the loss of connection with the Database, you need to check the following:

- Check if the database is up and running and if it is possible to connect to it using the same credentials used by Identity Portal.

- If database is ok, stop and start the Identity Portal service to re-establish the connection with the database.