My Oracle Support Banner

Issue In Purging Data (Doc ID 2175882.1)

Last updated on MARCH 22, 2019

Applies to:

Oracle Adaptive Access Manager - Version 11.1.2.3.0 and later
Information in this document applies to any platform.

Symptoms

We are facing issue in Purging data.
We are following doc https://docs.oracle.com/cd/E52734_01/oaam/AAMAD/archpurg.htm#AAMAD4224 and getting below error like below:

-----------------------------------------------------------------------------------------------
BEGIN <SP_V_FPRINTS_PROC('Y')>; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object <OAAM_SCHEMA>.<SP_V_FPRINTS_PROC> is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

<OAAM_SCHEMA>.<SP_V_FP_MAP_PROC>
<OAAM_SCHEMA>.<SP_VT_TRX_DATA_PROC>
<OAAM_SCHEMA>.<SP_VT_ENT_TRX_MAP_PROC>
<OAAM_SCHEMA>.<SP_V_FPRINTS_PROC>
<OAAM_SCHEMA>.<SP_V_FP_MAP_PROC>
-----------------------------------------------------------------------------------------------
DROP INDEX <V_ACTION_LOG_SESS_IDX2>

ERROR at line 1:
ORA-01418: specified index does not exist

-----------------------------------------------------------------------------------------------

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

-----------------------------------------------------------------------------------------------

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier '<SP_V_CASE_PROC>' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

getting above error for:-
<SP_V_CASE_HIST_PROC>
<SP_V_CASE_MAP_HIST_PROC>
<SP_V_CASE_MAP_PROC>
<SP_V_ACTION_LOG_SESS_PROC>
<SP_V_ACTION_LOG_SESS_MAP_PROC>
<SP_VT_USER_PRF_PROC>
<SP_USER_NODE_PROC>
<SP_NODE_PROC>
<SP_NODE_HISTORY_PROC>
<SP_USER_DVC_PROC>
<SP_SESS_ACT_MAP_PROC>
<SP_VT_DY_ACT_EX_LOG_PROC>
<SP_ARCHIVE_PURGE_VCRYPT_ALERT>
<SP_ARCH_PURGE_V_USER_QA_HIST>
<SP_ARCHPURGE_VCRYPTUSERSHIST>
-----------------------------------------------------------------------------------------------

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.