Item Entry RelationError while upgrading 301 t0 400 Stage II

Jyoti_Kapoor
Member Posts: 56
We are working on an upgrade from Nav 3.10 to Nav 4.0. We are getting some data related errors while trying to convert the DB, which as follows:
The stage II upgrade codeunit 104049 "Item Trkg. Upgrade Step 2" splits the item ledger entries and value entries using the function SplitValueEntries() and SplitItemLedgerEntries() and after this it creates the "Item Entry Relation" entries with function CreateItemEntryRelations(). As per the splitted item ledger entries it gives "New Entry No." to the temporary item tracking entry table records with the "item ledger entry" No. created new after splitting. And these new entry nos. are used while creating the item entry relations. This gives an error for Duplicate "Entry No." while putting records into "Item Entry Relation" table. This should not happen ideaaly as these new entries for the multiple entries are made by the procedure only with new entry nos. Please suggest on this issue, i am stuck up at this error.
Thanks & Regards,
The stage II upgrade codeunit 104049 "Item Trkg. Upgrade Step 2" splits the item ledger entries and value entries using the function SplitValueEntries() and SplitItemLedgerEntries() and after this it creates the "Item Entry Relation" entries with function CreateItemEntryRelations(). As per the splitted item ledger entries it gives "New Entry No." to the temporary item tracking entry table records with the "item ledger entry" No. created new after splitting. And these new entry nos. are used while creating the item entry relations. This gives an error for Duplicate "Entry No." while putting records into "Item Entry Relation" table. This should not happen ideaaly as these new entries for the multiple entries are made by the procedure only with new entry nos. Please suggest on this issue, i am stuck up at this error.
Thanks & Regards,
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions