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

Drill through error

Started by Sarayucog, 14 Mar 2011 01:53:41 AM

Previous topic - Next topic

Sarayucog

Hi all,

I have  a report. In that I have drill through on one item called Product type. When I am clicking on drill throgh link its giving the below error.

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

In my child report I have 10 columns and a filter. This filter is provided in the drill through pane of Main report.

Plesase help on this issue. Is this issue related to database or someother thing.


Thanks in advance.


peter.almstrom


Sarayucog

I have searched in google, but nothing I found related to this exact error.

NimrodA

Yep, that's kind of a generic error. When a drill through causes havoc, I usually do the following:
1. Run target report - does it run on its own? Try giving it, as parameter, a value which it would normally get from the drill-through (Like a product type name). If it fails, something is wrong with the prompt definition.
2. Does drill through fail for all rows, or just some? If for all, and section 1 checks out OK, that probably means drill through settings are off.
3. Try removing the parameter from the drill-through settings (Drill through without passing any parameters). Does it work? If so, your parameter definition was wrong.
Try it out, see if you can find anything, let us know!

Joe Gilvary

The error occurs before running the query(ies) for the target report, in the "sqlPrepare" so look to the parameters that you are passing in.

There is another mention here on cognoise of that same error message ( http://www.cognoise.com/cognoisearchive3000.htm ) and a recent blog entry http://arulsteg.blogspot.com/. The general theme of these suggestions seems to be confusion about datatypes, perhaps a type mismatch in a calculation.

HTH,

Joe

Sarayucog

Thankyou Nimrod.

I did as you said. I got know where is the problem. Actually I have the problem in my child report only.