Queing events not firing

Queing events not firing

Postby 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.
joet919
 
Posts: 5
Joined: Mon 10 Sep 2007 18:17

Re: Queing events not firing

Postby 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/30502535/oracle-advance-queue-dequeue-not-working
https://community.oracle.com/thread/3541287

Unfortunately, we don’t have information about your configuration, and you need to study it yourself.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44

Re: Queing events not firing

Postby 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
joet919
 
Posts: 5
Joined: Mon 10 Sep 2007 18:17

Re: Queing events not firing

Postby 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;
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle