View Tabular Data

[rr.bi1212]

I am trying to run a query using view Tabular Data and I Get the below error.

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

I have got couple of 1:n or o:n joins in my framework...Is it causing that error? or Do I have to do anything else in general?

[hespora]

Hey,


I'd suggest checking detail filters in your query *meticulously*, see if any of the objects compared can be, or are null. A filter checking for "NULL = value" does not return true or false, but returns null instead, which is one of the common causes for this error.

[rr.bi1212]

So how Should I resolve it?

[hespora]

You can use

Code Select Expand

coalesce([data item], ValueInsteadOfNull) = value
in your filters instead of just [data item] = value. However, like I said, you need to review your joins if any data items used in filters *can* be null, and if that is correct.

[dougp]

That error can indicate a problem with a data item, a filter, a join, or some problem in the model.  Including the entire error message here may help others help you.