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>