000035557 - Multiple entitlements in RSA Identity Governance and Lifecycle cause supervisor approval to fail  with ORA-22275: invalid LOB locator specified

Document created by RSA Customer Support Employee on Sep 23, 2017
Version 1Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000035557
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.x
 
IssueAfter requesting multiple entitlements, the request fails during supervisor approval. The error message in the processing workflow is 'An SQL Exception has occurred. Please see the server logs for details.'
The error happens when updating a CLOB field VAR_CVALUE in WP_USER_DATA if the data is more than 2K large. 
Conceivably, this error may arise in other parts of the product.
The error is seen in the WorkPoint.log:

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
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 avekasServer.log.
The processing workflow will say:
 

'An SQL Exception has occurred. Please see the server logs for details.'

The issue can affect all 7.0.x versions, as that is when RSA Identity Governance and Lifecycle switched to using a 12.2.0.1 database.
CauseThis is an Oracle bug that was introduced in 11.2.0.4 (RSA Identity Governance and Lifecycle uses 11.2.0.3 of Oracle in 6.9.x) and is fixed in 12.2.0.2 of Oracle (which is not a supported platform for RSA Identity Governance and Lifecycle.)
 
ResolutionAppliance users should Install and run the latest available Appliance Updater which contains cumulative Oracle patches.
Remote database owners should install the latest PSU (Oracle Patch Set Update).

Attachments

    Outcomes