How to handle TIBCO Data Virtualization Studio unresponsive issue when generating Query Execution Plan?

How to handle TIBCO Data Virtualization Studio unresponsive issue when generating Query Execution Plan?

book

Article ID: KB0071256

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All supported versions

Description

In TIBCO Data Virtualization(TDV) Studio, when generating a query plan the Studio may become unresponsive if the SQL in the query is very large. This article provides details on how to overcome this situation.   

Environment

All supported Operating Systems

Resolution

Set the Studio configuration > Server > SQL Engine > Cache > 'Max sql string cache' to a higher value.  

Note - The default value is 0, meaning the functionality is disabled. Set a value above 0 to limit the cached SQL length, e.g. 10000 or 100000. Setting this value to higher than 10000 does not have any side effects on the TDV Server or the query plan being generated.  No restart is required for this configuration to take effect. 

Screenshot of the configuration for reference :

  User-added image

If the above configuration does not help, it may be an Out of Memory scenario in which case, contact TIBCO Support.  for assistance.

Issue/Introduction

How to handle TIBCO Data Virtualization Studio unresponsive issue when generating Query Execution Plan?