This is a known issue in the following version:

• SecurID Governance & Lifecycle 7.5.2 P08

After patching SecurID Governance & Lifecycle to 7.5.2 P08, the GUI shows the following error:

The aveksaserer.log shows the following error:

10/03/2023 13:40:00.785 ERROR (ServerService Thread Pool -- 128) [com.aveksa.migration.jdbctool.CheckDatabase] ORA-06575: Package or function ROLE_MANAGEMENT_PKG is in an invalid state
ORA-06512: at "AVUSER.REPORT_VIEWS_PKG", line 6684
ORA-06512: at line 1

10/03/2023 13:40:00.785 ERROR (ServerService Thread Pool -- 128) [com.aveksa.migration.jdbctool.CheckDatabase] 

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

Patching has failed

ORA-06575: Package or function ROLE_MANAGEMENT_PKG is in an invalid state
ORA-06512: at "AVUSER.REPORT_VIEWS_PKG", line 6684
ORA-06512: at line 1

Procedures in the Role Management Package use names longer than the 30 character (a limit in Oracle 12c).

This issue may occur for the following reasons:

• The Oracle database has not been upgraded to 19c.
• The Oracle database was upgraded to 19c but the init.ora setting "Compatible" was set to a lower value than 19c

• If the Database is Oracle 12c upgrade the Oracle database to Oracle 19c.
• If the Database is Oracle 19c remove or reset the compatibility flag for 12c