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


Article ID: 192913


Updated On:


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


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


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( [hibernate-entitymanager-5.0.3.Final.jar:5.0.3.Final]
 at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert( [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



Identity Portal 14.x


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.