This discussion is archived
2 Replies Latest reply: Jan 29, 2013 11:59 AM by 987892 RSS

Errors in Analytics Dashboards (Peoplesoft and SQL Server)

987892 Newbie
Currently Being Moderated
Hi All,
We are facing a problem implementing BI APPs 7.9.6.3 for Peoplesoft Fin 9.1 (and using MS SQL Server 2008).

We loaded the Warehouse without problems but when We try to see the reports in FIN and Procurement & Spend Dashboards we get the following errors in several reports:

####################################

Error
     View Display Error
     
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
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)
##################################

Any help will be appreciated.
Thanks a lot

Edited by: user752285 on 29/01/2013 11:00

Edited by: user752285 on 29/01/2013 11:40

Legend

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