Considerations when duplicating Object Structures

Symptom

Duplicating an Object Structure could cause any inconsistency in the MAXINTOBJCOLS table if you delete source objects before saving the Object Structure, as in the following example:

1) From Object Structures application, open DMDOCTYPES and select "Duplicate Object Structure" from the Select Action menu.

2) Specify TESTDOCTYPES for "Object Structure" field.

(But do not click on the 'Save' button at this stage)

3) In the Source Objects section, click on the Trash icon for the DOCINFO source object.

4) Verify that the crossed-out line appears both for DOCINFO and for LONGDESCRIPTION.

5) Click on the 'Save' button.

6) Run the following SQL and verify the entry for DOCINFO object remains in the table.

select * from maxintobjcols where intobjectname='TESTDOCTYPES'

INTOBJECTNAME OBJECTNAME NAME INTOBJFLDTYPE

------------- ---------- --------------------------- -------------

TESTDOCTYPES DOCINFO DESCRIPTION_LONGDESCRIPTION NONPERSISTENT

The above record on MAXINTOBJCOLS table should not exist because the source object "DOCINFO" in the object structure "TESTDOCTYPES" is already deleted. This kind of inconsistency could cause the following error which could lead to failure on deploying migration packages.

"BMXAA7733E - The following error occurred when the Object Structure cache was loaded:null".