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

    Reg: Report Error!

    user12021881

      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.


      Thanks,

      Ajay.