database error occured.The database error text is: ORA-0092

building semantic layer
1

HI All,

I just added some tables in the existing universe and created one class and some objects based on the newly added tables as per the requirements.

When i run the query it gives me the following error:

A database error occured.The database error text is: ORA-00920: invalid relational operator.(WIS 10901).

If i run the query using only the newly created tables it doesn’t give the error.

The newly created objects are simple select statments and there in no metion of IN operators in the query.

Can you pls advise what went wrong?

Thanks in Advance

ernestobo (BOB member since 2010-07-12)

2

I’ll bet you have a poorly constructed join.

When you get the error in the report, check out the generated SQL in the query. If you don’t see the problem right away, post the SQL here.

Joe

joepeters :us: (BOB member since 2002-08-29)