|Applies To||RSA Product Set: RSA Identity Governance and Lifecycle|
RSA Version/Condition: 7.0.2
|Issue||After exporting and importing database schema using the RSA Identity Governance and Lifecycle 7.0.2 install, the application will start the following message:|
Initialization operations completed with errors. Please resolve the problem(s) before the application server can accept requests.
Found Invalid object(s) in the database. Please check the log for error(s).
The following is in the AveksaSever.log:
ERROR (MSC service thread 1-3) [com.aveksa.migration.jdbctool.CheckDatabase]
The import process shows the following error:
ORA-39082: Object type PACKAGE BODY:"AVUSER"."ENTITLEMENT_REVIEW_UTILS" created with compilation warnings
Error(s) occured while compiling invalid object ENTITLEMENT_REVIEW_UTILS:
|Cause||This is due to an Oracle bug. The fix for Oracle bug 18881811 is listed to be available only as part of Oracle's 18.104.22.168 Bundle Patch 7 (April 2015), or any other patch set that superseded it.|
|Resolution||Apply the Oracle patch or get the appliance updater 2017 Q1.|
|Workaround||If it not possible to apply the Oracle update or Appliance updater immediately, the following steps can also be used to workaround this issue:|
whenever sqlerror exit 1 rollback
sqlplus avuser/<password> @Entitlement_Review_Utils_workaround.sql