The past few days have been spent with hectic testing in terms of a number of VSTS Rangers Projects that are on the verge of bubbling to the surface. One of them includes the TFS Integration Platform initiative, where our focus has been primarily on the public interface, the guidance and the getting started (hands-on-lab) material. We have found some weird and nasty gremlins … commonly known as the bug bash, I tend to refer to these times as fun and games.
Grant has also been doing immense testing as part of his Pioneer Dogfood environment and has highlighted this issue:
Running a one-way-migration of test cases from one TFS Server to another, using Microsoft SQL Express.
The following exception introduced itself:
Unhandled Exception: System.Data.UpdateException: An error occurred while updating the entries. See the InnerException for details. ---> System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.CONFLICT_CONFLICTS'.'PK_Conflicts' in database 'TfsMigrationConsolidatedDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Looking at the size of the TfsMigrationConsolidatedDB.mdb file, it is (as expected) 4GB – which is the limit of a SQL Server Express server.
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA
Upgrade to SQL Server Standard edition, which does not have a 4GB limit. See http://msdn.microsoft.com/en-us/library/ms144259.aspx#skuupgrade for details.
Thanks Grant! We will add this Q&A to the TFS Integration Platform – Migration Guidance document as well.