Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Obiee General Problem
Hi,
Yesterday, we restart the obiee server machine. After restart, for some obiee queries following error occurred. But not all the times, some times. Also, not always the same query. It changes time to time :S
Error details;
[nQSError: 17010] SQL statement preparation failed.
[nQSError: 17001] Oracle Error code: 3113, message: ORA-03113: end-of-file on communication channel
Process ID: 70854
Session ID: 2719 Serial number: 44412
at OCI call OCIStmtExecute.[nQSError: 170
What can be the cause of this problem. Do you have any idea?
Regards,
Dilek
Answers
-
-
Hi,
Thank you for the response. I looked the document, but sqlnet.ora file settings is already like that. (with ON option)
Any other suggestion please.
Regards,
Dilek
0 -
posted the wrong URL above - should have been:
Oracle Support Document 2473789.1 (OBIEE 12c: Reports Failed With Error ORA-03113 Intermittently) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2473789.1 instead of https://community.oracle.com/message/15021434?et=watches.email.thread#15021434
If disabling Out of Band Breaks doesn't work, this is another option to try.
0 -
Thank you. I think it solved our problem. We did not receive any such error.
Regards.
0
