How to enable ODBC trace log for Linux Server in Qlik Replicate

Jingyi_Lin — Fri, 31 Oct 2025 08:48:26 GMT

To troubleshoot an issue, it may be necessary to enable ODBC trace logging for Linux Servers.

To enable tracing:

Locate the odbcinst.ini file
The file is typically located at /etc/odbcinst.ini
Edit the file by opening it in a text editor
Find the [ODBC] section.
Add or modify the following lines:

Below the [ODBC] section:

Trace=Yes
TraceFile=/path/to/your/trace.log

Replace with the desired path and filename for your log.
Save the file
Restart the Qlik Replicate service
Give 777 permissions to the directory where TraceFile is located so that Qlik Replicate can create the log file
Reproduce the issue. Run your application to generate the trace log.

To disable tracing:

Once you are finished, repeat the steps and set Trace=Yes to Trace=No in the odbcinst.ini file.

odbcinst.ini example:

[ODBC Driver 18 for SQL Server]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.1.so.2.1
UsageCount=1
[ODBC]
Trace=Yes
TraceFile=/odbctrace/odbctrace.log
TraceOptions=3

Environment

Qlik Replicate

article How to enable ODBC trace log for Linux Server in Qlik Replicate in Official Support Articles

How to enable ODBC trace log for Linux Server in Qlik Replicate

odbcinst.ini example:

Environment