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 How to close Open Violations for inactive Segregation of Duties (SoD) and User Access Rules in RSA Identity Governance & L… 76Number of Views Query for users with tokens and enabled for On-Demand Authentication in RSA Authentication Manager 8.2 25Number of Views XML files are filling up the D:\tmp\ directory in RSA enVision Core 4.0.0 15Number of Views Edit a Security Domain 7Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?