0 Replies Latest reply: Jun 13, 2013 10:37 PM by user12021881 RSS

    Reg: Report Error!


      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


      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: 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.