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
Missing Record Links after upgrade to NAV 2013
JosephGress
Member Posts: 36
I recently upgraded our internal NAV database from NAV2009SP1 to NAV2013. The upgrade went smoothly and we are live on the upgraded database. However, I have discovered that the records in table 2000000068 -- "Record Link" disappeared in the upgraded database.
Questions:
1) Has any one else run into this issue?
2) If so, have you found a way to move the "Record Link" records from the old database to the new one.
Questions:
1) Has any one else run into this issue?
2) If so, have you found a way to move the "Record Link" records from the old database to the new one.
Joseph Gress
0
Comments
First, I had done a test upgrade before the live upgrade. I just checked and the Record Links exist in that database.
Second, I now recall that I ran into some issue at the very end of the live upgrade. It was late on a Saturday night and I was afraid that I would have to redo the upgrade from the beginning. I think it was a security issue but I don't remember the details. Anyway, I think that I resolved the issue by doing a NAV backup of only the company data in NAV2013 then creating a new NAV2013 database and restoring that NAV backup. That would explain why the Record Links are missing as that table has DataPerCompany=NO.
Now, I just need to figure out how to copy the record links from my NAV2013 test database to our NAV2013 live database. There are two challenges with this: The Record ID field is type RecordID. I'm not sure what to do with that. And, the Notes field is a BLOB field. I have to figure out how to deal with that as well.
Let me know if you have any suggestions.
Thanks
Thanks
Niles