MicroStrategy ONE

Configuring what Enterprise Manager data load information is logged

You can configure Enterprise Manager to collect information about the data load operation. Over time the information in the log files and table can become outdated and no longer relevant to your analysis. You can keep them to a manageable size, making them easier to maintain and faster to query. You can also configure Intelligence Server to log information.

For the names of the files and table, where they are, the types of information they store, what to check in them when troubleshooting a data load, see Checking Enterprise Manager log files.

To configure Enterprise Manager data loading logs

Open MicroStrategy Command Manager and execute the following command:

SET [LOGGING LOCATION "<logging_location>"] ERROR ACTION (CONTINUE | STOP | SKIP) OVERLAP ACTION (START | WAIT) DB LOG (ENABLED | DISABLED) PURGE DB LOG AFTER <num_lines> LINES PURGE XML LOG AFTER <size> BYTES IN ENTERPRISE MANAGER "<em_server>" IN PORT <em_port>;

Configure the following parameters to configure the Enterprise Manager logs:

  • LOGGING LOCATION. Specifies where the MAEntMgr.xml log file is stored. You may find the information in this file helpful for troubleshooting errors that occur in the data load.
  • ERROR ACTION: Set to (CONTINUE), (STOP) , or (SKIP) to set the action a data load will take when an error occurs.
  • OVERLAP ACTION: Set to (START) or (WAIT) to set the action a data load will take if there is another loading process currently running.
  • DB LOG: Set to (ENABLE) or (DISABLE) to allow or disallow logging of Enterprise Manager log info to the EM_LOG table in the Enterprise Manager Warehouse.
  • PURGE DB LOG AFTER <> LINES: Sets the number of lines saved in the EM_LOG table. The minimum is value is 0, and the maximum is 999999.
  • PURGE XML LOG AFTER <> BYTES: To allow Enterprise Manager to control the MAEntMgr.xml log file's size. Specify the size bytes that triggers the backup. When the file gets to the specified size, Enterprise Manager renames the log file by appending a sequential number to the name, creates a new MAEntMgr.xml file, and continues to log information in it. The minimum is 0 and the maximum is 50000.

To configure Intelligence Server to log data load information about Enterprise Manager

  1. Open the Diagnostics and Performance Logging Tool.
    • In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then select Diagnostics Configuration.
    • In UNIX/Linux: Navigate to the directory ~/MicroStrategy/bin and enter mstrdiag.
  1. In the Kernel component list, in the row of the EM Migration Trace, open the File Log drop-down list, and select the name of the file to log information to.
  2. Click Save.

You can use the Health Center Console to read the log file. For steps, see the System Administration Help.