All change requests are stalled or in open state in RSA Identity Governance and Lifecycle
Originally Published: 2019-01-25
Last Modified: 2023-09-22
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
RSA Identity Governance & Lifecycle requests stuck in an open state due to datafile resizing 272Number of Views Installer prerequisite fails on files that are not relevant to the RSA Governance & Lifecycle deployment 148Number of Views RSA Identity Governance and Lifecycle IBM Lotus Notes (Domino) collector does not collect group data. 50Number of Views Partial failure in creating change requests with Java NPE error in RSA Governance & Lifecycle 390Number of Views The Cancel Pending Requests button on the Pending Submissions page is disabled in RSA Identity Governance & Lifecycle 68Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?