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

KB438968: What Logs Should I Provide When Opening A Technical Support Case Relating To Enterprise Manager


Joe Vitale

Manager, Cloud Support • MicroStrategy


The aim of this article is to catalog and expedite the troubleshooting process for Enterprise Manager by ensuring that complete data makes it into our support organization before troubleshooting begins.

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
  <match target="font">
     <edit mode="assign" name="antialias">
       <bool>true<bool>
     </edit>
  </match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

 Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203Enterprise Manager 10.xData Load IssuesTo better understand the problem, please provide us with the following information:

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
  <match target="font">
     <edit mode="assign" name="antialias">
       <bool>true<bool>
     </edit>
  </match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

 Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203Enterprise Manager 10.xData Load IssuesTo better understand the problem, please provide us with the following information:


Report IssuesTo better understand the problem, please provide us with the following information:


Report IssuesTo better understand the problem, please provide us with the following information:


Enterprise Manager 9.xData Load IssuesEnterprise Manager 9.x Data Load issues


Enterprise Manager 9.xData Load IssuesEnterprise Manager 9.x Data Load issues


Enterprise Manager 9.xData Load IssuesEnterprise Manager 9.x Data Load issues


Report IssuesTo better understand the problem, please provide us with the following information:


Report IssuesTo better understand the problem, please provide us with the following information:


Enterprise Manager Console IssuesTo better understand the problem, please provide us with the following information:


Enterprise Manager Console IssuesTo better understand the problem, please provide us with the following information:



KB438968


Comment

0 comments

Details

Knowledge Article

Published:

November 22, 2017

Last Updated:

January 4, 2019