oracle 11 client and doa 4.1 external exception

[commander]

hello there,

i use delphi 2007 and doa 4.1
when my project runs under oracle 11 client it crashes
all doa concerning executes after a while with external exceptions.
under oracle 10.2 client everything is fine.

i tested it on windows xp and vista machine as client,
where server side is either a win2003 or suse-linux
oracle 11 server.

is there a workaround ? or when can i expect a new doa
version that works with ora 11 client ?

delphi project uses no complicated operations.
just about 5 oraclequeries and 1 oracle event,
no threads, 1 oracle session.
optimize propery set to false, because this causes
errors on all clients.

best regards,
claus

 

[Marco Kalter]

Direct Oracle Access 4.0.x and 4.1.x works just fine with the 11g client. What exactly is the error message of the exception?

 

[commander]

query execute exception block
just gives "External exception EBF00BAA" in the message.

exception block looks like this:
try
oq.execute;
on e : exception do
flog('...'+e.message);
end;

there is also an application.onexception
handler which is not triggered !

here are some oracleci parms:

ORACLE HOME c:\ora\product\11.1.0\db_1
ORACLE HOME KEY SOFTWARE\ORACLE\KEY_ora1110
ORACLE HOME DIR
ORACLE HOME NAME ora1110
ORACLE HOME LIST ora10201client
ora1110
ORACLE BIN DIR TRUE
ORACLE OCI DLL c:\ora\product\11.1.0\db_1\bin\oci.dll
ORACLE OCI VERSION version 9.2

when i force it to use ora10201client everything is fine:

if you need more information let me know.

greetings,
claus

 

[commander]

the forum clock might be wrong !
this post is feb 2nd,2009, 08:41 met

 

[Marco Kalter]

just gives "External exception EBF00BAA" in the message.

There is not much we can do with that. Can you try it on a different PC?

the forum clock might be wrong !
this post is feb 2nd,2009, 08:41 met

That is how it is displayed for me. Maybe you need to set the time offset through "My stuff" > "Preferences"?

 

[commander]

i tried it on 3 different pc already:
windows xp sp3, windows vista, windows server 2003

its absolute reproducable that the use of the ora 11
client makes the error, but the time from the start
of the app up to the exception can be a few seconds
or about 1 hour.
i suspect that it occurs when there are heavy execs
on the database.

well i hope you keep on finding a solution for this !

please help !
claus

p.s.: my local clock is GMT+1 but my firefox shows the past timestamp

 

[commander]

would be nice if i could get an answer.
i you dont know what it is you can say it.
but giving no answer at all is disappointing.

 

[Marco Kalter]

Sorry, we have no real clues. You can send me a demo application, including scripts to create database objects, so that I can see if it is reproducible.

 

[NDzubiel]

I have the same problem here with Oracle 11GR1. It just
"started" - and I don't know why ...

I am running the follwing query:

select * from nhdcs.gatesystemeventqueue
where
mandant = :mandant and
trunc(EVENTTIME,'DDD') = :buchungsdatum and
cardnumber = :transponderid
order by EVENTTIME,GateEvent

The Table structure is as follows:

create table GateSystemEventQueue (
Mandant Number (9) not null,
ObjectID Number (9),
UserID Number (9),
GroupID Number (9),
AccessRightID Number (9),
GateSystemEventSEQ number (9) not null,
GateSystemID varchar (30) not null,
Cardnumber varchar (255),
GateEvent number (9) not null,
EventTime Date,
DeviceID varchar (30),
GateSEQ varchar (30),
DateCreated Date,
DateProcessed Date,
Processed number (9),
AES32Reference number(9),
Description varchar (80),
Active number (9) default 1 not null,
Forwarded Date
);
grant all on GateSystemEventQueue to public;
create unique index GateSystemEventQueueIndex1 on GateSystemEventQueue (Mandant,GateSystemEventSEQ);
create index GateSystemEventQueueIndex2 on GateSystemEventQueue (Mandant,DateProcessed);
create index GateSystemEventQueueIndex3 on GateSystemEventQueue (Mandant,Cardnumber,round(EventTime,'DDD'));
commit;

After running the query for a while you get the exception .... there
are about 3500 records in the database

Nils

 

[NDzubiel]

Okay,

I did some further investigation ... it's the TOracleEvent
what is causing the problem ... when I removed it from
my project everything worked again.

Nils

 

[ldsandon]

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.

 

[desireless]

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?

 

[Ami]

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;

 

[Ben Park]

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