KB43249: In MicroStrategy Enterprise Manager 9.0.x - 9.3.1, for a few records, the timestamp seen in the column "EM_LOAD_TS" of the table IS_REP_FACT does not correspond to the time of actual data load for that record

SYMPTOM
In Strategy Enterprise Manager 9.0.x - 9.3.1, the timestamp seen in the IS_REP_FACT table column 'EM_LOAD_TS'  does not correspond to the time at which data load was performed for this data. This column is meant to indicate the timestamp at which data gets moved into the respective fact table.
 
STEPS TO REPRODUCE

1. Configure Statistics logging on 2 projects on Strategy Intelligence Server 9.0.x - 9.3.1.
2. Login to both the projects and run reports on both the projects within the same Intelligence Server session.
3. On Strategy Enterprise Manager 9.0.x - 9.3.1, configure project P1 for data load.
4. On Day1, perform data load for project P1 . The EM_LOAD_TS in IS_REP_FACT corresponds to the time at which data load was performed.
5. On Day6, add project P2 to Strategy Enterprise Manager console and perform a data load.
6. Check the report execution data corresponding to Step 2 from above in the IS_REP_FACT table.
7. EM_LOAD_TS corresponding to this data does not show the timestamp from Day6, it shows the timestamp from Day1.

 
CAUSE
This is a known issue with Strategy Enterprise Manager 9.0.x - 9.3.1 data load.
 
ACTION
Contact Strategy Technical Support for an update on this issue.