error @ report running

[jagan.dish]

Hi gurus,
                 could you help me out here when i run the report after populating the dataitems to the report page when i run the report i get the following errors....
An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'
An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.

Thanks

[MFGF]

Hi,

Do you have System Admin privileges for the Cognos instance? If so, go into the properties of the data source connection pointing to your data source (in the Admin console) and check the isolation level defined for the connection. My (wild) guess is that it's set too low - perhaps to "Read Uncommitted" when your database doesn't support this level?

MF.

[MMcBride]

Look at your data items as well, I knew these errors looked a little familiar

So I took a report that worked perfectly fine and "Broke" it by putting in code I knew would not work.
When I run the report I get the following

An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.

In my case I took a relational report and used a Multidimensional function - one with a ! in front of it, Obviously you cannot use an MDX function in a SQL Based report. When you run a "Validate Report" on your report does it return without errors?

[jagan.dish]

Hi MFGF & MMcBridge....thanks for the help it worked finally

[MFGF]

What was causing the issue in the end? It might help others facing the same issue to know what fixed it :)

Cheers!

MF.

[jagan.dish]

Hi MFGF,
               The cause was that I imported the cognos 8.4 version samples instead of cognos 10.1 version which I was using  currently.

Thanks,
Jag

[MFGF]

Thanks for the update! Glad you found the solution :)

MF.