Phantom data in nav after upgrading- Strange issue

Developer101
Developer101 Member Posts: 569
in NAV Three Tier
We have a situation.

We have a bit of an issue after upgrading NAV 5 to NAV 2016.

Some of the records in the tables are appeared to be corrupted and I know the reason but my issue is that even after deleting such records they still re-appear in NAV table but when running a select query in SQL the data is not there which is right. I have tried synchronizing but does not work.

I have tried restarting the service after deleting the records but I still see those records in the table which actually do not exist if I run sql query or if I do SETFILTER and FIND('-') in nav its self. The data is just shown in the table without being existed.

Any ideas?
United Kingdom

Best Answer

Answers

  • SilverX
    SilverX Member Posts: 134
    Hmmm. Only two: Wrong SQL query or you did the query on the wrong database or SQL instance.
    Cheers
    Carsten


    ==> How To Ask Questions The Smart Way
    This post is my own opinion and does not necessarily reflect the opinion or view of my employer.
  • Developer101
    Developer101 Member Posts: 569
    There was a problem with trailing spaces.
    United Kingdom
  • Developer101
    Developer101 Member Posts: 569
    Yes some how it was wrong. deleting the trailing spaces from the key field made the query right.
    United Kingdom

Categories