“Check-in failed Source control error: Cannot checkin pending changes” error

Applies to
ApexSQL Data Diff

Symptoms
“Check-in failed Source control error: Cannot checkin pending changes” error can be encountered during the synchronization to the Team Foundation Server repository, when the synchronization script exceeds 300 MB in size This error can be also encountered if the connection speed between local machine and Team Foundation Server hosting service is slow.

Workaround

  1. Restart the application and choose the same data sources

  2. After setting up the data sources, click the Compare button in the New project window

  3. Check only a few object in the Results grid for the synchronization process. Note that synchronization script for those objects/rows shouldn’t exceed 300 MB in size

  4. Click the Synchronize button from the Home tab

  5. Select the Update files to source control action in the Output options step of the Synchronization wizard

  6. Click the Synchronize button in the bottom-right corner, of the last step in the Synchronization wizard

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.