SYMPTOM
In Strategy Enterprise Manager, users see the following error message when attempting to run a data load:
'More than one failed migration windows were found. This process cannot continue.'
Once the EM_IS_LAST_UPDATE table is updated, the users can run a Custom Time Window Load under the Data Load Options in the Strategy Enterprise Manager console, which encompasses the time period for which they have not been able to do the data load or have been missing data.
NOTE: If the users just update the EM_IS_LAST_UPDATE table without a Custom Time Window Load to follow, they can experience loss of data for the time period that begins with the timestamp in the IS_WIN_END column of the first updated IS_STATUS row of zero ending with the last such updated row.
Enterprise Manager warehouse modification:
WARNING:
Manually editing values in the Strategy Enterprise Manager warehouse incorrectly may cause serious, project-wide problems that may make your project unusable and/or the data load to fail. Since these are user-initiated changes, they are not covered by any Strategy warranty. Users are strongly encouraged to back up the Strategy Enterprise Manager warehouse prior to any alteration.
