NAV doesn't write records into object tracking table (converted sql data base)

(0) Share

Report

Posted on by Vojislav Nikolic

110

Dear all,

Issues is in the name of post. Database is converted with script from SQL Server 2012 to SQL Server 2008R2. After that, base is functional but record cannot be written onto object tracking table. Each modification state on NAV is not reflected onto RTClient. Change listener is activated and working, but still no success. Table is empty. Version of NAV is 2015. Any suggestion?

Best regards,

VNI

*This post is locked for comments

All responses (5)

Answers (0)

Suggested answer

Suresh Kulla 45,180 on at

Like (0)

Report

RE: NAV doesn't write records into object tracking table (converted sql data base)

As mentioned in the blog, if you are using now SQL broker and you don't see changes then switch to polling and try. Vice Versa.
Vojislav Nikolic 110 on at

Like (0)

Report

RE: NAV doesn't write records into object tracking table (converted sql data base)

SQL Broker is enabled, but he listening on empty table (Object Tracking Table). Maybe that the reasons why changes are not affected on RTClient. Only when we restart NAV services, changes are made.
Suggested answer

Suresh Kulla 45,180 on at

Like (0)

Report

RE: NAV doesn't write records into object tracking table (converted sql data base)

Please check this link

blogs.msdn.microsoft.com/.../about-object-metadata-and-why-i-cant-see-object-changes-in-rtc
Vojislav Nikolic 110 on at

Like (0)

Report

RE: NAV doesn't write records into object tracking table (converted sql data base)

We build that, some object are affected by errors, but still no success. RTClient is still same and data is not written onto it.
mmv 11,467 on at

Like (0)

Report

RE: NAV doesn't write records into object tracking table (converted sql data base)

Hi,

Could you try the "Build Server Application Objects" functionality in the Development Environment"?