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

Document created by RSA Customer Support Employee on Apr 30, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036283
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.0, 7.0.1
 
IssueThe 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)
CauseThis is a known issue and has been reported to our engineering team. 
ResolutionUpgrading to V7.0.1 or V7.0.2 will fix this issue.
WorkaroundAs 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.

Attachments

    Outcomes