KB40006: "The object shown in the following hierarchy no longer exists in schema: -Relation-Table" error appears when updating the schema in 3-tier in MicroStrategy 9.4.x-10.x

Error(s) occurred while loading schema: DSSSQLEngine: Schema loading error: 
Population Exception: The object shown in the following hierarchy no longer exists in 
schema: -Relation-TableThe object definition is incomplete or inconsistent.
Error(s) occurred while loading schema: 7

 
This issue does not happen in 2-tier mode.
 
CAUSE:
One possible cause is that there is a relationship based on a table which is not part of the Schema Collection.
If running ScanMD against the metadata, there will be errors in the `Schema Collections Verification` test. The error entries will be of type:
 

Table is not found in Schema`s Tables collection

 

ACTION:
Run ScanMD against the project. For more information about ScanMD, refer to the following Strategy Knowledge Base document:
KB35809: Using ScanMD to fix known logical metadata inconsistencies in the MicroStrategy Product Suite 9.4.x - 10.2 Hotfix1
In order to track down the cause of the inconsistency, customers encountering this issue should make note of Schema-related changes, Object Migrations, or error messages prior to experiencing the problem. Change Journaling, if it has been enabled, can help in preserving this information in Strategy 9.4.x-10.x.
RELATED KB ARTICLES:

• KB36880: "The object shown in the following hierarchy no longer exists in schema: -Relation-TableThe object definition is incomplete or inconsistent" error message is thrown when updating the schema in three tier in MicroStrategy Developer 9.4.x and 10.x
• KB42571: "The object shown in the following hierarchy no longer exists in schema: -Relation-Relationship" error occurs when updating schema in MicroStrategy Developer 9.4.x - 10.x.
• KB42342: "The object shown in the following hierarchy no longer exists in schema: -Relation-Table The object definition is incomplete or inconsistent" error message appears when updating schema in 3-tier in MicroStrategy Developer 9.x - 10.x.
• KB39551: "The object shown in the following hierarchy no longer exists in schema: -Relation-TableThe object definition is incomplete or inconsistent" error message appears when updating Schema in 3-tier in MicroStrategy Developer 9.4.1.

KB40006