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.   

All supported Operating Systems

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 :

 

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

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