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

KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10.x to 11.x


Mari Sugimura

Senior Cloud Support Engineer III • MicroStrategy


To upgrade Enterprise Manager statistics and the Enterprise Manager warehouse from 10.x to 11.x and above, ensure your Enterprise Manager Data Loader service points to your Statistics and Enterprise Manager Repository.

When performing an in-place upgrade of Enterprise Manager 10.x to 11.x, a script is run against Enterprise Manager Statistics and the Warehouse. For the upgrade to be successful, your Enterprise Manager Data Loader service must point to your Statistics and Enterprise Manager Repository.
The Configuration Wizard will provide the option to upgrade your Enterprise Statistics and Manager Repository; however, this option does not upgrade your statistics and Enterprise Manager Repository with Strategy 2019.
If your upgrade is not successful, you can navigate to C:\Program Files (x86)\MicroStrategy\Enterprise Manager\Scripts and execute the the script that corresponds with your DBMS type.

  • em_upgrade_db2.sql
  • em_upgrade_mysql.sql
  • em_upgrade_ora.sql
  • em_upgrade_sql.sql
  • em_upgrade_syb.sql
  • em_upgrade_tera.sql


 

ka02R000000btWkQAI_0EM2R000000h7TZ.jpeg

KB483298


Comment

0 comments

Details

Knowledge Article

Published:

May 21, 2019

Last Updated:

July 30, 2020