web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Migrating from onprem ...
Small and medium business | Business Central, N...
Unanswered

Migrating from onprem BC16.1 to cloud BC16.1 fails on standard table

(0) ShareShare
ReportReport
Posted on by Alain Krikilion 5

Hi,

I did a test upgrade from NAV2013 to BC16.1 cloud. I did this same upgrade also to BC15.3 cloud in the past and I didn't encounter any problems before.

The onprem version works nicely. I can also run the value entries page and I can scroll through the records. So the table seems ok. But when I do the migration to the cloud, it fails on 1 table: Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972. This is the base Value Entry Table. No extension is touching this table.

The error I have is: 

Failure happened on 'Source' side. ErrorCode=UserErrorInvalidDataValue,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to read data from source.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.OverflowException,Message=Conversion overflows.,Source=System.Data,'

I checked the fields between BC15 and BC16.1 and there were no size changes (System.OverflowException let me think this was the problem). The only change I noticed is that some option fields (field(79; "Document Type" and field(90; "Order Type") have been changed to enum fields.

So I have the idea the problem could be the change from option to enum, but other tables where this has been done, doesn't have the problem.

Any idea what the real problem could be and how to fix it?

Thanks.

  • Community Member Profile Picture
    Community Member on at

    Data migration is the process of securely migrating data from your on-premises SQL Server instance to your Business Central online tenant. The process uses the Azure Data Factory (ADF) to migrate the data between databases directly, meaning it does not look at any permissions within the applications you are transferring data between, only SQL permissions.

    In order for the data migration to take place, you must successfully complete the Cloud Migration Setup assisted setup wizard in your Business Central online tenant. Once the wizard is complete and data migration is activated, initial azure data migration will happen at the scheduled time. Alternatively, you can trigger the data migration process manually.

    Data is migrated between the two systems on a per-table basis, and success and failures are tracked for each table. If a table fails to migrate, the error will be captured, and the migration moves on to the next table until completed. Tables will fail to migrate if they cannot be found, or if the schema does not match between the cloud and the on-premises tables.

    The initial data migration time can vary depending on factors such as the amount of data to migrate, your SQL Server configuration, and your connection speeds. The initial migration will take the longest amount of time to complete because all data is migrating. After the initial migration, only changes in data will be migrated so they should run more quickly. You do not need to run the migration process more than once if you don't want to, but if you are running the migration while users are still using the on-premises system you will need to run at least one more migration in order to ensure all data was moved to the cloud before you start transacting in the cloud tenant.

  • Alain Krikilion Profile Picture
    Alain Krikilion 5 on at

    Hi Lewis-H,

    Thank you for your reply, but I all knew this.

    The problem is that there is that 1 table that fails. It is a completely standard table that upgraded well using BC15.

    But now that I am using BC16 to redo the upgrade, it fails. And the error message I get is isn't telling anything useful.

  • Alain Krikilion Profile Picture
    Alain Krikilion 5 on at

    I got a reply from Microsoft: the problem is on their end and it should be fixed this week or next week.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 741 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 514 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 336 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans