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.
This error is not thrown when updating the schema in two-tier.
CAUSE:This error is thrown when an attribute relationship is defined through a managed table. Managed tables cannot be loaded due to the fact that they are not part of the schema object's tables collection.
Whenever a Freeform SQL report is created, Strategy will automatically create a logical table which will be managed by the system. If this table is selected to define a relationship between two attribute in the attribute editor, the error described in this document will be thrown when updating the schema in three-tier.
ACTION:Users should avoid using the logical tables created by the system during the creation of Freeform SQL reports to define relationships between attributes.
Related KB article:
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.xKB36880
