Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

[nQSError: 17010] SQL statement preparation failed

Received Response
2155
Views
1
Comments
User_4NU9S
User_4NU9S Rank 6 - Analytics Lead
edited Aug 13, 2024 5:26PM in Oracle Analytics Cloud and Server

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

Answers