Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
[nQSError: 17010] SQL statement preparation failed

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).
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
-
ORA-01012
^--- That's a database error. Talk to your DBAs
0