|Applies To||RSA Product Set: Identity Governance & Lifecycle|
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.|
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=?
Please refer to RSA Knowledge Base Article ID 000030327 - Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the log files for your specific deployment.
|Cause||This is an Oracle bug that was introduced in 18.104.22.168 (RSA Identity Governance & Lifecycle uses 22.214.171.124 of Oracle in 6.9.x) and is fixed in 126.96.36.199 of Oracle (which is not a supported platform for RSA Identity Governance & Lifecycle.)|
The issue can affect all 7.x versions, as that is when RSA Identity Governance & Lifecycle switched to using a 188.8.131.52 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).