I need your help in order to solve a boring issue.
I had to migrate some huge data from an old DB (Nav 5) to a new DB (Nav 2017).
I used ALTOVA MAPFORCE to open the 2 SQL DB , i choose the tables to migrate, mapped the fields, (created dumb value for the new fields in the new SQL NAV)
Run the mapping and everything is almost ok.
At moment in 50 tables i transferred only 5 have following problem :
In db with SQL management studio i see the date without any kind of problem
but if i open the page of these 5 tables ( for example Customer Posting Group) the page show no rows, but as soon as i click on any column to change sorting order, or the refresh button, the rows does appear.
Any suggestion ?
This happens also with another non-standard table.
Once refreshed the content is there and all correct.
Thanks in advance