KB322215: No data is loaded during scheduled data load due to the end date being hit in MicroStrategy Enterprise Manager 10.x

• Strategy

This technote details an issue where a scheduled data load fails to run after a particular date. The following error is displayed in the MAEntMgr.xml file: 2017-01-23 15:35:23.991+00:00 [Logger:MAEntMgr][Thread:RMI TCP Connection(77)-169.254.210.199] [Level:INFO] The schedule "DL Tutorial" with GUID 706B129D158BB15CA266775008351218 is expired

SYMPTOM
This technote details an issue where a scheduled data load fails to run after a particular date.
The following error is displayed in the MAEntMgr.xml file:


2017-01-23 15:35:23.991+00:00 [Logger:MAEntMgr][Thread:RMI TCP Connection(77)-169.254.210.199]
[Level:INFO] The schedule "DL Tutorial" with GUID 706B129D158BB15CA266775008351218 is expired
2017-01-23 15:35:24.042+00:00 [Logger:MAEntMgr][Thread:RMI TCP Connection(77)-169.254.210.199]
[Level:INFO] The schedule "DL Tutorial" with GUID 706B129D158BB15CA266775008351218 is expired

The lines below will be repeated in the log for each project referenced in the affected data load:


2017-01-23 15:39:37.101+00:00 [Logger:MAEntMgr][Thread:pool-1-thread-3]
[Level:INFO] The schedule "<Data Load Name>" with GUID <GUID_ID> is expired

CAUSE
The scheduled data load has an end date which has been reached and subsequent data loads will not be executed. See the example below:

In the image above, there are two projects being monitored:

These projects have been monitored since 1st January 2017 until the 23rd January 2017:

Once the End Date is reached, the data load will stop processing statistics generated after the date and time has been reached.

ACTION
Use Command Manager to re-create the data load
Here is a sample CREATE DATA LOAD outline with the end date removed:


CREATE DATA LOAD "DL Tutorial" FOR ENVIRONMENT "<environment_name>" AND 
PROJECT "Duplicated Strategy Tutorial", ENVIRONMENT "<environment_name>"
AND PROJECT "Strategy Tutorial" DO ACTION UPDATEWAREHOUSE CLOSESESSIONS
UPDATEOBJECTDELETIONS UPDATESTATS BEGIN DATE "01/01/2017 12:00:00 +0000" 
FREQUENCY DAILY ON MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY AT 
12:00:00 ENABLED IN ENTERPRISE MANAGER "localhost" IN PORT 9999;

In Command Manager, the following data load properties will be seen:

Comment

0 comments

Details

Knowledge Article

Published:

April 7, 2017

Last Updated:

April 7, 2017

2017-01-23 15:35:23.991+00:00 [Logger:MAEntMgr][Thread:RMI TCP Connection(77)-169.254.210.199] [Level:INFO] The schedule "DL Tutorial" with GUID 706B129D158BB15CA266775008351218 is expired 2017-01-23 15:35:24.042+00:00 [Logger:MAEntMgr][Thread:RMI TCP Connection(77)-169.254.210.199] [Level:INFO] The schedule "DL Tutorial" with GUID 706B129D158BB15CA266775008351218 is expired

CREATE DATA LOAD "DL Tutorial" FOR ENVIRONMENT "<environment_name>" AND PROJECT "Duplicated Strategy Tutorial", ENVIRONMENT "<environment_name>" AND PROJECT "Strategy Tutorial" DO ACTION UPDATEWAREHOUSE CLOSESESSIONS UPDATEOBJECTDELETIONS UPDATESTATS BEGIN DATE "01/01/2017 12:00:00 +0000" FREQUENCY DAILY ON MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY AT 12:00:00 ENABLED IN ENTERPRISE MANAGER "localhost" IN PORT 9999;