Print Page - Error in FM while importing store procedure

Title: Error in FM while importing store procedure
Post by: johny.cbi on 15 Dec 2011 10:21:04 AM

Hi,

Environment:
Cognos 8
Teradata
I tried to import the store procedure into Framework Manager and got the Below Error Message

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "sqlPrepareWithOptions".

store procedure syntax : Test_p():

Thanks
JP

Title: Re: Error in FM while importing store procedure
Post by: tjohnson3050 on 28 Dec 2011 03:32:19 PM

It looks like the result set returned by the stored procedure may have changed. Try updating the query subject in framework manager and republishing the package.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: johny.cbi on 15 Dec 2011 10:21:04 AM