Product: TIBCO Spotfire®
How to update the SQL statement for a data connector used in a Spotfire analysis dxp that fails to load when a database timeout error is received?
The Spotfire analysis file that uses a Data Connector to query data does not open. While the analysis file is loading data, you get a time out due to an SQL error condition. This could be as there were updates on the data source side and an increase in data has caused an SQL error. This article explains how to update the data connection.
Important: This is only possible if the Data Connection is saved in a Spotfire library.
If the data connector is saved on the Spotfire library you can update the SQL.
1. In a Spotfire client go to Tools > Manage Data Connections.
2. Navigate to your data connector saved in the library.
3. Right click on the connector and select "Edit Data Connections...".
4. In the new dialog, click the "Edit" button and correct the data connection accordingly.
TIBCO Spotfire Web Help:
data connector; SQL statement, update, modify, update sql query, correct, SQL error, time out