ORA-06550 error when attempting to run the Data_Retention_Pkg in RSA Identity Governance & Lifecycle

4 years ago

Originally Published: 2018-05-18

Article Number

000041817

Applies To

RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.2, 7.1.x

Issue

When attempting to run the Data_Retention_Pkg in RSA Identity Governance & Lifecycle 7.0.2 and RSA Identity Governance & Lifecycle 7.1.0 using Oracle SQL Developer, the following error occurs:

Error starting at line : 1 in command -
BEGIN Data_Retention_Pkg.Prune_Run_Details(SYSDATE-90); END;
Error report -
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DATA_RETENTION_PKG.PRUNE_RUN_DETAILS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:

The same error occurs in Oracle SQL*Plus:

$ sqlplus avuser/<password>
SQL> EXECUTE Data_Retention_Pkg.Prune_Run_Details(SYSDATE-90);
BEGIN Data_Retention_Pkg.Prune_Run_Details(SYSDATE-90); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DATA_RETENTION_PKG.PRUNE_RUN_DETAILS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


SQL>

Cause

The Data_Retention_Pkg was deprecated in RSA Identity Governance & Lifecycle starting in version 7.0.2.

Resolution

For RSA Identity Governance & Lifecycle versions 7.0.2 and 7.1.0 and later, data purging is automatic and is configured in the user interface under the Admin > System > Data Management tab. Please see the online help section Managing Data Purging in the RSA Identity Governance & Lifecycle user interface for more information.

For more information on managing the size of the RSA Identity Governance & Lifecycle Oracle database, please see RSA Knowledge Base Article 000038168 -- How to manage database growth in RSA Identity Governance & Lifecycle.

Don't see what you're looking for?

Related Articles

Trending Articles