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 |