Unable To Delete Alert In Audit Vault (Doc ID 828231.1)

Last updated on JUNE 04, 2013

Applies to:

Oracle Audit Vault - Version 10.2.3.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.
Checked for relevance on 04-Jun-2013

Symptoms

Trying to delete the AV alerts from the GUI interface fails. In auditor mode, select alert and press OK
does not delete the alert - it remains listed in alerts section.
There is no error issued in the window.

The sql trace files taken with 10046 level 4 event or dbms_monitor shows:

PARSING IN CURSOR #35 len=191 dep=0 uid=63 oct=47 lid=63 tim=11077922665904 hv=
2690334885 ad='fd2a0430'
declare
begin
avsys.dbms_audit_vault_alert.
drop_alert( rtrim(ltrim(:1)) );
end;
END OF STMT
PARSE #35:c=0,e=678,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=11077922665901


and the error is ORA-46505

EXEC #35:c=60000,e=105182,p=3,cr=450,cu=0,mis=1,r=0,dep=0,og=1,tim=
11077922771160
ERROR #35:err=46505 tim=3796874437




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms