Audit Vault Datawarehouse Refresh Fails With ORA-1480 (Doc ID 887572.1)

Last updated on MAY 11, 2012

Applies to:

Oracle Audit Vault - Version 10.2.3 and later
Information in this document applies to any platform.
Checked for relevance on 03-Oct-2011


Symptoms

Audit Vault datawarehouse refresh is failing with the following errors:

$ avctl refresh_warehouse 
ORA-12012 :  error on auto execute of job 46031
ORA-46599 : Message 46599 not found;  product=RDBMS; facility=ORA
; arguments: [OAV-46599: internal error ORA-14080 count(DWFACT_P20090130) = 
ORA-06512 : at "AVSYS.DBMS_AUDIT_VAULT", line 6
ORA-06512 : at "AVSYS.AV$DW", line 1067
ORA-14080 : partition cannot be split along the specified high bound
ORA-06512 : at "AVSYS.AV$DW", line 1215
ORA-06512 : at "AVSYS.AV$DW", line 1431
ORA-01403 : no data found
ORA-06512 : at "AVSYS.AV$DW", line 1970
ORA-06512 : at line 1
ORA-06512 : at "AVSYS.DBMS_AUDIT_VAULT", line 826

 

In the newer AV versions the error affects the collector(which may crash) since this is inserting directly into the AUDIT_EVENT_FACT table.

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