My Oracle Support Banner

Analysis and Dashboards Error Out [nQSError: 17001] Oracle Error code: 1012, message: ORA-01012: not logged on (Doc ID 2666492.1)

Last updated on MAY 09, 2021

Applies to:

Oracle Analytics Server - Version 5.5.0 to 5.5.0.0.201216 [Release 5]
Business Intelligence Server Enterprise Edition - Version 12.2.1.0.0 to 12.2.1.4.200414 [Release 12g]
Information in this document applies to any platform.

Symptoms

Due to some restrictions or requirements on the 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 the 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 or OAS

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.