Notifications
Announcements
No record found.
When i update the object from object designer and Compile
RTC client can't get the new updated object until restart the DymanicsNav71 service.
How can i fix it.
Thank You.
*This post is locked for comments
Did you try this?
blogs.msdn.com/.../about-object-metadata-and-why-i-can-t-see-object-changes-in-rtc.aspx
Check the link provided by mohana. This happens mainly due to problem with Object metadata.
You can fix this by enabling the SQL Broker.
How to enable SQL Broker : http://zarez.net/?p=767
Thank You both,
I just tested on by Server,
My Current DB is SQL 2008 R2(10.50.1600)
Enable SQL Broker is not working,
Nav 2013 R2 RTC still can't get the object update without restart service
But i tried install SQL 2012 express and enable the SQL Broker.
This is work.
The RTC will got the update without restart the service.
My DB have another Nav 2009 R2 DB inside , and setup Object Change Listener for the nav 2009R2 DB before.
Is that have any effect on Nav 2013 R2?
or this is SQL 2008 R2 limitation?
I don't believe it has anything to do with SQL Server version, please check the below link
community.dynamics.com/.../nav-change-listener-is-not-always-listening.aspx
Still not working,
when i changed the object, then go to SQL server select the record from [dbo].[Object Tracking] is 0
is that normal?
this table should have record when i update the object from object designer?
Please check if you have enabled the object change listener on your database
msdn.microsoft.com/.../dd568739.aspx
As mentioned in the article make sure check what user the service is running and enable that for that user. Once you enable and restart the service, please check the event log and it should give the information if the object change listener is started/enabled message.
Still no working, already follow the post execute the SQL query on my database.
Like this(
CREATE SCHEMA [$ndo$navlistener] AUTHORIZATION [Domain\SQLService];
GO
)
Domain\SQLService is my NAV and SQL service account
I can't found any windows event log or SQL log have message about Object change listener
I just tested using Demo DB in SQL 2008R2 is work fine.
My Current Nav DB is original from SQL 2012,
I used Generate Scripts and BCP convert whole DB to SQL 2008R2 version.
May i know convert Nav DB from 2012 to 2008R2 is not allow?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
