KB268204: MicroStrategy 10 Enterprise Manager Data Loader Service cannot be started with the error "The MicroStrategy Enterprise Manager Data Loader service terminated with the following service-specific error: %%4294967295"

SUMMARY
This Knowledge Base article describes a known issue with Strategy 10.x Enterprise Manager. The Strategy Enterprise Manager Data Loader Service fails to start successfully whenever there is a failed data load in the EM_RECOVERY table. A fix for this issue has been implemented in Strategy 10.4 Hotfix 3 and newer.
 
SYMPTOM
When trying to start the Strategy Enterprise Manager Data Loader Service by using Strategy Service Manager, the service fails to start successfully and automatically gets back to "stopped" status. Trying to start the Strategy Enterprise Manager Data Loader Service by using the Windows Services presents the same behavior.
 
When checking the Windows Event Viewer, the following error message can be found:

"The Strategy Enterprise Manager Data Loader service terminated with the following service-specific error: %%4294967295

TRUNCATE TABLE EM_RECOVERY;

 
In all the subsequent rows, the columns IS_WIN_BEGIN and IS_WIN_END will indicate the period for which a successful data load was processed. 

 
If a data load was interrupted or failed, the incomplete data load process will be shown as an additional row with a value of "0" in the column IS_STATUS. The difference with the healthy control row is that the column IS_WIN_BEGIN will show the date for the starting period of the interrupted/failed data load process as shown below:

 
In order to remove the traces of the failed data load, the rows from the table EM_IS_LAST_UPDATE that represent failed data loads can be converted to represent successful data loads.Using the example above, it can be seen that the information was correctly migrated until 10/15/15 10:51:25 PM. After that, the failed data load can be observed with the EMLU_ID = 21. This data load now has a value of "0" in the column IS_STATUS. 

 
In order to change the failed data load entry to show up as a successful data load in the EM_IS_LAST_UPDATE table, a query similar to the one provided below can be run. In the following query 'x' is any EMLU_ID value for which IS_STATUS = 0 (other than the unique configuration row with the IS_REP_GUID and IS_PROJ_GUID columns with zeros and a IS_WIN_BEGIN column with the value 12/31/69 6:00:00 PM). This query will update the IS_STATUS of these rows to 1. 
 

UPDATE EM_IS_LAST_UPDATE SET IS_STATUS=1 where EMLU_ID ='x';