If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Error in FM while importing store procedure

Started by johny.cbi, 15 Dec 2011 10:21:04 AM

Previous topic - Next topic

johny.cbi

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

tjohnson3050

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.