|Applies To||RSA Product Set: Identity Management and Governance (IMG)|
RSA Version/Condition: 6.9.1
|Issue||When a workflow with a custom SQL statement executes the following exception is generated in the aveksaServer.log and the workflow does not complete.|
10/01/2015 10:40:22.486 INFO (Worker_actionq#ActionQ1#WPDS_151) [STDOUT] 2015-10-01 10:40:22,485 [Worker_actionq#ActionQ1#WPDS_151] ERROR com.workpoint.server.script.ScriptEngine - A script error has occurred. Error occurred in Statement #1 in Script ID 17:WPDS, Script Name = 'SQL Query', Script type = 'Action'. Job ID = 21478:WPDS, Process Ref = '199', Node Name = 'SQL Select', WorkItem = 167840:WPDS:1
java.sql.SQLException: Unsupported feature
|Cause||The SQL statement contains a request for a data that is a CLOB (Character Large OBject) data type. Manipulating CLOB data objects is not allowed within the WorkFlow editor. |
For example, the SQL select statement below includes a request for the column OPTIONAL_COMMENTS which is a CLOB data object.
select pvcr.NOTES,vawwh.OPTIONAL_COMMENTS as Spvr_comment from avuser.pv_change_request pvcr
left join avuser.PV_CHANGE_REQUEST_WORK_ITEM pvcrwi on pvcrwi.CHANGE_REQUEST_ID=pvcr.id
left join avuser.V_AV_WFWORKITEM_HISTORY vawwh on vawwh.ACTI_ID=pvcrwi.ACTIVITY_INSTANCE_ID
|Resolution||Do not use queries that attempt to manipulate columns defined as CLOB data from within the workflow editor. Data in these types of objects is generally in a format that cannot be manipulated by the workflow editor.|
Restrict queries in Workflow objects to tables defined in the public schema document. For the most part these tables include only data in the standard data types that can be used by within the Workflow.