RQP-DEF-0177 'sqlPrepareWithOptions' status='-9'

[bobj]

Hi Friends,

I receive the following error when I run tabular data for a Union query in Cognos 8.3 on Oracle:

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

Because it is a union join I naturally checked the data items in the queries which are exactly the same in terms of names and datatypes so there is no problem there.

I can run each query separately and returns data correctly.
The Union is referencing 2 queries which have been created by using outerjoins which also work fine.

The other issue is when I place the data items from the union into a crosstab and validate the report I receive errors:

RSV-VAL-0044 The member caption can only be used in the scope of crosstab or chart.
QE-DEF-0459 CCLException
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "sqlPrepareWithOptions".

When I remove the crosstab the report validates without any errors.

Can anybody help please?

Thanks.

[uttam.mistry]

most probably you are using layout expression, try using singleton

[bobj]

Thanks for the reply but I am not using any layout expressions.
Does this error refer to something in the report of framework/database?

[blom0344]

Nope, it has to do with the aggregate setting of the measure in the crosstab. Even if it is a real aggregate in the individual queries, you still need to make sure it has an aggregate defined (like minimum) to be able to get a crosstab to work..