OCISessionBegin hangs

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
zedmartins
Posts: 18
Joined: Wed 11 Jul 2007 20:59
Location: Brazil

OCISessionBegin hangs

Post by zedmartins » Tue 24 Sep 2013 20:12

Hello there!

We have here a application that uses ODAC components inside COM+ dlls to connect to Oracle Server 11g.

Lately we are facing a problem that we cannot find the solution.

For some reason, when the concurrency of the application server at some of our clients is too high, some dlls starts to hang and they have to kill the process to restore the usability of our product. Trying to reproduce the error here at our office, we created a test environment to stress an application server. We start 30-50 programs that make calls to application and after some time the problem appears.

Debugging our DLL after the server hangs, shows that any subsequent call to OCISessionBegin cannot complete. No error is generated. No other symptoms are visible.

The last line that the we try to execute is: Check(OCISessionBegin(...)); on OraClasses.pas

We checked the database no contention, no lock.

We are using ODAC 6 on our clients, but we upgraded it to the last version and the problem persists. We have to use the Oracle Client 10 to connect to the database 11g because the are using the version 6 of ODAC.

Can anyone help us?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: OCISessionBegin hangs

Post by AlexP » Wed 25 Sep 2013 09:13

Hello,

Please send your project demonstrating the problem to alexp*devart*com in order for us to be able to reproduce the problem and detect the reason for such behaviour.

zedmartins
Posts: 18
Joined: Wed 11 Jul 2007 20:59
Location: Brazil

Re: OCISessionBegin hangs

Post by zedmartins » Mon 11 Nov 2013 21:19

Alex, did you get my email? I sent it to alexp (at) devart*com...

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: OCISessionBegin hangs

Post by AlexP » Tue 12 Nov 2013 07:46

Hello,

I have received your letter, and will inform you as soon as we get any results.

zedmartins
Posts: 18
Joined: Wed 11 Jul 2007 20:59
Location: Brazil

Re: OCISessionBegin hangs

Post by zedmartins » Thu 14 Nov 2013 19:20

thanks

zedmartins
Posts: 18
Joined: Wed 11 Jul 2007 20:59
Location: Brazil

Re: OCISessionBegin hangs

Post by zedmartins » Mon 25 Nov 2013 20:45

Alex,

Did you have the time to check my message? Did you find any problem installing or debugging the source?

Thanks again and sorry for the pressure...

Post Reply