Qlik Community

Ask a Question

Knowledge Base

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER

How To Collect Logs From Qlik ODBC Connector Package

Sonja_Bauernfeind
Digital Support
Digital Support

How To Collect Logs From Qlik ODBC Connector Package

 

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
  • 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 
 

 

User-added image

Version history
Revision #:
4 of 4
Last update:
‎2020-11-19 07:32 AM
Updated by: