Skip to Content
author's profile photo Former Member
Former Member

ORA-00936: missing expression

Hi there,

i created a very simple query, which contains a hierarchy. the query is based on a DSO.

i just made a few changes in the DSO. refilled master data and text data of the hierarchy base infoobject.

now i get an error message when i try to open the query:

ORA-00936: missing expression

then the bex analyzer cancels the connection to the BI.

when i take out the hierarchy from the query, it works. it put it back in, the same error occurs again.


btw, i am using bi 7.0 and the old bex analyzer.

thanks a lot for ideas in advance!:)


Message was edited by:

Stefan Voltz

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 03:08 PM

    ok now it works again, for whatever reason...

    all i did was click through the base infoObject and its hierarchy to see whether i can reactivate anything.

    i didnt really do anything.

    i'm sure the problem will occur again at some point. so dont hesitate if you have an idea.



    i'll reward points;)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.