Print Page - [solved] How to find an error?

Title: [solved] How to find an error?
Post by: VisioX on 05 Jan 2010 02:34:41 PM

Hi there,

i get an RQP-DEF-0177, An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'.

Not sure where to start finding the error.
I copied the report into the clipboard and from there into an text editor... but it has a total of over 11200 lines...

Any help would be appreciated.

Thanks

Title: Re: How to find an error?
Post by: actcognosuser on 05 Jan 2010 02:44:33 PM

Try to validate the report .if you have multiple queries check if you are able to generate sql
for those queries.

Title: Re: How to find an error?
Post by: VisioX on 05 Jan 2010 03:02:13 PM

This reports is a 64 page report... about 250 single queries...

Anyway, i found the problem... cognos had i hickup.
I deleted the filter, saved the report, ran the report, added the filter again and now it works !?!?!?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: VisioX on 05 Jan 2010 02:34:41 PM