Intelligent cloud data replication failed without error

justinasvisakavicius

Hello everyone

We are trying out Intelligent Cloud as data migration solution, but we are having problems replicating data to cloud. Problem is that Intelligent Cloud setup is successful, new companies are created in cloud tenant, but when we try to replicate data it just fails without reporting any error.
We are using Microsoft self hosted integration runtime and have NL localization in cloud sandbox and installed Business Central CU2 NL localization on premise with demo database.
1st try we created BC cloud sandbox from official Business central page, uploaded extention to sandbox and to on premise BC. Showed that initialization was complete, new companies were created but when trying to replicate data it failed after 5 minutes without showing any error.
2nd try reset sandbox, created new nav users with SUPER permission sets, retried assisted setup and it worked, again initialization was successful and new companies were created but when trying to replicate data it failed without error.
3rd try tried running replication without integration runtime active, obviously it failed but it showed "error".
4th try created new custom company on BC on-premise and tried to replicate that data, again the results were the same, initialization successful, data replication failed.
5th try tried using different licenses. Result - same.
6th try uninstalled custom extentions. Result - same.
7th try tried different SQL connection string on setup. Wouldn't work at all.
8th try tried activating intelligent cloud on production cloud tenant. Result - same.
9th try gave all possible permissions to SQL database user witch is used in SQL connection string. Result - same.
10th try uninstalled all extentions except intelligent cloud extentions on both Cloud and on-premise business centrals. Result - same.
Each time Sandbox enviroment was reseted. Every time it showed that data replication failed but there were no errors shown. Total successful tables = 0 failed tables = 0. Testing connection to database on Integration Runtime Service shows that everything should be fine.
What might be the problem?

kriki

A few links that might help (they did help me):
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/about-intelligent-edge

https://jackmallender.com/2018/11/27/migrating-to-microsoft-dynamics-business-central-in-the-cloud-from-nav/

https://jackmallender.com/2018/11/28/common-issues-with-migrating-business-central-data-to-the-cloud/

https://jackmallender.com/2018/11/28/the-big-problem-with-intelligent-cloud-data-replication-or-why-intelligent-cloud-is-not-ready-for-the-real-world/

Checking the event log ("Applications and Services Log"=>"Connectors - Integration Runtime") is a good place to find errors even when in BC cloud log you don't find any error.