SQL Server 2014 error with TFS 2013 (TF53001: The administrator has canceled database operations)

Server Environment:

-TFS with Update 2

-SQL Server 2014 (two node database servers configured for AlwaysOn high availability)

-Windows Server R2

Yesterday, when we assisted the project team members in importing the source code, we found that an error occurred during the import of the source code (error number TF53001, for example).

Figure the source code cannot be downloaded and updated through visual Studio/eclipse

We then immediately troubleshoot the problem and find that all developers are not able to download and check in the source code, but work items (Web pages) work correctly and can be queried and updated.

At the same time, we tried restarting the TFS application-tier server, the database server, but failed to resolve the issue.

Through the analysis of the production environment server logs, we initially judged that the database server failed and the database server could not provide normal access (for example) to the TFS application-tier server.

Figure-A database error log

Figure 3– Database Server exception

We also tried to upgrade TFS's latest patch pack (update 3/update4) in the TFS environment, but all were able to fix the problem.

In view of the recent failure to make a system adjustment to the server, we initially determined that this is due to database server defects caused by the problem. Finally, the solution to the problem is to install the SQL Server 2014 patch (CU4) on all database node servers.

After installing CU4, adjust the AlwaysOn configuration and the problem disappears, and developers can check in the code normally.

SQL Server 2014 error with TFS 2013 (TF53001: The administrator has canceled database operations)