My Oracle Support Banner

OBIEE 12c : Reports Error Out [nQSError: 17001] Oracle Error code: 1012, message: ORA-01012: not logged on (Doc ID 2666492.1)

Last updated on MAY 12, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.0 to 12.2.1.4.191015 [Release 12g]
Information in this document applies to any platform.

Symptoms

Due to some restrictions or requirements at database side, you would need to kill sessions of the users that query from specific tables and when they do so, it is affecting other users creating new reports.

It gives below errors:

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

 

obis1-diagnostic.log

 [OBIS] [ERROR:1] [] [] [ecid: ecid:1] [sik: ssi] [tid: b17fc700]
[nQSError: 17010] SQL statement preparation failed. [[
file: server/Query/Execution/DbGateway/Oci10g/../Oci8/Src/SQXDGOci8.cpp;line: 489
Properties: description=<<24514431>> DbGateway Exchange: DIR_Physical.DIR
Connection Pool; producerID=0xf5a7b8b0; requestID=0x14b70002;
sessionID=0x14b70000; userName=xxxx;
[nQSError: 17001] Oracle Error code: 1012, message: ORA-01012: not logged on
Process ID: 78648
Session ID: 592 Serial number: 17723
at OCI call OCIStmtExecute. 

 

Changes

 Upgraded to OBIEE 12c

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.