KB483864: How to turn on warehouse catalog logs, DataDirect Hive ODBC driver logs, and Simba Hive ODBC driver logs

How to Turn on WH Catalog Logs 

• Open Run by pressing Win + R on your keyboard.
• Input MADPCfg.exe to run the Strategy Diagnostics and Performance Logging Tool.
  

• In the Diagnostic Configuration tab, locate the DSS WHCatalog Component, and select its Console Log checkbox.
• From the File Log drop-down, select <New>.
  

• In the Log Destination Editor, enter a file name for this log, such as "WHCLog," and adjust the max file size if needed.
• Click Save.
  
  
  
  
• Click Save.
  
  
• You can find the logs in the folder C:\Program Files (x86)\Common Files\MicroStrategy\Log.
  
  

How to Turn on DataDirect Hive ODBC Driver Logs Linux

• Go to the Strategy install folder,

  $MSTR_HOME

  , and edit the odbc.ini:vim odbc.ini.
• Edit the

   Trace 

  to

  1

  ,

  TraceOptions

  to

  3

  , and

  TraceFile 

  to

  $MSTR_HOME/log/odbctrace.out

  :
  

  .. [ODBC]	Trace=1	TraceOptions=3	TraceFile=/opt/mstr/MicroStrategy/log/odbctrace.out	TraceDll=/opt/mstr/MicroStrategy/install/lib/MYtrcXX.so	InstallDir=/opt/mstr/MicroStrategy/install	IANAAppCodePage=106	UseCursorLib=0	UNICODE=UTF-8

  
  
• Restart the Intelligence Server:
  

  $mstrctl -s IntelligenceServer stop	$mstrctl -s IntelligenceServer start

  
  
• Fetch the warehouse catalog in Developer and find the log in

  $MSTR_HOME/log

  :
  

• They will have names such as

   odbctrace01.out

   and

  odbctraceINFO.out.

How to Turn on Simba Hive ODBC Driver Logs Linux

• In the Strategy install folder,

  $MSTR_HOME

  , edit the file 

  Strategy.hiveodbc.ini

  . If it is a Simba driver, the file name is

  simba.hiveodbc.ini

  .

  vim.Strategy.hiveodbc.ini

• Edit the

  LogLevel

  to

  6 

  and the

  LogPath 

  to

  $MSTR_HOME/log:

  
  

  [Driver]	DriverManagerEncoding=UTF-8	ErrorMessagesPath=/opt/mstr/MicroStrategy/install/locale/en_US/LC_MESSAGES/Hive	LogLevel=6	LogPath=/opt/mstr/MicroStrategy/log	SwapFilePath=/tmp		# SimbaDM / unixODBC	ODBCInstLib=libodbcinst.so

  
  
• Restart the Intelligence Server:
  

  $mstrctl -s IntelligenceServer stop	$mstrctl -s IntelligenceServer start

  
  
• Fetch the warehouse catalog in Developer and find the log in

  $MSTR_HOME/log:

• They will have names such as

  StrategyHiveODBCDriver_connection_0.log

   and

  StrategyHiveODBCDriver.log.