You’re offline. This is a read only version of the page.
Hi everyone
I have this situation:
SQL Server has all the permissions as dbo for the database.
But when I change a Page nothing happens.
When I create a Page the system runs well in RTC. But if I go to the same Page and change something, for instance, a basic thing, change a Message (this is a basic example) the Page remains with the same message when it was created. In resume, I can create the Page, but nothing it seems that the changes don't take effect after any modification.
I looked the SQL server permissions, and I worked aldo with administrator permissions (dbo, sysadmin, etc...) and ... no use.
If I work in localhost everything it works ok.
Do you have any idea ou experiences on this issue ?
Thanks a lot.
*This post is locked for comments
Hi Dan
We discover the problem.
BROKER ..... must be FALSE !!!
We decided to use the ideas of BROKER=TRUE but no use.
Never change options by the interface from SQLServer. Use SQLQuery. This is the issue.
BUT AND SO, IN RESUME ...
. BROKER affects the tracking changes or the sync between NAV and SQL.
. use SQLquery and don't use interface from SQLServer (never trust on those changes by the interface).
. BROKER=FALSE.
Tks and anything from your side be free to talk with us.
Bye for now.
Hi Dan
Tk for your reply.
Let me try to explain, maybe better.
When I make any change in objects, for example, and just to try to understand very easly ... I put a message in the OpenPage (as example) ... and RTC does not show me the message when I open that page.
Is strange more when ... I create a page, a new one ... I put a message in the same place, OpenPage,and compile the new page and run. That message appears when I run the page.
So ... and then ... I go to change that message, in the same page, and put more letters, for instance, just to have another message. Then I compile and run the page. You know what is happening? The RTC show the first message... yes ... the firts message.
Worth, I go to that same page and delete the message line. So there is no message anymore, there. Compile and run. And ... it appars the first message, the first one, when I created the page for the first time.
I alerady saw this between our own people.
This is happening in a customer envronment because in our own development enviroment in localhost is running perfect.
About SQLServer issues: no message in the log, except the tradicional log with open this close that... etc.
IS SEEMS THE TRACKING DOES NOT HAVE LYNCS ACTIVATED BETWEEN SQL AND NAV.
WE CAN CREATE BUT IMMED AFTER WE CANNOT CHANGE.
DO YOU KNOW IF MSFT report any hotfix for this issue? We tried to find out some but nothing really related with this subject.
Tks for all you care and help.
C u.
Just to point out: at least when you close the RTC client and open it again, are you able to see the changes?
Furthermore, the SQL Server error log does not log any relevant problem?
Hi Dan
Noops !
I read the article, and for sure is stil an obscure situation, because I deleted the Object Tracking table and the numbers are coming in order, and I compile 2 objects and I could see the number growing by the order, but ... no use.
I did check again all the services, even the Customsettings, and so on ... the SQLServer permission, and Logins permissions, and we can change, but ... the RTC does not want to show our changes.
Uff... with no error messages or warnings, nothing, even the eventlog say... nothing of nothing.
Mistery, where is the RTC is getting the old code that is presenting, how did it gets the code ?!!!!
For sure is saved somewhere ... but ... ??!!!
Tks again.
Can you try modifying an object and check if in the Object Tracking table is the one with the highest timestamp? If not you can consider to delete all the records from this table, restart the NST and check again if the problem is fixed: dynamicsuser.net/.../nav-change-listener-is-not-always-listening.aspx
Hi Dan
Yes , was already TRUE on Broker. I did see the post about that and I change teh Broker before, but no use.
Is there a way to check if Tracking table from NAV is doing well the sync with SQL Server ?
Because it seems the tracking does not have the sync.
I detected this when I Import a new Fob to the customer database, and I discover those changes are in fact inside the Page objects but are not being executing by the system, and the code that are running is the old one.
The point is that when the a Page is created (this I tested after many tries), this page runs well. But if we go to any place of this page, immed after, and put another thing, anything, ... change a message, put a new message, change some code ... no use, there is no change when you run RTC. The system just execute the code just like was before the first compile.
Tks.
You need to check if the SQL Broker is enabled and, if not enable it:
ALTER DATABASE [MyNAVDatabase]
SET ENABLE_BROKER
WITH ROLLBACK IMMEDIATE
More information here: blogs.msdn.com/.../about-object-metadata-and-why-i-can-t-see-object-changes-in-rtc.aspx
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
