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.
most probably you are using layout expression, try using singleton
Thanks for the reply but I am not using any layout expressions.
Does this error refer to something in the report of framework/database?
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..