|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle |
RSA Version/Condition: 6.9.1, 7.0.x, 7.1.x, 7.2.0
Platform (DB): Oracle 18.104.22.168.0
|Issue||All RSA Identity Governance & Lifecycle Reviews fail to generate regardless of review type.|
08/12/2015 20:58:35.141 ERROR (Exec Task Consumer#0) [com.aveksa.server.review.ReviewDefinitionVersion]
FAILED method=generateReport subTask=Get entitlements for review 322
com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-20126: The creation of reviews failed.
ORA-01792: maximum number of columns in a table or view is 1000
Stored Procedure:Generate_Review execution aborted.
ORA-06512: at "AVUSER.REVIEW_COMPONENT_CACHE", line 67
ORA-06512: at "AVUSER.REVIEW_COMPONENT_CACHE", line 3126
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1812
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 903
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 917
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1895
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1537
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1502
ORA-06512: at line 1
Caused by: java.sql.SQLException: ORA-20126: The creation of reviews failed.
Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the aveksaServer.log file for your specific deployment, if you are on a WildFly cluster or a non-WildFly platform. The aveksaServer.log may also be downloaded from the RSA Identity Governance & Lifecycle user interface (Admin > System > Server Nodes tab > under Logs.)
|Cause||This is a known issue reported in engineering tickets ACM-56376 and ACM-69792.|
The cause of this issue is due to an Oracle defect introduced in Oracle 22.214.171.124.0 by Oracle patch 19653859.
|Resolution||This issue is resolved in Oracle patch 19509982, DISABLE FIX FOR RAISING ORA-1702 BY DEFAULT. Ensure that you apply Oracle patch 19509982, or the latest cumulative Oracle patch set that includes this patch. Note that if Oracle patch 19509982 has been previously applied and Oracle is upgraded, Oracle patch 19509982 may need to be applied again even if it has already been applied. |
|Workaround||Instructions to apply the Oracle fix manually:|
1. As user oracle stop RSA Identity Governance & Lifecycle and stop Oracle.
2. Set your current directory to the directory where the patch is located and then run the opatch utility by entering the following commands:
3. Verify whether the patch has been successfully installed by running the following command:
4. Start Oracle and RSA Identity Governance & Lifecycle:
|Notes||You can verify that the correct Oracle patch is applied by running the opatch command on the system where Oracle is installed. Login as the Linux user that manages/installed Oracle (the default user is typically oracle), and run the opatch utility as shown below: |
The output of opatch in this example shows that the fix for bug 9509982 has been installed on this instance.