How To Collect Logs From Qlik ODBC Connector Package

[Sonja_Bauernfeind]

Logging in Qlik ODBC Connector Package consists of two different parts.

• Qlik ODBC Connector logging
• ODBC driver logging

Qlik ODBC Connector Package Logging

• Edit Qlik ODBC Connector Package config file. Default location; C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\QvODBCConnector.exe.config
• Locate the LoggingLevel setting and change the value to ALL

      <setting name="LoggingLevel" serializeAs="String">
	        <value>ALL</value>
      </setting>

• Logs can be collected from C:\ProgramData\Qlik\Custom Data\QvODBCConnector\Log 
• Disable debug logging after finished troubleshooting, by setting LoggingLevel setting and change the value to INFO

      <setting name="LoggingLevel" serializeAs="String">
	        <value>INFO</value>
      </setting>

Qlik ODBC Driver Logging

Warning: Modifications to the Windows Registry cannot be supported by Qlik. Always ensure you have a viable backup before beginning this procedure. Modify the registry at your own risk.

Note: Older Qlik Sense versions may use the registry path HKEY_LOCAL_MACHINE\SOFTWARE\Simba\Simba SQL Server ODBC Driver\Driver

• Open Windows Registry Editor (RegEdit.exe)
• Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Qlik\DRIVER_NAME\Driver 
  Replace DRIVER_NAME with the actual subfolder matching the desired data source
• Create the following String values, if they are missing
  • LogFileCount = 50
  • LogFileSize = 20971520
  • LogLevel = 0
  • LogPath = A valid path on disk (e.g., C:\ProgramData\Qlik\Driver)
• Change the LogLevel value to desired log level, as advised by Qlik Support
  • 0 = Disabled
  • 3 = Detailed
  • 6 = Debug
• Logs can be collected from the path defined in LogPath value in Step 3
• Disable logging after finished troubleshooting, by setting LogLevel to 0