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.

Related Articles

Trending Articles

Don't see what you're looking for?