Cloud Migration with too many companies fails

Running the Dynamics365 Business Central Cloud Migration can sometimes give a very strange error, like this one:

ErrorCode=UserErrorComputePluginFailure,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The size of lookup activity result exceeds the limitation 4194304.,Source=,''Type=Microsoft.DataTransfer.Execution.Core.ExecutionException,Message=The size of lookup activity result exceeds the limitation 4194304.,Source=Microsoft.DataTransfer.TransferTask,'

Something has exceeded an internal limit of 4194304 bytes (that’s a 32-bit limitation indicator).

After talking with Microsoft, I now know, that this error can come in two different scenarios:

  • Too many companies
  • Too many tables

In my case, the issue was too many companies (70+), and I reduced the number of companies selected. Then I can run a separate “batch” with the rest of the companies.

Microsoft do not currently have a solution if this error is encountered in case of too many tables.