Get Database Error ORA-00001 in DBService/MBDBService when Building Map (Doc ID 821763.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Utilities Network Management System - Version 1.7.1.1 and later
Oracle Network Management for Utilities - DMS - Version 1.7.1.1 and later
Information in this document applies to any platform.

Symptoms

Attempting to build a substation map, a SQL error

ORA-00001: unique constraint (OMS.NETWORK_COMPONENTS_PK) violated

was found in the *DBService log file, and the map will not build.


The following errors may exist at the time of the error reported above:
Patch log file:
Message:  MBS-01029      location:  Entity::errorCheckPartition      severity:  W
    Object 100.1234 has duplicates in the database.
    Context:  
       Time:  07/01 01:34

Message:  MBS-00148      location:  MBEntitySet::apply      severity:  E
    Error inserting branch 100.1234.
    Context:  
       Time:  07/01 01:34


MBService log file:
07/01 01:34:39: MBService 0x7f75b66c0700,ctp=0x7f75790c7738,"MBService::build" **ERROR** Message:  MBS-00148      location:  MBEntitySet::apply      severity:  E
    Error inserting branch 100.1234.

07/01 01:34:39: MBService 0x7f75b66c0700,ctp=0x7f75790c7738,"MBService::build" **ERROR** Message:  MBS-00106      location:  MBIL::sstore      severity:  E
    Database SQL error.  See DBService log for details.

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