Devart Forums

Hi,

I am working with TOrAlerter with EventType := etAlert and it works fine. But if I stop the database or disconnect the LAN connection the application hangs between the events ORASession.BeforeDisconnect and ORASession.AfterDisconnect.

Without activating the alerter it works well.

I am using
Delphi2006/ODAC 8.1.4

Thanks for your help.

Hello,

We have checked the behaviour you have described and found no problem, at connection break or server stop, the application doesn't hang but displays a correct error message. Perhaps, your problem is due to a large value of the Timeout parameter set for OraAlerter

Hello,

Thank you for the quick response! I made some tests with a simple program and figured out that the session option LocalFailover was the problem. For testing purposes I set this flag. I set this value to false and now the components work as I expect.

Sorry, I was too optimistic. If I do not reconnect and close my application an exception is thrown while destroying the form. Here is the stack output

:0051ce18 TOCICommand.RaiseError + $20
:0051d00c TOCICommand.CheckSession + $68
:0051e2f2 TOCICommand.Prepare + $12
:0052769a TOCICommand.DoExecute + $22
:00527809 TOCICommand.Execute + $F1
:0053b582 TOCIAlerter.SendAlertMessage + $17E
:0053a261 TOCIAlerter.SendEvent + $45
:0053bb1b TOCIAlerterListenThread.Terminate + $67
:0053a8ae TOCIAlerter.Stop + $1E
:00554d0f TDAAlerter.Stop + $17
:00428aba TComponent.DestroyComponents + $4A

I'm thankful for every idea.

Hello,

Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.

Hello,

can you tell me, when I can expect the fix of this issue? For us this is an urgent problem.

Thanks.

Helo,

We are still working on this problem.
We will notify you as soon as we have any results.