SYMPTOM
After executing a command to run Custom Time Window for a data load, an error message returned. For example, the following command is executed:EXECUTE DATA LOAD "Test" WITH DATA FROM "7/22/2010 22:00:00 +0000" TO "8/01/2020 23:00:00 +0000" IN ENTERPRISE MANAGER "localhost" IN PORT 9999;
MicroStrategy Command Manager returned an error:
The end date may not be before the start date. Please enter a valid start/end date.
.png&w=3840&q=100)
However, as shown in the sample command, the end date is not before the start date.
CAUSE
End date for Custom Time Window option for Enterprise Manager Data Load cannot be a future date. When this command is executed, it was not yet August 1st, 2020. This error message appears even when you are just one hour ahead of the time you execute the command.
ACTION
Edit the end date to be a past date, then, execute the command again.
For more information about how to compose commands for Enterprise Manager data load, refer to Guideline_EM.pdf file attached to the following article:
KB273206: Best practices for configuration of MicroStrategy Enterprise Manager 10.x
KB441443