I have a SP that has a parameter as INT.  I,e,@PlanId 

 

#prompt('@PlanId','integer')#

When I tried to add above prompt in framework manager, it failed in validation.  I have tried different way but none works. Can you please provide a quick guide?

 

Below is the doc that I refer to. We have no issues when adding varchar parameters.

 

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_fm.10.1.0.doc/ug_fm_id5101stored_procedure_query_subjects.html

 

------------------------------
ella ye
------------------------------

#CognosAnalyticswithWatson

Hi Ella,
What is the error message that you're getting?
Can you give a screenshot of the FM definition of the stored procedure as well as the first couple of lines of the stored proc itself, just to check that the arguments are imported correctly.
Also, which version and mode of Cognos are you using?
//Henk

------------------------------
HENK CAZEMIER
------------------------------

hi HENK,

Thanks for help.
I use IBM Cognos Analytics 11.0.7.
Attached the error screenshot.

Code:

CREATE PROCEDURE [dbo].[SP_TEST_1]
@PlanId INT , @Soe VARCHAR(10)   
AS
BEGIN

------------------------------
ella ye
------------------------------

Original Message:
Sent: Thu May 16, 2019 03:53 PM
From: HENK CAZEMIER
Subject: Adding SP in framework manager with int type argument

Hi Ella,
What is the error message that you're getting?
Can you give a screenshot of the FM definition of the stored procedure as well as the first couple of lines of the stored proc itself, just to check that the arguments are imported correctly.
Also, which version and mode of Cognos are you using?
//Henk

------------------------------
HENK CAZEMIER
------------------------------

Hi Ella,
It looks like the input value is incorrect. It is a zero followed by a number of newline characters.
When the FM prompt dialog comes up, have you tried re-entering the value?
If that fails:
Have you tried clearing the prompts in FM ?  (select a query Subject, select test, select options..., select prompts..., clear all)
Restarting FM might be quicker.
After that run the test again and see if you get the same/similar error.
If neither of those approaches work, we can do a webex at your convenience and see if I can spot what's going wrong.
//Henk

------------------------------
HENK CAZEMIER
------------------------------

Original Message:
Sent: Thu May 16, 2019 05:07 PM
From: ella ye
Subject: Adding SP in framework manager with int type argument

hi HENK,

Thanks for help.
I use IBM Cognos Analytics 11.0.7.
Attached the error screenshot.

Code:

CREATE PROCEDURE [dbo].[SP_TEST_1]
@PlanId INT , @Soe VARCHAR(10)   
AS
BEGIN

------------------------------
ella ye
------------------------------


Original Message:
Sent: Thu May 16, 2019 03:53 PM
From: HENK CAZEMIER
Subject: Adding SP in framework manager with int type argument

Hi Ella,
What is the error message that you're getting?
Can you give a screenshot of the FM definition of the stored procedure as well as the first couple of lines of the stored proc itself, just to check that the arguments are imported correctly.
Also, which version and mode of Cognos are you using?
//Henk

------------------------------
HENK CAZEMIER

Hi henk,

In fact there was no prompt pop up asking for value.

Once I clicked ‘validate’ I got that error message and I didn’t even have chance to input a test value.


Ella

发自我的 iPhone

------Original Message------

Hi Ella,
It looks like the input value is incorrect. It is a zero followed by a number of newline characters.
When the FM prompt dialog comes up, have you tried re-entering the value?
If that fails:
Have you tried clearing the prompts in FM ?  (select a query Subject, select test, select options..., select prompts..., clear all)
Restarting FM might be quicker.
After that run the test again and see if you get the same/similar error.
If neither of those approaches work, we can do a webex at your convenience and see if I can spot what's going wrong.
//Henk

------------------------------
HENK CAZEMIER
------------------------------

#CognosAnalyticswithWatson