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 isAn 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=?
This is an Oracle bug that was introduced in 220.127.116.11 (RSA Identity Governance & Lifecycle uses 18.104.22.168 of Oracle in 6.9.x) and is fixed in 22.214.171.124 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 126.96.36.199 Oracle database.