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?
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.
So how Should I resolve it?
You can use
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.
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.