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 269Number of Views Form Level Request Workflows are bypassed if the Application is restarted while the Change Request is in an Open State in … 75Number of Views RSA Governance & Lifecycle 8.0.0 AFX Retry Configuration Guide 24Number of Views RSA Identify Governance and Lifecycle WorkDay Identity Collector "unexpected element " error 32Number of Views RSA Identity Governance and Lifecycle IBM Lotus Notes (Domino) collector does not collect group data. 50Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?