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

KB441237: Object Exist Status in Enterprise Manager is returning wrong report results.


Community Admin

• Strategy


This knowledge base article describes the issue with object exists status which indicates if a schema or an application object exists.

SYMPTOM
Attribute Object Exist Status is returning not actual data. What is more, updating object deletions is not resolving the issue. 
CAUSE
The issue is caused by inconsistencies in statistics tables. 
ACTION
Please change the column EM_TRACKED to 2 in EM_ITEM table per https://community.Strategy.com/s/article/KB299123-How-to-control-the-data-load-of-specific-tables-in The steps will be as follows:
1) Update the EM_ITEM table as follows so that the data load will re-load attributes and reports

update EM_ITEM set EM_TRACKED=2 where EM_ITEM_ID in (20,120, 8, 108); 

2) Make sure that the data load has UPDATEOBJECTDELETIONS in its DO ACTION
3) Run the data load and check if the issue is resolved. 
4) Once resolved, please run the following SQL to reverse the change made in Step 1:
update EM_ITEM set EM_TRACKED=1 where EM_ITEM_ID in (20,120, 8, 108);
 


Comment

0 comments

Details

Knowledge Article

Published:

June 29, 2018

Last Updated:

November 17, 2018