Salesforce

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

« Go Back
Header
ORA-06550 error when attempting to run the Data_Retention_Pkg in RSA Identity Governance & Lifecycle
ORA-06550-error-when-attempting-to-run-the-Data-Retention-Pkg-in-RSA-Identity-Governance-Lifecycle
ORA-06550 error when attempting to run the Data_Retention_Pkg in RSA Identity Governance & Lifecycle
Work in Progress
2,192.67
Article Content
 
RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.2,  7.1.x
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>

 
The Data_Retention_Pkg was deprecated in RSA Identity Governance & Lifecycle starting in version 7.0.2.   
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.
000036367
Article Settings
External
Case
Ian Staines
5/18/2018 6:32 PM
Ian Staines
Article Assignment
 
 
 
Article Properties
Published
Knowledge
000041817
Ian Staines
Venkata SamanthKumarAtchuta
English

Powered by