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
Workflow Variables under the Resource section of Workflow Nodes cannot resolve Roles and Groups after being imported in RS… Number of Views How to write LDAP query filter in RSA ACE/Server for an LDAP Synchronization job Number of Views 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 RSA Identity Governance & Lifecycle does not save values correctly in the WorkFlow Activity Node Properties Settings if th… Number of Views
Trending Articles
RSA Authentication Manager 8.9 Release Notes (January 2026) RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA-2026-07: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
