3 Replies Latest reply: Jun 4, 2013 11:40 PM by Bukhbayar RSS

    Oracle Analytic error - OLAP

    Bukhbayar
      i have problem here, this is olaptrain sample code, I was installed without any error and import Administration tool then see persentation layer get that error
      how to resolve it? what is the problem??

      it didnt change anything, its OLAPTRAIN

      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: S1000 code: 10058 message: [NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near <WITH>: Syntax error [nQSError: 26012] .. [nQSError: 16014] SQL statement preparation failed. (HY000)
      SQL Issued: SELECT 0 s_0, "OLAPTRAIN"."Channel"."All Channels" s_1 FROM "OLAPTRAIN" FETCH FIRST 65001 ROWS ONLY

      Edited by: user11957406 on Jul 31, 2012 12:11 AM