EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB440316: Data is not populated to Look up tables and Fact tables in Chinese Enterprise Manager environments


Yating (Tiffanie) Zhai

Senior Cloud Support Engineer III • MicroStrategy


Data not populated to some of the Look up tables (IS_PROJ; IS_REP..) and some of the Fact tables (IS_REP_FACT; IS_DOC_FACT) in certain Chinese Enterprise Manager environment.

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>

ACTION:
Delete the current Data load and create a new one. If it is populated as English in table EM_CONFIGURATION, then it is fine. If it still stored as Chinese, users may manually change the time to English for this table as below.

<?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>

Article Reference Number: KB440316 KB440316


Comment

0 comments

Details

Knowledge Article

Published:

March 29, 2018

Last Updated:

November 17, 2018