Phantom data in nav after upgrading- Strange issue

Developer101

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?

SilverX

Thanks for sharing the issue. So in fact the query was somehow wrong ;-)

SilverX

Hmmm. Only two: Wrong SQL query or you did the query on the wrong database or SQL instance.

Developer101

There was a problem with trailing spaces.

SilverX

Thanks for sharing the issue. So in fact the query was somehow wrong ;-)

Developer101

Yes some how it was wrong. deleting the trailing spaces from the key field made the query right.