INTRODUCTION
This knowledge base article provides best practices for configuring, monitoring and troubleshooting Enterprise Manager 10.x. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Enterprise Manager and to address issues encountered during the statistics logging and data load processes.
The MicroStrategy Enterprise Manager guide is a useful resource providing a general overview of the product.
ENTERPRISE MANAGER SETUP AND CONFIGURATION
Enterprise Manager 10.x is configured and monitored using Strategy Command Manager. Operations Manager and Health Center should not be used for monitoring Enterprise Manager in Strategy 10.x. The operations that were previously performed from Operations Manager > Enterprise Manager such as creating environment, creating data load and running data load etc., are now done through Command Manager.
The following resources provide step by step instructions for installing and configuring Enterprise Manager:
KB439410: Enterprise Manager Installation and Configuration for 10.x
*Video guide with step by step instructions for installing and configuring Enterprise Manager 10.x
KB318297: How to install, configure, and validate Strategy Enterprise Manager 10.x
*Contains a detailed step by step guide for performing the configuration
KB439767: How to configure Enterprise Manager Data Loads using Command Manager commands in Strategy 10.x
*A comprehensive list of commands used to monitor and configure data loads in Command Manager. This article is particularly useful if Enterprise Manager data loads were previously set up using Operations Manager and guidance is needed on how to monitor and configure those data loads using Command Manager.
KB309808 : How to create a new Enterprise Manager 10.x warehouse and project while retaining an existing 9.x warehouse and project
*During the upgrade from Strategy 9.x to 10.x, the above steps should be take to ensure the validity of the Enterprise Manager 10.x configuration.
KB441084: How to enable automatic restart of Enterprise Manager Data Loader service if the process crashes in Strategy 10.x.
*Enabling this setting will allow the Enterprise Manager Data Loader service to automatically restart in the event of a process crash
In Strategy 10.x, Enterprise Manager and Command Manager are available for UNIX/Linux Operating Systems as well. The GUI for Command Manager is the same on Windows as well and on UNIX/Linux Operating Systems.
Documentation for configuring Enterprise Manager 10.x on UNIX/Linux Operating Systems when no GUI is available:
KB272905: How to set up the Enterprise Manager Repository for the 10.x Enterprise Manager Service in a UNIX/Linux environment without a GUI
Using the text-based Command Manager interface
*Enterprise Manager commands can be run through Command Manager using the text-based command line interface described in this documentation
KB289406: How to create an Enterprise Manager Project in Strategy 10.x using a response file on Linux
KNOWN ISSUES IN ENTERPRISE MANAGER 10.x
The articles below reference Enterprise Manager related issues that have been found and documented for Strategy versions 10.x.
KB441023: In Strategy Enterprise Manager 10.x, connecting multiple Enterprise Manager services to the same Enterprise Manager warehouse may result in unexpected behavior
*Article addresses issues encountered when connecting multiple Enterprise Manager Data Loader services to the same warehouse
KB261955: Dataload fails with error “ORA-06575: Package or function SP_IS_SESSION is in an invalid state” in Strategy Enterprise Manager 10.0 - 10.1 Hotfix 1 when using an Oracle database for the Enterprise Manager warehouse
*Issue addressed in Strategy 10.2 and newer
KB286781: In Strategy Secure Enterprise 10.x, Enterprise Manager data load hangs when running on non-English Operating Systems
*Issue addressed in Strategy 10.3 and newer
KB294901: The database connection processes spawned by the data load constantly increase when running data loads through the Enterprise Manager Data Loader 10.x service
*Issue addressed in Strategy 10.3 and newer
KB268204: Strategy 10 Enterprise Manager Data Loader Service cannot be started with the error "The Strategy Enterprise Manager Data Loader service terminated with the following service-specific error: %%4294967295"
*Issue addressed in Strategy 10.4 Hotfix 3 and newer
KB301095: Custom time window data loads do not correctly refresh warehouse data in Enterprise Manager 10.x
*Issue addressed in Strategy 10.7, 10.4 Hotfix 3 and newer
KB300792: Enterprise Manager 10.x data load fails with error "An error ocurred and EVENT could not be loaded"
KB289904: Strategy Enterprise Manager data load 10.x process stops with a MultiprocessBaseException error
KB273206
