"ORA-06575: Package or function ROLE_MANAGEMENT_PKG is in an invalid state" after patching to 7.5.2 P08 in RSA Governance & Lifecycle
Last Modified: 2024-01-16
Article Number
Applies To
This is a known issue in the following version:
- SecurID Governance & Lifecycle 7.5.2 P08
Issue
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
Cause
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
Resolution
- 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
Apply the patch again.
Related Articles
Salesforce Collector is throwing 'Invalid Credentials' error after patching to RSA Governance & Lifecycle 8.0.0 P06 8Number of Views After patching to RSA Identity Governance & Lifecycle 7.0.2 P03+, emails are not generated and sent due to the error 'Ille… 70Number of Views Getting an "Unable_To_Migrate_Connectors_Or_Templates" error after patching to 8.0.0 P05 in RSA Governance & Lifecycle 18Number of Views Cloud Access Service - RADIUS 10Number of Views After patching a Request Could Not be Handled error appears when pressing Edit Log Settings for Connectors in RSA Governan… 3Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?