Print Thread
Page 2 of 2 1 2
Re: oracle 11 client and doa 4.1 external exception
NDzubiel #39224 12/22/10 08:42 PM
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
L
Member
Offline
Member
L
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
I've encoutered this problem also today. An application with 8 threads each with its own session faulted everytime I launched it (after a few minutes) with "External exception EBF00BAA", I've tried to obtain a stack trace with little luck. It took time to trace it to the OCI client. Tested with 11.1.0.7 (no patch applied), Windows 7x64 and 2008R2x64. Using 10.2.0.5 it worked. With other three applications which are not multithread there are no issues. I'll try the workaround suggested here: http://www.allroundautomations.com/threads/ubbthreads.php?ubb=showflat&Number=37307#Post37307, because there is no trace of such a issue on Google, I wonder if this is DOA specific for some reason.
I'm going to test 11.2 tomorrow, and applying the latest patch.


LDS
Re: oracle 11 client and doa 4.1 external exception
ldsandon #42913 12/09/11 10:56 AM
Joined: Dec 2011
Posts: 1
D
Member
Offline
Member
D
Joined: Dec 2011
Posts: 1
I have a similar application with 11 thread running, each with its own connection and get the same error on Oracle 11.2.0.1.0, DOA 4.1 for XE2. It is always the same thread that exports alot of data to a CSV file and I can't even catch it in a try..except block. So the whole application stops.

Did anyone solve this problem?

Last edited by desireless; 12/09/11 10:56 AM.
Re: oracle 11 client and doa 4.1 external exception
desireless #43367 02/16/12 07:01 AM
Joined: Feb 2012
Posts: 1
Ami Offline
Member
Offline
Member
Joined: Feb 2012
Posts: 1
Here is the way I resolved this problem (Thanks to Ben!):
As you can read, the exeption only appears in multi-threaded app's.
So, you must turn on the ThreadSafe bit of DOA!

FSession:= TOracleSession.Create(nil);
with FSession do
begin
LogonDatabase:= DB;
LogonUsername:= UID;
LogonPassword:= PWD;
ThreadSafe:= true; end;

Re: oracle 11 client and doa 4.1 external exception
Ami #44395 08/14/12 02:44 AM
Joined: Aug 2012
Posts: 1
B
Member
Offline
Member
B
Joined: Aug 2012
Posts: 1
I have had the same problem for weeks now, no clue whatsoever. My application shows an "External exception EBF00BAA" and just stops processing any queries that follows.. if I switch it to a single-threaded mode, it works totally fine.

I hope turning on the ThreadSafe flag helps. Thanks to all.


-Ben Park

Page 2 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.044s Queries: 16 (0.017s) Memory: 2.5310 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-05-07 21:14:10 UTC
Valid HTML 5 and Valid CSS