This discussion is archived
2 Replies Latest reply: Apr 26, 2012 10:18 PM by Raghu Nagadasari RSS


user13081091 Newbie
Currently Being Moderated
Hi ,

Dashboard is not visible after deploying OBIA apps rpd OBIEE Versiion help please. Please see th below error message for reference its on SQL SERVER

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 16001] ODBC error state: 37000 code: 8180 message: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.. [nQSError: 16001] ODBC error state: 37000 code: 1033 message: [Microsoft][ODBC SQL Server Driver][SQL Server]The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.. [nQSError: 16002] Cannot obtain number of columns for the query result. (HY000)

Thanks in advance

Edited by: user13081091 on Apr 12, 2012 11:49 AM
  • 1. Re: HI
    user13081091 Newbie
    Currently Being Moderated
    under database features
  • 2. Re: HI
    Raghu Nagadasari Newbie
    Currently Being Moderated

    Yes. that was working when i have been following the below.

    1. Untick the checkbox for EXPRESSIONS_IN_ORDERBY_SUPPORTED in the features tab of the database properties in the physical layer.
    2. For a single report, go to the advanced tab and select the ‘Issue an explicit distinct’ checkbox.

    The 1st was enough to resolve ur isuue i think.
    Actually i got the same issue n now it was resolved.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points