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

KB33879: "There is error in report definition. The element shown in the following hierarchy has invalid definition or no longer exists" error message appears when running a report in MicroStrategy Developer 9.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


"There is error in report definition. The element shown in the following hierarchy has invalid definition or no longer exists" error message appears when running a report in MicroStrategy Developer 9.x

SYMPTOM:
When the user executes a report, the following error occurs:
 

ka02R000000kcLSQAY_0EM440000002E1o.jpeg

Sample Code/Error
Error(s) occurred while loading report: DSSSQLEngine: Schema loading error: There is error in report definition. The element shown in the following hierarchy has invalid definition or no longer exists:   Report  (test). -There is error in report definition. The element shown in the following hierarchy has invalid definition or no longer exists:   Report  (). -Filter (Local Filter). -Filter Unit-Filter Unit-Schema/Report Loading is interrupted by invalid data..
 
CAUSE:
This issue is caused by a filter with an empty advanced qualification definition. The user should see a filter with a similar definition below:
Note: The root cause of this type of inconsistency is still under investigation. Creating an empty filter definition is not possible through regular usage.
 

ka02R000000kcLSQAY_0EM440000002E1Z.jpeg

 
WORKAROUND:
Remove this problematic filter and redefine it again.
 
 


Comment

0 comments

Details

Knowledge Article

Published:

May 9, 2017

Last Updated:

May 9, 2017