“Connection was failed with message: ‘The executable did not complete within the allotted time’” message

Applies to
ApexSQL Data Diff

Symptoms
“Connection was failed with message: ‘The executable did not complete within the allotted time’” message can be encountered during the recomparison after synchronizing to the Mercurial source control repository, when the synchronization script exceeds 300 MB in size. This message can be also encountered if the connection speed between local machine and Mercurial hosting service is slow.

Workaround 1

  1. Once the above message is encountered, click the OK button and the Result grid window will be shown

  2. Click the Refresh button from the Home tab:

  3. Once the Results grid is refreshed with latest changes, if all objects with corresponding rows were previously selected for synchronization, those should be shown in the Equal tab of the Results grid:

Workaround 2

  1. Restart the application and choose the same data sources

  2. Once the data sources are set, click the Compare button in the New project window

  3. The Results grid will show the latest synchronized objects in the Equal tab, once the comparison process is finished

Workaround 3

  1. Repeat the same steps from workaround 2

  2. Check only a couple of objects in the Results grid. Depending on the number of rows in objects the generated synchronization script shouldn’t exceed 300 MB in size

  3. Click the Synchronize button from the Home tab

  4. Under the Output options step of the Synchronization wizard, choose the Update files to source control action

  5. In the last step of the Synchronization wizard, click the Synchronize button in the bottom-right corner

Affected version:
ApexSQL Data Diff 2016.03.0110

Planned resolution
The issue is scheduled for resolution in the next release of ApexSQL Data Diff 2017, planned for the Q4 2016.