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 |