Form approval node shows exception caught during script evaluation error in RSA Via Lifecycle and Governance
2 years ago
Originally Published: 2016-08-12
Article Number
000043851
Applies To
RSA Product Set: Identity Management and Governance
RSA Product/Service Type: Appliance
RSA Version/Condition: 7.0
Platform: Linux
 
Issue
When a change request is triggered via forms the Form approval node will throw an error in the workflow.
Error - Exception caught during script evaluation. Script 'Node - Available Asynchronous',
ScriptID=3:WPDS, JobID=63277:WPDS, JobRef='4527', ProcessRef='WF_RR_6', JobRowVersion =7, 
NodeName='Form Approvals', JobNodeID=1013125:WPDS, WorkItem=825143:WPDS:1, 
FIFO=10083044. Exception was: com.workpoint.common.exception.ScriptEngineException: 
InvocationTargetException caught when executing Java class. Command = '#Wed Oct 14 09:07:49 
EDT 2009 Parameter6=SymbolTable Parameter5=ThisWorkItemData 
JavaClass=com.aveksa.server.workflow.scripts.nodes.WorkflowNodeHandler 
Parameter4=ThisActivityInstData Method=nodeAvailableAsynchronous 
Parameter3=ThisJobNodeData Parameter2=ThisJobData Parameter1=ClientContext 
ParameterType6=OpTypeNotSpecified UseInstanceObjectName= 
ParameterType5=OpTypeNotSpecified ParameterType4=OpTypeNotSpecified 
ParameterType3=OpTypeNotSpecified ParameterType2=OpTypeNotSpecified Version=1 
ParameterType1=OpTypeNotSpecified UseInstance=false MethodIsStatic=true '; nested exception 
is: org.hibernate.exception.SQLGrammarException: could not execute query Error occurred in 
Statement #1 in Script ID 3:WPDS, Script Name = 'Node - Available Asynchronous', Script type = 
'Action'. Job ID = 63277:WPDS, Process Ref = 'WF_RR_6', Node Name = 'Form Approvals', 
WorkItem = 825143:WPDS:1


If we remove the form approval node in the workflow the request will go to the fulfillment process without errors.
  1. Create a custom form
User-added image
 
  1. Enter the required fields for the form, as shown here:
User-added image
  1. Generate a request for the changes.
  2. The request is submitted and goes to an error state in few minutes, shown in the screen shots here:
User-added image
User-added image 
The workflow gets stuck in form approval node and will show the above error.
User-added image
Resolution
This issue is fixed in V7.0 P01, P02 and P03.