Procedure element created in TIBCO Spotfire is not updated when the procedure header is modified in the source database

Procedure element created in TIBCO Spotfire is not updated when the procedure header is modified in the source database

book

Article ID: KB0072335

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

You may have a stored procedure element in the Information Designer which has an input parameter defined. When creating the stored procedure in the Information Designer (see Creating a Query Procedure) the input parameters will be populated under 'Input Parameters' section automatically.

When new input parameters are added or removed from the procedure header in the source database, the 'Input Parameters' section of the Procedure element in the Information Designer will not be updated automatically. The following steps describes how to update the Input parameters without having to recreate the procedure element or Information link.
 

Issue/Introduction

This article describes the workaround to update the input parameters section in Procedure element when the procedure header in the source database server is modified

Resolution

Instead of recreating the procedure from scratch, which will then have a new GUID and will require all Information Links which reference this procedure to get updated, it is better to instead edit the existing procedure element. 

1. In the Information Designer, right click on the Procedure and select "Edit"
User-added image

2. Highlight any other procedure from the Data Sources tab tree view and click "Select". Then highlight and select the original procedure again by clicking the "Select" button a second time.
User-added image

Now the "Input Parameters" section will be updated in procedure element with the modified input parameters, and any Information Links containing that procedure will work as usual.

Note: Be sure to close and reopen the Information Designer after any changes have been made on the procedure (like modification of input parameters) so that the changes are seen in Spotfire. 

Additional Information

Doc: Overview of Procedures in Information Designer Doc: Creating a Query Procedure Doc: Procedure Element Tab