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
How to write LDAP query filter in RSA ACE/Server for an LDAP Synchronization job Number of Views How to run a SQL query report on several UserIDs with a wildcard in RSA Authentication Manager 8.x 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 Collector reports ORA-12805: parallel query server died unexpectedly, in RSA Identity Governance & Lifecycle Number of Views Data runs show error: Exception while executing filter query RSA Identity Governance & Lifecycle 6.8 and above Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Release Notes for RSA Authentication Manager 8.8 RSA Authentication Manager 8.9 Release Notes (January 2026) Supported On-Demand Authentication (ODA) SMS providers for use with RSA Authentication Manager 8.x Deploying RSA Authenticator 6.2.2 for Windows Using DISM
Don't see what you're looking for?
