Page 1 of 1

Error ORU-10015 using alerts

Posted: Wed 05 Aug 2015 07:46
by ths
Hello,
we have quite offen the following error message using alert component:

ORA-20000: ORU-10015: error:3 waiting for pipe message.
begin DBMS_ALERT.WaitAny(:Name, :Message, :Status, :TimeOut); end;

Could you tell us what can be done to avoid it? I didn't find any related topics on the forum.
Thanks,
Vladimir

Re: Error ORU-10015 using alerts

Posted: Thu 06 Aug 2015 05:28
by AlexP
Hello,

We cannot reproduce the problem. Please specify the exact versions of your Oracle client, server, IDE, and ODAC, and also send a small sample demonstrating the problem to alexp*devart*com

Re: Error ORU-10015 using alerts

Posted: Thu 06 Aug 2015 14:24
by ths
Hello Alex,
it would be difficult to prepare test application.
We send alert messages from Oracle PL SQL using DBMS_ALERT.SIGNAL function. The message is triggered via Oracle Job when some data conditions are sutisfied. The application is subscribed to the corresponding event. When this event is received, we show popup window to the user.
The error is written to the log table by the database trigger on AFTER SERVERERROR ON DATABASE.
We use ODAC 9.5.14 in net=true configuration, Oracle Server 11g and Delphi5 as IDE.

Re: Error ORU-10015 using alerts

Posted: Fri 07 Aug 2015 07:39
by AlexP
Try to create a small application demonstrating the problem and send it to us. Unfortunately, without reproducing the problem, we can't help you solve it.

P.S. Please try to reproduce in the OCI mode.