2 Replies Latest reply: Apr 27, 2012 12:18 AM by Raghu Nagadasari RSS


      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
          under database features
          • 2. Re: HI
            Raghu Nagadasari

            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.