SYMPTOM
When performing a manual data load in Strategy Enterprise Manager the following error is returned in the MSTRMigration.log:
Violation of PRIMARY KEY constraint `IS_REP_F_PK`. Cannot insert duplicate key in object `IS_REP_FACT`.
CAUSEA possible reason for this error to occur is when there is inconsistent data in the IS_REP_FACT table in the Strategy Enterprise Manager data warehouse.
ACTIONUsers can run a custom window data load to address this issue. Detailed steps to implement have been provided below.
- Update the EM_IS_LAST_UPDATE table as per the recommendations outlined in the following tech note:
KB8192 : 'More than one failed migration windows were found. This process cannot continue' error message appears when performing a dataload in Strategy Enterprise Manager 9.x
- In the Strategy Enterprise Manager Console select Tools then Data Load Options as shown in the image below: