Default log level of the Qlik ODBC Connector is Error, which means that only errors are registered in the connector logs.
Default log file location is; C:\ProgramData\Qlik\Custom Data\QvOdbcConnectorPackage\Log
The Qlik ODBC Connector allows for seven (7) levels of logging. In the below listed order, the log detail level increases from top to bottom, where OFF logs nothing and ALL logs most details. INFO, DEBUG and ALL should only be used for troubleshooting, as they can decrease performance and generate very large log files.
- OFF
- FATAL
- ERROR
- WARN
- INFO
- DEBUG
- ALL
For troubleshooting the Qlik ODBC Connector log level can be changed to ALL by following the below steps.
IMPORTANT: Restore log level to WARN or lower when not troubleshooting.
- Open Windows File Explorer
- Browse to the Qlik ODBC Connector installation folder, with default location C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage
- Open the QvOdbcConnectorPackage.exe.config file in a text editor
- Locate the LoggingLevel value
<setting name="LoggingLevel" serializeAs="String">
<value>ERROR</value>
</setting>
- Change the LoggingLevel value to preferred logging level. For example ALL during troubleshooting.
<setting name="LoggingLevel" serializeAs="String">
<value>ALL</value>
</setting>
- Save the configuration file
- Reload app utilizing ODBC connection to gather more detailed logs