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

HI

user13081091 Newbie
Currently Being Moderated
Hi ,

Dashboard is not visible after deploying OBIA apps rpd OBIEE Versiion 11.1.1.6.0 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
    Uncheck the EXPRESSION_IN_ORDERBY_SUPPORTED
    under database features
  • 2. Re: HI
    Raghu Nagadasari Newbie
    Currently Being Moderated
    Hi,

    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.


    Thanks,
    Raghava

Legend

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