KB39561: "The object shown in the following hierarchy no longer exists in schema: -Link-Schema/Report Loading is interrupted by invalid data" occurs when updating schema only in 3-tier mode in MicroStrategy Developer 9.x - 10.x

Salesforce Solutions Architect • Strategy

This technical note outlines an issue that occurs when updating a project schema in 3-tier.

SYMPTOM:
When updating schema ONLY in 3-tier mode from Strategy Developer 9.x - 10.x, the following error occurs:


Error(s) occurred while loading schema: DSSSQLEngine: Schema loading error: Population Exception: The object shown in the following hierarchy no longer exists in schema: -Link-Schema/Report Loading is interrupted by invalid data.
Message from GetErrorInfo : Error(s) occurred while loading schema: DSSSQLEngine: Schema loading error: Population Exception: The object shown in the following hierarchy no longer exists in schema: -Link-Schema/Report Loading is interrupted by invalid data...

Error(s) occurred while loading schema: 1.

The schema can be updated successfully in direct or 2-tier mode.

CAUSE:
One possible cause is that one or more attribute(s) have blank expressions mapped to certain logical tables as shown:

This is a known metadata inconsistency with Strategy. In order to track down the cause of this inconsistency, customers encountering this issue should make note of Schema/Application-related changes, Object Migrations or error messages prior to experiencing the problem. Change Journaling, if enabled, can help in preserving this information.

ACTION:
Contact Strategy Technical Support for steps on resolving this inconsistency.

Comment

0 comments

Details

Knowledge Article

Published:

June 12, 2017

Last Updated:

June 12, 2017