000031834 - Error message "SQLException: Unsupported feature" in aveksaServer.log when workflow executes in RSA IMG 6.9.1

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000031834
Applies ToRSA Product Set: Identity Management and Governance (IMG)
RSA Version/Condition: 6.9.1
IssueWhen 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
    at oracle.jdbc.driver.ClobAccessor.getBytes(ClobAccessor.java:347)
    at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:708)
CauseThe 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

ResolutionDo 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.