All change requests are stalled or in open state in RSA Identity Governance and Lifecycle
Originally Published: 2019-01-25
Article Number
Applies To
RSA Version/Condition: 7.0.2
Issue
The first instance of this issue always starts with following error in WorkPoint.log.
2018-04-11 05:16:48,052 [default task-110] ERROR com.workpoint.services.impl.GenericServiceImpl - Exception occurred. org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) at com.workpoint.server.ConnectContext.getConnection(Unknown Source) at com.workpoint.server.ConnectContext.connect(Unknown Source) at com.workpoint.services.impl.GenericServiceImpl.A(Unknown Source) at com.workpoint.services.impl.GenericServiceImpl.createServerContextForUpdate(Unknown Source) at com.workpoint.services.impl.JobUpdateServiceImpl.insertJobMonitors(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:266) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy125.insertJobMonitors(Unknown Source) at com.workpoint.server.monitor.MonitorHelper.insertJobMonitor(Unknown Source) at com.workpoint.server.WPServerController.A(Unknown Source) at com.workpoint.server.WPServerController.checkDBLicense(Unknown Source)
Once this occurs, the WorkPoint log repeatedly logs following error.
2018-04-11 05:16:48,063 [default task-110] ERROR com.workpoint.services.impl.GenericServiceImpl - LicenseException occurred: The resource license for DSN WPDS could not be verified due to a database error. Please make sure the database connection is working properly. See the server log for error details. com.workpoint.common.exception.LicenseException: The resource license for DSN WPDS could not be verified due to a database error. Please make sure the database connection is working properly. See the server log for error details. at com.workpoint.server.WPServerController.A(Unknown Source) at com.workpoint.server.WPServerController.checkDBLicense(Unknown Source) at com.workpoint.server.ServerProperties.checkDBLicense(Unknown Source) at com.workpoint.services.impl.WorkItemServiceImpl.queryByID(Unknown Source) at com.workpoint.client.WorkItemEntry.queryByID(Unknown Source)
Cause
Resolution
7.02 P09 and higher
7.10 P02 and higher
Workaround
For other workaround, contact RSA Support.
Related Articles
Form Level Request Workflows are bypassed if the Application is restarted while the Change Request is in an Open State in … 69Number of Views User Access Rule is not generating the Change Request due to open violations. 26Number of Views Requests in state "Waiting On Dependencies" remain stuck in the fulfillment phase in RSA Identity Governance & Lifecycle 189Number of Views Xudad core dumps randomly but when it does it is typically around 20 min or 50 min on the hour 5Number of Views Data purging fails with ORA-02292: integrity constraint (AVUSER.FK_xxxxxx violated - child record found) in RSA Identity G… 180Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?