|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 184.108.40.206 database.
|Cause||This is an Oracle bug that was introduced in 220.127.116.11 (RSA Identity Governance and 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 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).