Review items are reverted back since the change request gets cancelled with script error in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2018-04-19
Article Number
000041812
Applies To
RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.0, 7.0.1
 
Issue
The review item gets reverted back to the review since the change request gets cancelled with the following script error: 
State
Error -= InvocationTargetException caught when executing Java class. Command = '#Tue Oct 13 22:30:41 EDT 2009 Version=1 Method=evaluate JavaClass=com.aveksa.server.workflow.scripts.action.ConditionAction 
Parameter4=SymbolTable Parameter3=ThisJobNodeData Parameter2=ThisJobData Parameter1=ClientContext ParameterType4=OpTypeNotSpecified ParameterType3=OpTypeNotSpecified ParameterType2=OpTypeNotSpecified ParameterType1=OpTypeNotSpecified';
nested exception is: org.hibernate.UnresolvableObjectException: No row with the given identifier exists: [com.aveksa.server.core.cr.Change Request#1089] Error occurred in Statement #1 in Script ID7:WPDS, Script Name = 'SetTrueFalseCompletionCode', Script type = 'CompletionCode'.Job ID = 8697:WPDS, Process Ref = 'acm$crdelonly'. Node Name = 'Reset Password'

User-added image

You can see the errors in the /home/oracle/wildfly/standalone/log/workpoint.log:
2018-04-18 09:54:18,172 [Thread-15394 (HornetQ-client-global-threads-2032020861)] ERROR com.workpoint.server.script.ScriptEngine  - 
A script error has occurred. Error occurred in Statement #1 in Script ID 7:WPDS, Script Name = 'SetTrueFalseCompletionCode', Script type = 'Completion Code'. 
Job ID = 8698:WPDS, Process Ref = 'acm$crdelonly', Node Name = 'Reset Password'
org.hibernate.UnresolvableObjectException: No row with the given identifier exists: [com.aveksa.server.core.cr.ChangeRequest#1090]
	at org.hibernate.UnresolvableObjectException.throwIfNull(UnresolvableObjectException.java:65)
	at org.hibernate.event.def.DefaultRefreshEventListener.onRefresh(DefaultRefreshEventListener.java:165)
	at org.hibernate.event.def.DefaultRefreshEventListener.onRefresh(DefaultRefreshEventListener.java:62)
	at org.hibernate.impl.SessionImpl.fireRefresh(SessionImpl.java:1118)
	at org.hibernate.impl.SessionImpl.refresh(SessionImpl.java:1106)
	at com.aveksa.server.db.persistence.PersistenceServiceProvider.refresh(PersistenceServiceProvider.java:4230)
	at com.aveksa.server.db.persistence.PersistenceServiceProvider.lockAndRefresh(PersistenceServiceProvider.java:4202)
	at com.aveksa.server.db.persistence.PersistenceServiceProvider.lockAndRefresh(PersistenceServiceProvider.java:4196)
	at com.aveksa.server.db.PersistenceManager.lockAndRefresh(PersistenceManager.java:649)
	at com.aveksa.server.workflow.scripts.action.ConditionAction.evaluateChangeRequestConditions(ConditionAction.java:103)
	at com.aveksa.server.workflow.scripts.action.ConditionAction.evaluate(ConditionAction.java:76)
	at sun.reflect.GeneratedMethodAccessor531.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.workpoint.server.script.StatementEngineJava.execute(Unknown Source)
	at com.workpoint.server.script.ScriptEngine.A(Unknown Source)
	at com.workpoint.server.script.ScriptEngine.execute(Unknown Source)
	at com.workpoint.server.script.ScriptEngine.execute(Unknown Source)
	at com.workpoint.server.job.JobNode.changeState(Unknown Source)
	at com.workpoint.server.job.JobNode.changeState(Unknown Source)
	at com.workpoint.server.job.JobNode.isComplete(Unknown Source)
	at com.workpoint.server.job.Job.changeWorkItemState(Unknown Source)
	at com.workpoint.server.pojo.ServerAutomatedActivityMDBean.autoCompleteWorkItems(Unknown Source)
	at com.workpoint.server.pojo.ServerAutomatedActivityMDBean.autoCompleteWorkItems(Unknown Source)
	at com.workpoint.server.pojo.ServerAutomatedActivityMDBean.onMessage(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor304.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
Cause
This is a known issue and has been reported to our engineering team. 
Resolution
Upgrading to V7.0.1 or V7.0.2 will fix this issue.
Workaround
As a workaround, you can disable the Reset Password node (which is causing the issue in this scenario) from the workflow so that this node is skipped and the workflow will proceed to the next node.   To disable the Reset Password workflow node please follow the below steps.
  1. Navigate to Requests > Workflows > Request
  2. Click on  Delegation Only workflow.
  3. Select the Reset Password node and expand the General tab on the right hand side of the page and uncheck the enabled box.
User-added image
  1. Go back to the review result and perform the review again. Now the change request should not generate an error state.