TFS 2012 Update 4 fails in WorkItemTrackingToDev11M55.sql on SQL Server 2008 R2 RTM

  • [アーティクル]

If you are upgrading or installing TFS 2012 Update 4, you must use SQL Server 2008 R2 SP1 or newer.

If you try to use SQL 2008 R2 RTM you will hit this error:

[Error] TF400744: An error occurred while executing the following script: WorkItemTrackingToDev11M55.sql. Failed batch starts on the line 9. Statement line: 42. Script line: 50. Error: 102 Incorrect syntax near '('.

After upgrading your SQL Server to 2008 R2 SP1 or newer, you can restart your TFS upgrade by opening the TFS Administration Console.  Navigate to the Team Project Collections node.  Select each collection, go to the Status tab at the bottom of the page, and select the failed job.  A Retry Job link will appear on the right.  Click that to restart the job.  Repeat for all failed collections.

 You can download SQL 2008 R2 SP1 here: https://www.microsoft.com/en-us/download/details.aspx?id=26727

Comments

  • Anonymous
    September 03, 2014
    Awesome! Thanks Will, just what I needed. I tried searching using that exact error and syntax word for word here, google, and bing.. Nothing... Was given this link by Daniel_Steiner - Microsoft community contributor on thread: "TFS 2012.2 update to 2012.4 - Team Foundation Server succeeded, however upgrading the data was unsuccessful" KUDOS to you both! I believe this solves my issue!