Purchase your Section 508 Compliance Support guide now!

Purchase your Section 508 Compliance Support guide now!

Cognos 8 -- Framework Manager executing SPROCS

Hello, if you're using SQL Server stored procedures (SPROCS) in your Cognos 8 Framework Manager model as the source for your model's query subjects, then you should make sure that you have a valid user signon defined in Cognos Connection that has the proper permissions to execute the SPROC.

If not, then you may a recieve an error similar to the following:

RQP-DEF-0177 An error occurred while performing operation 'sqlExecute'