I added a standard "External Doc No" field to the customer ledger entry page in Dynamics NAV 2009 R2. Then I restarted the SQL Server and then NAV Service but the field will not display as a column to choose from to add to the user's CLE page. I changed profiles to test as well. I am at a loss why it will not display for this client. I have no other issues with other clients on same NAV version/exe.
Krystal
*This post is locked for comments
Probably not .. I'm quite sure it's the Change Listener.. .
Although, working with different versions is kind of "dangerous". Make sure you always import objects from a lower build to a higher build .. and compile (never forget to compile). Moving objects from an environment with a higher build to one with a lower build is "dangerous" .. mainly when doing that with reports. I have seen systems that crash .. and take a long time to be able to get it running again .. .
Thanks Waldo,
Out of curiosity, would the NAV version or build make a difference?
Our client is running a slightly different version then we are in-house.
On a copy of their db with our .exe we can view the change on the page. On their live environment, the page modification was not visible unless the steps above were taken.
Krystal
It is not common to restart SQL Server - this should never be necessary to get your object updates.
If object changes don't get to the RTC, it means there's something wrong with your object listener, and you should check that.. .
It's a good practise to indeed Stop-and-start instead of "Restart" a service. I also noticed different behaviour in that .. strangely enough :-/.
and also a tip I would like to give: clear the "Object Tracking" table before you stop-and-start the NST service. In some cases, the NST gets wrong timestamps, which makes the object-update misbehave as well.. .
hope
Strange issue, glad you got it figured out though
Hello All,
Resolution has been found. I still do not understand the issue with the service but this resolved the issue and allowed the modification to be visible
1. Stopped (not restarted) the NAV Service
2. Restarted the SQL Server
3. Restarted the NAV Service
Very strange, the having to restart the server to see the changes problem is related to the NAV change listener being correctly configured in SQL however not seeing the changes after a restart doesn't make sense at all,
Sorry if this seems basic but it never hurts to confirm and i really cannot think what else might be causing it :P
Have a look at the service name of the RTC, then check the name of the service, in Services, on the server, stop all other services except the live and open the RTC client again to ensure it still opens (First check that it is really pointing at the live)
Then head for the Program files NAV install folder, open the correct service folder and check the config file, specifically make sure that the Port, Service Name & SQL database name are what you expect them to be.
Let us know what you find
Hello Nev,
I made sure I am working in the correct database. What is VERY odd is that I made copy of their database and in our development environment the page modification displays. I recompiled the object and then replaced their page #25 with the one from our development and still somethign is not allowing me to view the added field.
I changed profile, security, etc.
Hi
Just to cover the standard stuff, are you sure that you are connected to the same system in the classic development environment as you are looking at the RTC in?
Just in case something funny is going on, perhaps try change something else on another page and see if the change is visible?
Cheers
Nev
Hello again,
I just tried both ways and neither would diplay on the RTC Page. When I design the list page #25 (CLE) it is there but when I run the RTC it is not, nor can I add it through personalization. I have only experinced this once and topping the NAV servie, restarting SQL the restarting NAV service resolved it, but not in this case.
#1
André Arnaud de Cal...
292,884
Super User 2025 Season 1
#2
Martin Dráb
231,748
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (