This discussion is archived
0 Replies Latest reply: Jun 13, 2013 3:28 PM by user12021881 RSS

Reg: Report Error!

user12021881 Newbie
Currently Being Moderated

Hello everyone,




Can I please get some help with the following scenario.


When i run the report in OBIEE 11g, I get the following error.




https://corpdpsobi01v:9804/analyticsRes/sk_PacificLife/common/msgerror.gif Error
View Display Error

Odbc driver returned an error (SQLExecDirectW).

https://corpdpsobi01v:9804/analyticsRes/sk_PacificLife/common/errorminus.gif  Error Details





State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 16001] ODBC error state: S1000 code: 0 message: [Microsoft][ODBC SQL Server Driver]Unspecified error occurred on SQL Server. Connection may have been terminated by the server.. [nQSError: 16001] ODBC error state: 01003 code: 8153 message: [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.. [nQSError: 16015] SQL statement execution failed. (HY000)



Can someone help me with this.







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