|Applies To||RSA Product Set: RSA Identity Governance and Lifecycle|
RSA Version/Condition: 7.0.x
|Issue||After 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:
The error is NOT seen in the avekasServer.log.
The processing workflow will say:
The issue can affect all 7.0.x versions, as that is when RSA Identity Governance and Lifecycle switched to using a 22.214.171.124 database.
|Cause||This is an Oracle bug that was introduced in 126.96.36.199 (RSA Identity Governance and Lifecycle uses 188.8.131.52 of Oracle in 6.9.x) and is fixed in 184.108.40.206 of Oracle (which is not a supported platform for RSA Identity Governance and Lifecycle.)|
|Resolution||Appliance 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).