When clicking "Edit SQL" on an Information Link in Information Designer it takes a long time before it allows editing of the Information Link's SQL query.

When clicking "Edit SQL" on an Information Link in Information Designer it takes a long time before it allows editing of the Information Link's SQL query.

Product: TIBCO Spotfire (desktop client / Analyst / Professional)

Version: 5.0, 5.5, 6.0, 6.5, 7.0, 7.5

--------------------

Product: TIBCO Spotfire Server

Version: 5.0, 5.5, 6.0, 6.5, 7.0, 7.5

--------------------

Description

When working with Information Links, there may be times where you need to manually edit the SQL and make use of the "Edit SQL" functionality. When pressing this button, you may notice that it takes a long time until you can use the interface and actually see the SQL editing interface. This article will describe how to make the dialog load much faster.

Symptoms:

When clicking the SQL button for an Information Link, it takes a long time for the Edit SQL dialog to load.

Cause:

Information Services, the component that handles Information Links in the TIBCO Spotfire environment, validates the metadata from the underlying data source when pressing the Edit SQL button. It does this to validate the integrity of the items belonging to the Information Model. If this takes a long time, it will take a long time before you get through to the SQL editing interface.

Resolution:

To prevent this from happening, you can disable the validation that happens when pressing this button. To do this, follow the steps outlined below.

1). Stop the TIBCO Spotfire Server. To do this, stop the Windows Service named TIBCO Spotfire Server X.X.

2). Open the Spotfire Server Configuration tool. Start Menu -> All Programs -> TIBCO Spotfire Server X.X -> Configure TIBCO Spotfire Server.

3). Enter the tool password. This is something you chose when first installing and configuring the server.

4). Choose "Export configuration from database...".

5). Save it in \tomcat\bin\ as configuration.xml.

6). Open the file \tomcat\bin\configuration.xml in Notepad.

7). Right above the row

--- add the following line (ensure the runtime-query-validation tag is not already present): False---

This will result in the following.

...

--- False ---

8). Save the file.
9). In the Spotfire Server Configuration tool, choose "Load configuration from file...".

10). Load the newly edited configuration.xml.

11). Go to the tab "Configuration".

12). In the bottom right, there is a button named "Save configuration...". Press this.

13). Choose Database (recommended) and save the configuration.

14). Start the spotfire service.

Make sure you have the back up of configuration.xml file before doing any changes in it. This will resolve the performance with the Edit SQL dialog but will not affect the performance of for example re-saving a data source or Information Link. To improve the performance for the latter, see the Knowledge Base article entitled, "Creating new or re-saving existing Information Models and elements take longer than expected."