“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

Resolution
This issue has been solved in the latest version of ApexSQL Data Diff that can be downloaded from here

 

Related posts:

  1. The synchronization script is generated with errors when synchronizing a specific database with an empty database as a destination
  2. Synchronization script can’t be created when using CLI in ApexSQL Data Diff
  3. A “Error 404” error is encountered when linking a database to Team Foundation Server in a different domain from the host
  4. “Cannot insert the value NULL into column ‘ColumnName’, table ‘TableName; column does not allow nulls. INSERT fails.” error
  5. “Connection was failed with message: ‘The executable did not complete within the allotted time’” message