EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

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.

Stefan Zepeda

Salesforce Solutions Architect • Strategy

This technical note outlines an issue that occurs when updating a project schema in MicroStrategy Developer 9.4.x-10.x. A solution is offered.

SYMPTOM:
When updating Schema in 3-tier in Strategy Developer, the following error appears:

ka04W000001IqmRQAS_0EM440000002Cui.png

 


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-Relationship The object definition is incomplete or inconsistent.
Error(s) occurred while loading schema: 54

Schema cannot be updated in 2-tier mode either, as the following error appears:
 

ka04W000001IqmRQAS_0EM440000002Cv2.png


Specified cast is not valid

 
CAUSE:
One possible cause is that there is no table to define the relationship between two attributes, as shown in the screenshot below:

ka04W000001IqmRQAS_0EM440000002Cuj.png

 
ACTION:
Define a relationship table if missing. Contact Strategy Technical Support if you need help to identify the faulty attribute(s).
RELATED KB ARTICLES:

  • 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.
  • 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.
  • 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
  • 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

 
KB42571

Comment

0 comments

Details

Knowledge Article

Published:

June 19, 2017

Last Updated:

June 1, 2018