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

[Jingyi_Lin]

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

To enable tracing:

1. Locate the odbcinst.ini file
   The file is typically located at /etc/odbcinst.ini
2. Edit the file by opening it in a text editor
3. Find the [ODBC] section.
4. 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.
   
   
5. Save the file
6. Restart the Qlik Replicate service
7. Give 777 permissions to the directory where TraceFile is located so that Qlik Replicate can create the log file
8. 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