1 Reply Latest reply on Apr 23, 2019 8:55 PM by Christian Berg

    [nQSError: 17010] SQL statement preparation failed

    819624

      OBIEE ver. 12.2.1.2

       

      Need help on this .. the report always failing with this error :

       

      OBIEE Analytics show this:

      Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

      Odbc driver returned an error (SQLExecDirectW).

       

       

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

       

       

      State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

       

       

      State: HY000. Code: 43093. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. (HY000)

       

       

      State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 1012, message: ORA-01012: not logged on Process ID: 189282 Session ID: 2021 Serial number: 72773 at OCI call OCIStmtExecute. (HY000)

       

       

      State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation failed. (HY000)

       

       

      SQL Issued: BIG QUERY GOES HERE

       

       

       

       

      When Checked the obis1 logs ..

      [OBIS] [ERROR:1] [] [] [ecid: c8ff28b8-ec38-46c1-8f4b-9ec9f4073e49-0028894a7,0:1:26:1] [sik: ssi] [tid: e20ad700]  [nQSError: 17010] SQL statement preparation failed. [[

      file: server/Query/Execution/DbGateway/Oci10g/../Oci8/Src/SQXDGOci8.cpp; line: 411

      Properties: description=ExecutePhysical Exchange; producerID=0xe00142d8; requestID=0x27f90006; sessionID=0x27f90000; userName=weblogic;

      [nQSError: 17001] Oracle Error code: 1012, message: ORA-01012: not logged on

      Process ID: 185112

      Session ID: 2021 Serial number: 56209

      at OCI call OCIStmtExecute.

       

       

      **********  Task: 1. Running for (mls):  **********

      Description: At OCI call OCIStmtExecute

      Oci8Status:OCI_ERROR

      RequestID:27f90006

      SQL Query:select distinct

      BIG QUERY GOES HERE

      ...

       

      Task: 2. Running for (mls): 54 **********

      Description: ExecutePhysical GatewayDbGateway Prepare

      DSN: ABC Connection Pool

      User Name:obie

      SQL:select distinct

      BIG QUERY GOES HERE

       

      **********  Task: 3. Running for (mls): 54 **********

      Description: Producer Executing Query

      Repository Name:ssi;Subject Area Name:;User Name:weblogic

      Logical Hash of SQL: 0xf6e49123SQL:{call NQSGetQueryColumnInfo('EXECUTE PHYSICAL  CONNECTION POOL "ABC Connection Pool " select distinct

      BIG QUERY GOES HERE

       

       

      Any help will be appreciated.

       

      Regards