DSF error SC3 running Datadictionary Database RESTORE

Products

• Datacom

Issue/Introduction

RST BAS ( Restore a database structure)  in Datacom Datadictionary online (DDOL)  DBMAINT mode trying to restore the most recent history version ( H000) of a database structure to a new test version fails with  

1-DDOL001119C - ERPP - DB/DSF ERROR RETURNED
-------------------------------------------------------------------------------
                          DSF Error Panel                                  E01D

DSF called by program DDRCFPR at location 0F76            Miscellaneous Info
Command: STRRESTR   Return Code: SC3  Error Module:       -------------------

 Msg:       TYPE ARA EXISTS IN OTHER (SUB)STRUCTURE

Cause

Multiple HIST versions of the AREA/TABLE entities are attached to the history version of the database structure.

Resolution

Delete the oldest HIST versions of the TABLE and AREA entities and keep the most recent HIST version.

Additional Information

DD problem Title: SC3 ON RESTORE WITH MULTIPLE HISTORY VERSIONS 

 Condition: A substructure has multiple versions attached to the parent
            occurrence.  For example, a database in history version 001
            might have two versions of an area attached to it that are in
            history version 001 and 002.  The restore function would create
            the area in test from version 001 and look for the next database
            to area relationship.  It would then try to process version 002
            of the area and detect the test version of the area just created.
            As a result, the SC3 is issued.

For documentation , see SC3.

A DDUTILTY PATH report can be run to find the history versions . Open a support case if help is needed .

-DEF PATH,P1
-DEF TRACE,DATABASE.AREA,$INTERNAL
-DEF TRACE,AREA.TABLE,$INTERNAL
-END
-RPT START,DATABASE,database entity name(H000),P1
-RPT INDENT,DATABASE
-RPT INDENT,AREA
-RPT INDENT,TABLE

For documentation, see DDUTILTY - Producing Reports and Source Language Statements