13 Replies Latest reply on May 8, 2019 12:54 PM by Anirban1

end of file communication error

Anirban1 May 7, 2019 8:44 AM

Hi,

We are getting ora-03113 end of file communication channel process id error in one of the dashboard which contain 3,4 reports. All the reports giving the same error. If I restart the services it is coming fine, but after some time again we are getting same errir. Can you please suggest what might be the problem and how can we fix this. We are using OBIEE 12c.

Thanks

Anirban

1. Re: end of file communication error

Joel Acha May 7, 2019 10:18 AM (in response to Anirban1)

Take a look at this thread - Obiee General Problem
Like Show 0 Likes(0)

Actions
2. Re: end of file communication error

Anirban1 May 7, 2019 3:37 PM (in response to Joel Acha)

Hi Joel,

Thanks for your reply. This solved my problem. I will monitor this for couple of days and will update you.
Thanks once again for your help.

Thanks
Anirban
Like Show 0 Likes(0)

Actions
3. Re: end of file communication error

Joel Acha May 7, 2019 5:28 PM (in response to Anirban1)

No problem. Happy to help.
Like Show 0 Likes(0)

Actions
4. Re: end of file communication error

Anirban1 May 8, 2019 8:59 AM (in response to Anirban1)

Hi Joel,

We are still facing the same issue again, we have implemented the same mention in the link and bounce OBIEE. Can you please suggest.

Thanks
Anirban
Like Show 0 Likes(0)

Actions
5. Re: end of file communication error

Joel Acha May 8, 2019 9:02 AM (in response to Anirban1)

Did you Disable Out Of Band Breaks (OOB)?
Like Show 0 Likes(0)

Actions
6. Re: end of file communication error

Christian Berg May 8, 2019 9:05 AM (in response to Joel Acha)

The fastest s/gun/support entry finder in the west :-)
Like Show 0 Likes(0)

Actions
7. Re: end of file communication error

Joel Acha May 8, 2019 9:18 AM (in response to Christian Berg)
Like Show 0 Likes(0)

Actions
8. Re: end of file communication error

Anirban1 May 8, 2019 10:10 AM (in response to Anirban1)

Hi Christian,

Correct .

@Joel

DISABLE_OOB=ON
SQLNET.SEND_TIMEOUT=900
SQLNET.RECV_TIMEOUT=900

This is the entry currently in sqlnet.ora file.

Do I need to change anything in this.

Thanks
Anirban
Like Show 0 Likes(0)

Actions
9. Re: end of file communication error

Christian Berg May 8, 2019 10:19 AM (in response to Anirban1)

Normally that is the solution, yes.
Like Show 0 Likes(0)

Actions
10. Re: end of file communication error

Anirban1 May 8, 2019 10:26 AM (in response to Christian Berg)

Thanks Christian,

It is already in place, I have restart OBIEE services, then cleared cache from my browser, in some of the reports I am getting error, but while trying using inprivate browsing it is perfectly working fine.
Assuming it is the problem with cache for local browser, is it right?

Thanks
Anirban
Like Show 0 Likes(0)

Actions
11. Re: end of file communication error

Joel Acha May 8, 2019 11:04 AM (in response to Anirban1)

Very possible that it is browser cache. Always best to close down all browser tabs/windows to ensure that browser cache is cleared.
Like Show 0 Likes(0)

Actions
12. Re: end of file communication error

Christian Berg May 8, 2019 11:34 AM (in response to Anirban1)

Be careful not to keep the option checked to keep files for bookmarked sites
Like Show 0 Likes(0)

Actions
13. Re: end of file communication error

Anirban1 May 8, 2019 12:54 PM (in response to Christian Berg)

Thanks Christian and Joel, I will keep an eye on this and will update you on this.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.