Page 1 of 1

OCISessionBegin hangs

Posted: Tue 24 Sep 2013 20:12
by zedmartins
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?

Re: OCISessionBegin hangs

Posted: Wed 25 Sep 2013 09:13
by AlexP
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.

Re: OCISessionBegin hangs

Posted: Mon 11 Nov 2013 21:19
by zedmartins
Alex, did you get my email? I sent it to alexp (at) devart*com...

Re: OCISessionBegin hangs

Posted: Tue 12 Nov 2013 07:46
by AlexP
Hello,

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

Re: OCISessionBegin hangs

Posted: Thu 14 Nov 2013 19:20
by zedmartins
thanks

Re: OCISessionBegin hangs

Posted: Mon 25 Nov 2013 20:45
by zedmartins
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...