1 Reply Latest reply on Mar 12, 2013 9:20 AM by Christian Berg

    obiee error

    996223
      hi ,
      i am new to obiee reporting. i am getting below error.
      could please tell what exactly this error means.


      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: 43119] Query Failed: [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 17001] Oracle Error code: 1858, message: ORA-01858: a non-numeric character was found where a numeric was expected at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
      SQL Issued: EXECUTE PHYSICAL CONNECTION POOL "ConnectionPool10" SELECT info, Amt from table(pipeline.get_num_row( '@{misdate}','@{execution}','@{scenario}','@{entity}','@{Consolidation}','@{GLtype}'))