Knowledge

SQL Connector: How to activate and find trace records

Article Number: 000040980 | Last Modified: 2018/11/21

Description

The table /QTQVC/TRACE is used to store trace information for the SQL Connector.
Records are written when the connection string property "Trace=1;" is added in SQL Connection String in the script.

Resolution

To activate the trace, set Trace=1 in the connection string (from release 6.1 above, it also works with trace=true;). Note that, by default, trace is set to "false".

CUSTOM CONNECT TO "Provider=QvSAPSqlConnector.exe;servertype=0;...;........;Trace=true;...............;XUserId=xxxx;XPassword=xxxxx;";

To retrieve the Trace records:
1. First find the Jobnumber in the SQL connector log. By default the log are saved in C:\ProgramData\QlikTech\Custom Data\QvSAPSqlConnector\Log
2. On SAP side use transaction SE16 and enter the Jobnumber
3. Press the ‘Execute’ button.
4. To save the records in an Excel file, click on System > List > Save > Local File

Note:

It is recommended to have the Trace set to "false". Keeping Trace to "true" would have negative impact on the performance.
It is possible to delete old Trace records from the database by using the transaction /n/qtqvc/delete in the SAP system.

Get Answers

Find Answers

Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us

Get Support

Have a Question?

Search Qlik's Support Knowledge database or request assisted support for highly complex issues.

Submit a case

Talk with a Representative

Critical Issues

Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.

Call Us