Message
There is more than one parent in the DB for a child Assembly.
Severity
Fatal.
Detailed Description
An Assembly has been located that has more than one parent. An Assembly should always have only one parent.
Possible Cause
Programmatic error or failure during database commit.
Possible Impacts
There is the potential for an infinite loop.
What You Should Do
An SQL script, Planning\FixChildPartsWithMoreThanOneParent.sql, has been written as the Repair Tool for this item. The repair may be accomplished through the use of the Database Integrity process.
The script performs the following:
-
Removes the existing AssemblyHierarchy relations of the corrupted part.
-
Adds the corrupted part as a child of UnprocessedParts of the root block. If the root block does not have the UnProcessedParts folder, then the script adds it as the child of the root block itself.