DOL001098C - ERPP - REL ERR. DUPLICATE RELATIONSHIP ADD

Products

• Datacom
• DATACOM - AD

Issue/Introduction

When attempt to COPY an entity in DDOL and an orphan is detected, the copy fails and the following message is issued:

    1-DDOL001098C - ERPP - REL ERR. DUPLICATE RELATIONSHIP ADD

Resolution

Run an Orphan report and optionally delete any found orphans as described below (extracted from Datacom/DB System and Administration Guide): 

Listing/Deleting Datadictionary Orphans

Due to unexpected processing errors, it is possible that instances may exist in the Datadictionary Support Entity-types which do not have corresponding entity-occurrences. The Datadictionary Support entity-types are ALIAS, DESCRIPTOR, RELATIONSHIP, and TEXT. For example, a row may exist in the ALIAS table, but for some reason, the entity-occurrence referenced does not exist in the specific entity-type. These support occurrences are referred to as "orphans". The following facility can be used to both report on and, optionally, delete these orphans. The Orphan Report can be run using either DDUTILTY or DDUPDATE like any other report function.

Request Format

The format of the header transaction is as follows:

??? -RPT ORPHANS,entity ???????????????????????????????????????????????????????? ?? ,DELETE ??

,entity

(Required) Specifies the Support entity-type to be Processed. See Report Content (see page 1056) for descriptions of the various valid types.

Valid Entries:

ALIAS, DESCRIPTOR, RELATIONSHIP, or TEXT

Default Value:

(No default)

,DELETE

(Optional) Specifies that in addition to reporting the orphans located, the orphans are also to be deleted from Data dictionary.