Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: yogeswari on 11 Dec 2013 04:48:20 AM

Title: Error when executing stored procedure in FM
Post by: yogeswari on 11 Dec 2013 04:48:20 AM
Hi,

I am getting the below error when i validate a stored procedure in Framework manager.

RQP-DEF-0179 The procedure call "G-N DB"..MOD."MRK_KRN_PKG.BUILD_MS_DATA"(:A_CONTRACT_NUMBER IN,:A_PERIOD_START_DATE IN,:A_PERIOD_END_DATE IN,:A_RETURN_CODE OUT) is unable to return a result set.

could anyone tell what is the reason behind this.  please provide your solutions as what can be done.

thanks,
yogeswari.
Title: Re: Error when executing stored procedure in FM
Post by: saumil287 on 11 Dec 2013 05:59:12 AM
Hi,
Check whether SP is update or select procedure?
OR
Input different values in the parameters and see the results.
Title: Re: Error when executing stored procedure in FM
Post by: yogeswari on 11 Dec 2013 06:39:10 AM
Hi,

thanks for your response.  How to check the SP code?  I mean to say i dont have access to view the code of stored procedure.  In this case, what can be done?

Please suggest.

thanks,
yogeswari.
Title: Re: Error when executing stored procedure in FM
Post by: navissar on 11 Dec 2013 06:49:04 AM
Hi,
Any SP ran from Cognos is expected to return something. If an SP only updates data, Cognos will throw an error because it expects a result set.
This can be easily bypassed by adding a bogus select statement at the end of the SP. However, you (Or someone with access) has to check and if needs be change the SP. This cannot be done from Cognos.
Title: Re: Error when executing stored procedure in FM
Post by: yogeswari on 11 Dec 2013 07:41:41 AM
Hi,,

thanks for your response.
Will get back to you, if anything else is required.


thanks,
yogeswari.
Text only | Text with Images