"Error message ORA -03113- end of file communication ch

general discussion
1

hi all,

We are getting the below error when refreshing one of the reports
“Error message ORA -03113- end of file communication channel”.

This report runs and completes execution in 1 hour, but in Business Objects it give the above error and hangs.

can anyone give any suggestions on this ?

regards

kapil

kmighlani (BOB member since 2002-08-29)

2

Yes, are there problems with the database? Typically you see this if the database is experiencing a problem. You would have the same problem if you pasted the SQL into TOAD or SQL*PLUS. Ask your DBA if there is a problem.

This is the Oracle Action:

If this message occurs during a connection attempt, check the setup files for the appropriate SQLNet driver and confirm SQLNet software is correctly installed on the server. If the message occurs after a connection is well established and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an ORACLE internal error that requires the assistance of Worldwide Customer Support.

But before you worry too much just speak to a DBA.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

hi nick,

thanks for your response.

what we have done is copy the SQL generated in to SQL plus and it runs fine in it. I am totally confused with this error, as only this error comes only while running this query from Business Objects.

Any suggestions ?

Thanks & Regards

Kapil

kmighlani (BOB member since 2002-08-29)

4

I was hoping this wouldn’t happen to you. Yes I have seen this before. A colleague had the problem intermitently on a particular oracle database. We never traced the cause before it just stopped. She said that if she closed BO and opened it again this sometimes solved the problem - and sometimes it didn’t…

Nick Daniels :uk: (BOB member since 2002-08-15)

5

what kind of bomain.key did you generate? are you set up to disconnect after each transaction, or is it ‘waiting’ - maybe it timed out? This may be shown in the listener.log file, on the Oracle box.

I had a similar issue on a laptop, but that turned out to be that the docking station and the laptop both had nics, both were ‘active’ - SQL*Net got confused by that (test by running w/out the docking station).

i’d look at the server side listener log - may see messages there. also, look in the bdump / udump folders (again, the oracle box) - you may be generating an exception error there.

3113’s are tough to debug, get your dba involved - you may also have to work with your network folk - this can be generated by corrupted sql*net packets…

good luck (also, do some searching on oracle forums, this error is a common / frustrating one, lots of discussion out there).

Brent

bdouglas :switzerland: (BOB member since 2002-08-29)

6

I’ve seen this happen numerous times, with several causes. If the database goes down while you are running the query, you will get this message. I’ve also had it happen when the network got overloaded, and the flow of data just got cut off. Try running the query during offpeak hours. That may help.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

7

When you run the query in SQL Plus are you running it on the same P.C. as when you run it in Business Objects?

I had a similar problem once, and it was due to my P.C. being outside of a firewall, and the firewall had a 30 minute timeout setting.

anorak :uk: (BOB member since 2002-09-13)

8

hi,

i have been running the query in SQL plus on the same PC where i had executed query in BO.

regards

kmighlani (BOB member since 2002-08-29)

9

hi

what should be the settings ? Disconnect after every transaction ? i have keep the connection active during the whole session

Regards

Kapil

kmighlani (BOB member since 2002-08-29)

10

I always have my setting set to Disconnect after each transaction. It wouldn’t be causing the problem.

The fact that your query takes an hour to run appears to the be the problem.

You reallly need to examine the firewall issues and other things in order to tsolve this.

Steve Krandel :us: (BOB member since 2002-06-25)

11

In Oracle (I believe 8.1.6) there is a bug concerning a parameter Star Join = True. This may not be the exact definition, but this was causing me to have this error randomly. Check with your DBA and have this set to False. We experienced this problem with a report. In our test environment it worked fine (star join = False) in our production environment it failed randomly (star join = True).

Hope this helps…

brad_yearwood :us: (BOB member since 2002-12-03)

12

got this error message last week, sent it to DBA, and he replied “that is is a known bug in Oracle” and would find a work around. He sent me some modified code in which he coverted my numeric values to char and then back to number. Not sure why this works, but this was the work-around until a patch or something can be implemented.

jswoboda :us: (BOB member since 2002-06-20)

13

I am getting same kind of error. Database is Oracle 9i with BOXI R2. Its a migrated report from 6.5. What you think is it bug in Database or some thing wrong in BO.

Thanks in advance,

BOpat :us: (BOB member since 2006-11-09)

14

We are getting this error with few LOV in prompt. With few prompts report running perfect. But with few its not…And showing error.

Any idea!!

Thanks!!

BOpat :us: (BOB member since 2006-11-09)