SYMPTOM:
In some certain Chinese Enterprise Manager environments, even the data load shows completed and successful from Command Manager, when checking the data from the tables in Database, users find below tables are empty.
IS_PROJ
IS_REP
IS_DOC
IS_REP_FACT
IS_DOC_FACT
...
No obvious error from MAEntMgr.xml or Migration log. Data in EM_IS_LAST_UPDATE also shows the data load is successful with IS_STATUS=1.
CAUSE:
The created data load stored as Chinese time in table EM_CONFIGURATION (like below), while the Strategy Intelligence Server cannot handle the Chinese.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><EMSchedule><ScheduleName>dataload_name</ScheduleName><GUID>xxxxxx</GUID><DateBegin>星期五 三月 02 14:00:00 UTC 02018</DateBegin><DateEnd>星期六 三月 02 14:00:00 UTC 02030</DateEnd><Operation><Command>1</Command><Command>5</Command><Command>3</Command><ProjectList><MetadataGUID>xxxxxx</MetadataGUID><ProjectGUID>xxxxxx</ProjectGUID></ProjectList><Options><Options>0</Options></Options></Operation><ScheduleRecurrence><StartHour>星期四 一月 01 22:00:00 UTC 01970</StartHour><EndHour></EndHour><RecurrenceMins>0</RecurrenceMins><ExecutionDays>*******</ExecutionDays></ScheduleRecurrence><ScheduleType>Daily</ScheduleType><Enabled>1</Enabled></EMSchedule>
<?XML version="1.0" encoding="UTF-8" standalone="yes"?><EMSchedule><ScheduleName>dataload_name</ScheduleName><GUID>xxxxxx</GUID><DateBegin>Fri Mar 02 14:00:00 UTC 02018</DateBegin><DateEnd>Sat Mar 02 14:00:00 UTC 02030</DateEnd><Operation><COMMAND>1</COMMAND><COMMAND>5</COMMAND><COMMAND>3</COMMAND><ProjectList><MetadataGUID>xxxxxx</MetadataGUID><ProjectGUID>xxxxxx</ProjectGUID></ProjectList><Options><Options>0</Options></Options></Operation><ScheduleRecurrence><StartHour>Thur JAN 01 22:00:00 UTC 01970</StartHour><EndHour></EndHour><RecurrenceMins>0</RecurrenceMins><ExecutionDays>*******</ExecutionDays></ScheduleRecurrence><ScheduleType>DAILY</ScheduleType><ENABLED>1</ENABLED></EMSchedule>