Obiee General Problem

Question

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

dilek · Answer

Thank you. I think it solved our problem. We did not receive any such error.

Regards.

Joel Acha · Answer

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.

dilek · Answer

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