DIVArchive Object Exists Error For Archiving Although Object Not Searchable In GUI (Doc ID 2128169.1)

Last updated on APRIL 18, 2016

Applies to:

Oracle DIVArchive - Version 7.2 and later
Information in this document applies to any platform.

Symptoms

On : 7.2 version, in the DIVArchive manager- When attempting to archive an object, the following error occurs;

ERROR
-----------------------
This object already exists in DIVA.

 

Although, if this object is searched for in the control GUI, it is not found. After double checking the object name and category, check the database to see if the object exists in the DP_Archived_Objects table. If it does exist in this table, but is not searchable in the GUI, also check the following;

select AO_OBJECT_NAME from DP_ARCHIVED_OBJECTS WHERE AO_NUMBER_INSTN_ON_DISK=0;

 

If the object in question is returned in results of this query, it implies that this object was being archived and there was a global manager or database failure. This object will need to be deleted from the database and rearchived.

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