Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: ajrocks on 22 Aug 2007 08:33:10 PM

Title: Error when Improting SP in FM
Post by: ajrocks on 22 Aug 2007 08:33:10 PM
I imported Stored Procedure as Query subject. It has three parameters, when I test it by providing input value for one of the parameter it runs fine. But when I change the INput value it throws an error.
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
UDA-SQL-0283 Metadata describing "usp_UnitReinvestmentSummary" does not match results from the database.
If I close the FM manager and open it again and provide the second input value it runs fine but the first input value does not work and throws the same error. ANy help would be greatly appreicated.
Thanks in Advance
Title: Re: Error when Improting SP in FM
Post by: hemudwh on 03 Sep 2007 01:13:11 AM
Which Database are u passing Values. ?
Title: Re: Error when Improting SP in FM
Post by: ajrocks on 10 Sep 2007 07:24:03 PM
Hi the Database is SQL Server
Text only | Text with Images