000033768 - Form approval node shows exception caught during script evaluation error in RSA Via Lifecycle and Governance

Document created by RSA Customer Support Employee on Aug 12, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033768
Applies ToRSA Product Set: Identity Management and Governance
RSA Product/Service Type: Appliance
RSA Version/Condition: 7.0
Platform: Linux
 
IssueWhen 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
ResolutionThis issue is fixed in V7.0 P01, P02 and P03.
 

Attachments

    Outcomes