Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Object Change Listener in NAV 2013 R2 and beyond
Devvan
Member Posts: 2
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!
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!
0
Answers
Franz Kalchmair, MVP
Alias: Jonathan Archer
please like / agree / verify my answer, if it was helpful for you. thx.
Blog: http://moxie4nav.wordpress.com/
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 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)?
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?