How To Collect Logs From Qlik ODBC Connector Package

Sonja_Bauernfeind — Thu, 19 Nov 2020 12:32:22 GMT

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

article How To Collect Logs From Qlik ODBC Connector Package in Official Support Articles

How To Collect Logs From Qlik ODBC Connector Package