Row not visible until sorted

Fiammenghi
Fiammenghi Member Posts: 17
edited 2021-05-07 in NAV Three Tier
Hi,
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
Fabrizio

Answers

  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Developer101
    Developer101 Member Posts: 569
    This happens when migration is done directly into the sql database. Is there a way you can migrate data using rapid start?
    United Kingdom
  • Fiammenghi
    Fiammenghi Member Posts: 17
    Too many records and tables..
    Source has not rspid start to export

    Fabrizio
  • Developer101
    Developer101 Member Posts: 569
    Export in spreadsheet and import via rapidstart in the target db?
    United Kingdom

Categories