After a database restore using avdbimport RSA Identity Governance & Lifecycle fails to start.
 

The following is logged to the console on startup.

Initialization Status 
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 logged to the aveksaserver.log file.
 

06/16/2021 14:20:28.926 FATAL (ServerService Thread Pool -- 79) [com.aveksa.server.runtime.AveksaSystem] 

****************************************

Initialization has failed!

Found invalid object(s) in the database. Please check the log for error(s).


****************************************

This issue may also occur when manually recompiling an existing Oracle package (.pkg) file using one of the following RSA supported methods.

• Running /home/oracle/database/migration/recompileAll.sql SQL script
• Running /home/oracle/database/Recompile_All.sh shell script.
• Selecting the "Recompile Invalid Objects" button from the Admin/Diagnostics tab.
• running migrate.sh (which includes a call to /home/oracle/database/migration/recompileAll.sql)
• As noted, running avdbimport (which includes an embedded call to /home/oracle/database/migration/recompileAll.sql)

The following detection script can be used to identify this issue.
 

select * from user_objects where status='INVALID';

You have this issue if the detection script identifies a problem with RULE_PREPROCESS_PKG

This issue is a known issue in the following versions

• RSA Identity Governance & Lifecycle 7.2.0
• RSA Identity Governance & Lifecycle 7.2.1 

This issue occurs when attempting to recompile some of the existing Oracle package (.pkg) files that are part of RSA Identity Governance & Lifecycle.   The problem occurs when using the RSA script recompileAll.sql (directly or indirectly) to recompile the raw source for a package when the source happens to include a wrapped line that causes the end of line CR to end on an empty line. 

The versions above are known to include a version of RULE_PREPROCESS_PKG that does not compile.

This issue is resolved in the following versions.

• RSA Identity Governance & Lifecycle 7.2.0 P06
• RSA Identity Governance & Lifecycle 7.2.1 P02
• RSA Identity Governance & Lifecycle 7.5.0 GA

These versions corrects the specific Oracle package (.pkg) file RULE_PREPROCESS_PKG that was affected.

Use the following  command from SQLPlus to compile the problem packages. 

exec AV_Compile_Invalid_Objects

Note that this work around does not correct the issue, it just allows the problem package(s) to be compiled in order to allow this failure to be bypassed.   Avoid using the problem commands until you can patch.  Using any of the problem commands will cause the issue to occur again. 
 

WARNING.  The error message "Found invalid object(s) in the database." may occur any time any package fails to compile.   This error message does not indicate the reason for the failure and the compilation may fail for other reasons other than that specified above.

This solution should is only recommended for the specific failure with the specific packages noted.   This solution may not work for other packages that fail to compile for other reasons.