How to get the Spotfire Data Virtualization resource data logged in the logs for investigation purposes?

book

Article ID: KB0138640

calendar_today

Updated On:

Products	Versions
TIBCO Data Virtualization	All supported versions

Description

This article provides details on how to get the Spotfire Data Virtualization(SDV) resource data logged in the logs for investigation purposes.

Environment

All supported Operating Systems

Resolution

Enabling the below Studio configuration helps log the SDV resource data in cs_server_dsrc.log file -

In Studio > Administration tab > Configuration > Server > Data Sources > Common to Multiple Source Type > Set 'Trace Level' to 3. Click 'Apply' to save the changes.

No SDV Server restart is required for the changes to take effect.

After the SDV resource is executed from Studio / client request, data will be logged in cs_server_dsrc.log file.

Here is sample data being logged in cs_server_dsrc.log file -

INFO [LoadPipeThread (jetty thread pool-6241)] 2026-08-08 20:31:57.245 -0400 datasource - Thread: LoadPipeThread (jetty thread pool-6241)|QUERY EXECUTED|SELECT "tutorial"."customers"."customerid","tutorial"."customers"."companyname","tutorial"."customers"."contactfirstname","tutorial"."customers"."contactlastname","tutorial"."customers"."billingaddress","tutorial"."customers"."city","tutorial"."customers"."stateorprovince","tutorial"."customers"."postalcode","tutorial"."customers"."countryregion","tutorial"."customers"."contacttitle","tutorial"."customers"."phonenumber","tutorial"."customers"."faxnumber" FROM "tutorial"."customers" FETCH FIRST 1000 ROWS ONLY 
INFO [LoadPipeThread (jetty thread pool-6241)] 2026-08-08 20:31:57.245 -0400 datasource - Thread: LoadPipeThread (jetty thread pool-6241)|DATA FETCH FIRST ROW RECEIVED|
INFO [LoadPipeThread (jetty thread pool-6241)] 2026-08-08 20:31:57.245 -0400 datasource - Thread: LoadPipeThread (jetty thread pool-6241)|DATA|1|Able Computing|Jason|Born|1220 Billing Street|Union City|CA|94456|USA|VP Sales|(510) 556-9944|Unknown|
INFO [LoadPipeThread (jetty thread pool-6241)] 2026-08-08 20:31:57.245 -0400 datasource - Thread: LoadPipeThread (jetty thread pool-6241)|DATA|2|Anston Systems|Max|Fagan|1113 Franklin Street|Burlingame|CA|94010|USA|Sr. Director Sales|(650) 778-9900|(650) 778-0098|
INFO [LoadPipeThread (jetty thread pool-6241)] 2026-08-08 20:31:57.245 -0400 datasource - Thread: LoadPipeThread (jetty thread pool-6241)|DATA|3|Blackard Electronics|Jennifer|Smith|445 Union Avenue|San Mateo|CA|93345|USA|VP Purchasing|(650) 998-0332|(650) 998-7865|
INFO [LoadPipeThread (jetty thread pool-6241)] 2026-08-08 20:31:57.245 -0400 datasource - Thread: LoadPipeThread (jetty thread pool-6241)|DATA|4|Connect Software|David|Padillo|298 Fairfax Street|Philadelphia|PA|19564|USA|Sr Purchasing Manager|(215) 665-0312|(215) 665-8432|
INFO [LoadPipeThread (jetty thread pool-6241)] 2026-08-08 20:31:57.245 -0400 datasource - Thread: LoadPipeThread (jetty thread pool-6241)|DATA|5|Canal Street Solutions|Jackson|Ludwig|2 Front Street|Reading|PA|19602|USA|Engineering Manager|(610) 476-9834|(610) 476-0348|
INFO [LoadPipeThread (jetty thread pool-6241)] 2026-08-08 20:31:57.245 -0400 datasource - Thread: LoadPipeThread (jetty thread pool-6241)|DATA|6|Dickinson Associates|George|Black|310 Chestnut Street|Baltimore|MD|28740|USA|Sr. Database Manager|(410) 775-0736|(410) 775-9742|
..
INFO [LoadPipeThread (jetty thread pool-6241)] 2026-08-08 20:31:57.247 -0400 datasource - Thread: LoadPipeThread (jetty thread pool-6241)|DATA FETCH FINISHED|Total Rows: 30
INFO [LoadPipeThread (jetty thread pool-6241)-org.postgresql.jdbc.PgConnection@57bd5e38] 2026-08-08 20:31:57.250 -0400 datasource - Thread: LoadPipeThread (jetty thread pool-6241)-org.postgresql.jdbc.PgConnection@57bd5e38|Hashcode :1472028216CONNECTION COMMITED|