book
Article ID: KB0072335
calendar_today
Updated On:
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.
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"
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.
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.
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