Dashboard is not visible after deploying OBIA apps rpd OBIEE Versiion 220.127.116.11.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)
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.