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

Document created by RSA Customer Support Employee on May 26, 2018Last modified by RSA Customer Support Employee on Feb 26, 2020
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000036367
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.2,  7.1.x
IssueWhen 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>


 
CauseThe Data_Retention_Pkg was deprecated in RSA Identity Governance & Lifecycle starting in version 7.0.2.   
ResolutionFor 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.

Attachments

    Outcomes