DBCleanup -fixAVTable Does not Fix Duplicate alternate_view Entries if Only a Single Set of Handles is Found (Doc ID 2092482.1)

Last updated on MARCH 08, 2016

Applies to:

Oracle Utilities Network Management System - Version 1.10.0.6 to 1.12.0.3 [Release 1.10 to 1.12]
Oracle Network Management for Utilities - DMS - Version 1.10.0.6 to 1.12.0.3 [Release 1.10 to 1.12]
Information in this document applies to any platform.

Symptoms

The ALTERNATE_VIEWS database table has a duplicated entry, as shown by running this query:

H_CLS H_IDX PARTITION PRIMARY_PTN L_CLS L_IDX BIRTH BIRTH_PATCH DEATH DEATH_PATCH ACTIVE
424 738354 1201 1197 4001 1201 11/04/2015 19:45:27 365698 Y
424 738354 1201 1197 4001 1201 12/08/2015 14:38:37 368577 Y


Running "DBCleanup -fixAVTable" should cause the entry with the higher birth_patch to get deactivated, but due to this bug, DBCleanup does not change the ALTERNATE_VIEWS 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