Multiple entitlements in RSA Identity Governance and Lifecycle cause supervisor approval to fail with ORA-22275: invalid LOB locator specified
Originally Published: 2017-09-18
Last Modified: 2026-05-13
Article Number
Applies To
RSA Version/Condition: 7.x
Issue
After requesting multiple entitlements in RSA Identity Governance & Lifecycle, the request fails during supervisor approval. The error occurs when updating CLOB field VAR_CVALUE in the WP_USER_DATA table if the data is greater than 2000 characters in length. Conceivably, this error may also arise in other parts of the product.
- The error message in the processing workflow is An SQL Exception has occurred. Please see the server logs for details.
- The error message in the WorkPoint.log is:
2017-08-23 11:55:10,649 [Worker_alertq#Alert Queue#WPDS_1] ERROR com.workpoint.services.impl.GenericServiceImpl - ORA-22275: invalid LOB locator specified SQL = Execute Batch: UPDATE WP_USER_DATA SET VAR_CVALUE=?, VAR_BVALUE=?, BVALUE_LENGTH=?, PROC_ID=?, PROC_DB=?, PROCI_ID=?, PROCI_DB=?, ROW_VERSION=?, LU_ID=?, LU_DATE=? WHERE DATA_ID=? AND DATA_DB=? AND DATA_TYPE=? AND VAR_NAME=?
- The error is NOT seen in the aveksaServer.log.
Cause
The issue can affect all 7.x versions, as that is when RSA Identity Governance & Lifecycle switched to using a 12.2.0.1 Oracle database.
Resolution
RSA-supplied database users such as Appliance users should install and run the latest available RSA Identity Governance & Lifecycle Appliance Updater which contains cumulative Oracle patches.
Customer-supplied database users should install the latest PSU (Oracle Patch Set Update).
Related Articles
How do supervisors view a report result that is specific to their subordinates in RSA Via Lifecycle and Governance 70Number of Views RSA Governance & Lifecycle Recipes: Chart - Review Results - Review Progress Trending 24Number of Views In RSA Identity Governance and Lifecycle, the Vaild Reply Answers are not displayed in the Approval Request email. 142Number of Views Looping fulfillment workflows cause multiple issues in SecurID Governance & Lifecycle 336Number of Views RSA Governance & Lifecycle Recipes: Completed Review Items 14Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process
Don't see what you're looking for?