How to trace execution steps from a procedure in Tibco Data Virtualization (TDV)?
Article ID: KB0080430
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | - |
Description
This document shows how to trace execution steps from a procedure in Tibco Data Virtualization (TDV).
Issue/Introduction
This document shows how to trace execution steps from a procedure in Tibco Data Virtualization (TDV).
Resolution
Method 1:
CALL LOG() in a sqlscript will write the results of your input var into the cs_server.log file.
Example line in sql script procedure: call log('test');
Results in this in the log file: INFO [WProcResult Invoker] 2018-09-27 10:53:34.817 -0800 LogProcedure - test
Method 2:
CALL Print("Hello World") is another function that will print the values to console
Method 3:
Click on magnifying glass icon, at the right of the execute button.
It captures full trace on the console. Sometimes, capturing all the information might not be necessary. If you want to capture specific details only, use method 1 or 2. If you want to capture the messages directly in the log, instead of console, use method 1.
CALL LOG() in a sqlscript will write the results of your input var into the cs_server.log file.
Example line in sql script procedure: call log('test');
Results in this in the log file: INFO [WProcResult Invoker] 2018-09-27 10:53:34.817 -0800 LogProcedure - test
Method 2:
CALL Print("Hello World") is another function that will print the values to console
Method 3:
Click on magnifying glass icon, at the right of the execute button.
It captures full trace on the console. Sometimes, capturing all the information might not be necessary. If you want to capture specific details only, use method 1 or 2. If you want to capture the messages directly in the log, instead of console, use method 1.
Feedback
Yes
No
Powered by
