Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Row not visible until sorted
Fiammenghi
Member Posts: 17
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
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
0
Answers
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Source has not rspid start to export
Fabrizio