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
  2. Topics

KB486714: "The object shown in the following hierarchy no longer exists in schema: Table(). -TimeNodeThe object definition is incomplete or inconsistent" error occurs when executing reports or updating the schema in MicroStrategy Developer 2021.


Yating (Tiffanie) Zhai

Senior Cloud Support Engineer III • MicroStrategy


This article describes a metadata inconsistency issue that occurs when executing reports or updating the schema.

Symptom


When executing some reports or updating schema from Strategy Developer 2021, below error occurs:


Error(s) occurred while loading schema: [DFCSCHEMA] Population Exception:The object shown in the following hierarchy no longer exists in schema: -Table0).-TimeNodeThe object definition is incomplete or inconsistentDSSSQLEngine: 
Schema loading error:
Message from GetErrorinfo : You do not have access privileges to project "Project Name"..
Error(s) occurred while loading schema: 0.

Cause


This error indicates there is a metadata inconsistency. One possible cause of this issue is that the logical table created for FFSQL report (which is a managed table) is used as the source table of many attributes.

ka0PW0000001LnBYAU_0EMPW0000050PQ9.jpeg

Action


Run Scan MD to fix the issue.
In order to track down the cause of the inconsistency, users 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 2021.
 


Comment

0 comments

Details

Knowledge Article

Published:

April 3, 2024

Last Updated:

April 3, 2024