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 :
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?