000030880 - VIA L&G Can you use GetClobVal()  in a SQL Node?

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 Number000030880
Applies ToRSA Product Set: Identity Management and Governance
RSA Product/Service Type: Appliance, Soft Appliance
RSA Version/Condition: 6.9.1 and earlier
Platform: JBoss, Websphere, WebLogic
Product Description: Access Request Manager
IssueUpon execution of a workflow an error is thrown when GetClobVal() exists in a SQL Node.

Exception caught during script evaluation


java.SQL.Exception "Unsupported feature Error occurred in the statement"

ResolutionWe do not support GetClobVal().
If there is that much data involved, a redesign should be considered to involve a Stored Procedure to perform queries with large data size, as this goes beyond what a workflow was designed to do.