RSA Identity Governance and Lifecycle SQL workflow node fails when there is a % sign iis the query
Originally Published: 2017-04-13
Article Number
Applies To
RSA Version/Condition: 6.9.1 P08 and above
Issue
The following error is captured in the WorkPoint.log:
2017-03-12 14:33:22,061 [Worker_actionq#ActionQ1#WPDS_9] 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 = 3061:WPDS, Process Ref = 'WF_FF_39', Node Name = 'Occurance Check1', WorkItem = 12665:WPDS:1
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5377)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8406)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8336)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9097)
Resolution
If you need to manipulate the data expanded from a variable, do it separately from the variable expansion.
For example, this syntax is no longer allowed:
'%${var}%'
Instead use the following syntax:
'%' || '${var}' || '%'
This allows the variable expansion to occur, after which the concatenation will contain the variable expansion and be safe to manipulate.
Related Articles
Collector reports ORA-12805: parallel query server died unexpectedly, in RSA Identity Governance & Lifecycle Number of Views 'ORA-00942: Table or View does not exist' error when referencing a custom table/view in a report query in RSA Identity Gov… Number of Views Data runs show error: Exception while executing filter query RSA Identity Governance & Lifecycle 6.8 and above Number of Views ORA-00942: table or view does not exist when defining a custom report query in RSA Identity Governance & Lifecycle Number of Views How to write LDAP query filter in RSA ACE/Server for an LDAP Synchronization job Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.9 Release Notes (January 2026) Artifacts to gather in RSA Identity Governance & Lifecycle RSA Governance & Lifecycle 8.0.0 Administrators Guide RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
