Review items are reverted back since the change request gets cancelled with script error in RSA Identity Governance & Lifecycle

[#1]

Article Number

000036283

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'

Image description

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.

Image description

4. Go back to the review result and perform the review again. Now the change request should not generate an error state.