Dynamics Community Forum Thread Details

Error migrating Dynamics GP to BC

Attempting to migrate customer's company data from Dynamics GP to D365 BC using Cloud Migration Setup/Management within BC application.

The diagnostic of the data is successful, and the data migration goes through, but then it shows 'Pending Upgrade', so we run the data upgrade and after an extremely long period of time, it fails with this error:

The record in table GP Account already exists. Identification fields and values: Account Index='1'
/GP Populate Combined Tables/(CodeUnit 40125).PopulateGPAccount line 39 - Dynamics GP Intelligent Cloud by Microsoft
/GP Populate Combined Tables/(CodeUnit 40125).PopulateAllMappedTables line 7 - Dynamics GP Intelligent Cloud by Microsoft
/GP Cloud Migration/(CodeUnit 4025).InitiateGPMigration line 16 - Dynamics GP Intelligent Cloud by Microsoft
/GP Cloud Migration/(CodeUnit 4025).UpgradeGPCompany line 10 - Dynamics GP Intelligent Cloud by Microsoft
/GP Cloud Migration/(CodeUnit 4025).HandleOnUpgradeGPCompany line 5 - Dynamics GP Intelligent Cloud by Microsoft
/GP Cloud Migration/(CodeUnit 4025).OnUpgradeGPCompany(Event) line 2 - Dynamics GP Intelligent Cloud by Microsoft
/GP Cloud Migration/(CodeUnit 4025).OnRun(Trigger) line 18 - Dynamics GP Intelligent Cloud by Microsoft

We've been through the MSFT articles to prep data prior to upgrade as well as verifying SQL and GP versions, compatibility level on the databases and Change Tracking enabled where needs to be:

Dynamics GP to Dynamics Business Central migration tips

GP to BC Migrations: SQL Script to Check for Problematic GP Data Conditions With FAQs!!!! (dynamics.com)

It always seems to fail on the exact same error each time.

I know that the GL00100, GL40200 and SY00300 tables, from Dynamics GP, make up this 'GP Account' (4090) table in BC, and we've verified those tables are correct with primary key and indexes intact, so there's no duplicate records, anything like that.

I'm hoping that someone has run into this that can give me another path to go down, as I keep beating my head against a brick wall it seems.........

Thanks to anyone that has any input.........

Quick Links

Leaderboard