Queing events not firing

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
joet919
Posts: 5
Joined: Mon 10 Sep 2007 18:17

Queing events not firing

Post by joet919 » Fri 03 Mar 2017 16:11

Hi

I have issues where when messages are queued events never fire. I have a small example that demonstrates this but I cant seem to attach it.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Queing events not firing

Post by Pinturiccio » Thu 09 Mar 2017 14:14

We could not reproduce the issue with your test project. We receive 3 notifications and events are fired successfully. Probably events do not fire for you because of incorrect configuration. Here is a couple of examples when notification does not work:
http://stackoverflow.com/questions/3050 ... ot-working
https://community.oracle.com/thread/3541287

Unfortunately, we don’t have information about your configuration, and you need to study it yourself.

joet919
Posts: 5
Joined: Mon 10 Sep 2007 18:17

Re: Queing events not firing

Post by joet919 » Fri 10 Mar 2017 12:53

I'm using Oracle 11.2.0.4 can you share your oracle version and how these 2 parameters are set please?

1.job_queue_processes
2.aq_tm_processes

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Queing events not firing

Post by Pinturiccio » Tue 14 Mar 2017 14:24

We have the following values on our Oracle 11.2.0.4 server:
job_queue_processes=1000;
aq_tm_processes=1;

Post Reply