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

KB439858: Missing fact of IS_REP_FACT and IS_DOC_FACT in Enterprise Manager when EM_TRACKED=2


Community Admin

• Strategy


This issue has been classified as a defect by MicroStrategy. The impact is limited to MicroStrategy Enterprise Manager. A solution/code fix for this issue is not available in current releases but is being reviewed for a future MicroStrategy release.”  

SYMPTOM
In Strategy Enterprise Manager 10.4.4, after making the following update, EM_TRACKED=2,  for all the EM_ITEM_ID's in the table EM_ITEM, it is noticed that the latest fact data is not populated in the tables IS_REP_FACT, and IS_DOC_FACT.
 
-The table EM_IS_LAST_UPD_2 involved in the fact migration procedure is empty.  
-Creating a new dataload or re-executing the dataload with a custom time window does not fix the issue.
-It is noticed that the procedures SP_IS_REP_FACT and SP_IS_DOC_FACT have been executed without any errors as shown below: 


<log4j:event logger="MAEntMgr" timestamp="1505104188884" level="INFO" thread="pool-1-thread-3">
<log4j:message type ="DEFAULT"><![CDATA[Executing SP_IS_REP_FACT]]></log4j:message>
</log4j:event>

   
CAUSE
This is a known issue with Strategy 10.4.3 and above; 10.7 and above.
Currently, this issue is being reviewed by Strategy for a potential code fix on an upcoming Strategy release.
  
ACTION
This issue has been fixed in Strategy 10.4 Hotfix 8 and Strategy 11.0. Upgrade to one of these versions to take advantage of the fix.


Comment

0 comments

Details

Knowledge Article

Published:

March 7, 2018

Last Updated:

December 11, 2018