You’re offline. This is a read only version of the page.
634
Hi Upgrade experts.
I ma doing data upgrading NAV 2009 to BC 18 on premise. This is standard data upgrade with out any customization. In this step I am now converting NAV 2015 Database to BC14.
after converting 2015 database I have import all BC standard objects along upgrade toolkit objects.
I am following the doc https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrading-the-data.
When I started syncing my tenant. "Sync-NAVTenant -ServerInstance BC140" I get the following error on upgrade toolkit objects.
Sync-NAVTenant : Changes to the tenant database could not be applied. Affected tables will not be available.
"OperationalWithSyncFailure
DetailedState : Changes to the tenant database could not be applied. Affected tables will not be available.
The first error was:
When the TableSynchSetup.Mode::Copy mode is used in an upgrade codeunit for synchronizing a table, the upgrade table can contain a subset of fields of the original
table. The fields and the primary key of the upgrade table must match those in the original table.
The following errors must be fixed:
Upgrade table 'UPG Vendor Ledger Entry' cannot have fields which have a different design in the original table 'Vendor Ledger Entry': 'Description, Vendor Posting Group,
Purchaser Code, No. Series, Creditor No., Payment Reference, Recipient Bank Account, Giro Acc. No.'.
Retry the operation when the problem has been resolved."
I have read a post which was suggesting to add all fields & keys to UPG table as we have in standard BC table.
forum.mibuso.com/.../error-on-nav-2015-gt-nav-2017-data-upgrade-step
I have done that but the problem still persist.
I have spent a lot of time on this issue, Finally I sorted out as follows,
There are some obsolete fields in the standard tables like "Giro Acc. No." in Vendor & vendor Ledger entry which is marked as Obsolete. This field is also created in the UPG tables for example Vendor, Item Purch header , Purch Inv Hedaer. Even I have tried the other solution by adding all the fields & keys in the UPG table, Unfortunalty Sync-NAvtenant did not work.
All you need is just delete this fields from the UPG table and you are good to go.:)
Once the Sync-NAVtenant commend goes well. You can later on add these fields in the coming upgrade steps if there any error comes across way.
Share
Report
All responses (
Answers (
