Object Change Listener in NAV 2013 R2 and beyond

Devvan · 2016-06-30

Hi all,

I'm struggling (failing) to activate the Object Change Listener for NAV versions beyond 2009.
I followed the steps described here: https://msdn.microsoft.com/en-us/library/dd568739.aspx and this works great for my 2009 database.
Following these steps for 2013 R2 however does not result in the changes I was expecting! Also the previous link only specifies 2009, so maybe it is not possible.
In 2009 I see the extra entries in the Service Broker/Queues and Service Broker/Services as described here: https://blogs.msdn.microsoft.com/nav/2011/04/28/about-object-metadata-and-why-i-cant-see-object-changes-in-rtc/. And if I start an SQL Profiler, I don't see the following entries every second: exec sp_execute 1,@lastKnownTimeStamp=463223.

In 2013 R2 I do not see those entries in the Service Broker and I DO see exec sp_execute 1,@lastKnownTimeStamp=463223. Which leads me to believe that I'm doing something wrong, or I am expecting the wrong things.

Can anyone tell me if I'm doing something wrong or if this is not suppose to work this way in 2013 R2 and further?

Thanks in advance!

archer89 · 2016-06-30

follow http://www.waldo.be/2012/05/14/nav-change-listener-is-not-always-listening/

vaprog · 2016-06-30

I use to combine the steps given in Provisioning the Microsoft Dynamics NAV Server Account with the steps from Enabling the Object Change Listener (as given by you above).
The following post on the Dynamics NAV Team Blog seems to suggest that at least part of the 2009 stuff is still needed for 2013: Manually restoring the NAV 2013 Demo Database

Devvan · 2016-07-01

archer89 wrote: »

follow http://www.waldo.be/2012/05/14/nav-change-listener-is-not-always-listening/

I already tried those steps, but a view in the SQL profiler shows that it is still "polling"...is this not the case in your database(s)?

vaprog wrote: »

I use to combine the steps given in Provisioning the Microsoft Dynamics NAV Server Account with the steps from Enabling the Object Change Listener (as given by you above).
The following post on the Dynamics NAV Team Blog seems to suggest that at least part of the 2009 stuff is still needed for 2013: Manually restoring the NAV 2013 Demo Database

I followed the steps from Provisioning the Microsoft Dynamics NAV Server Account...some things were not in order, so thanks for that! But also after this the middle tiers keep "polling"...

Maybe another question, what would I have to see to know the SQL broker is used for this?

Object Change Listener in NAV 2013 R2 and beyond

Answers

Categories