TF53001: The database operation was canceled by an administrator.

Question

What am I doing wrong? I get this message since today when i try to check in / get latest on my TFS 2013/ VS2013 Environment. I can't find any helpful thread about this message on the Internet.

Maybe someone here can help me?

thanks

Michael

Answer 1

Hi Michael,

Is this issue replicable for other users who are connecting to same TFS server?

---

Jahangeer

Answer 2

This issue is replicable for all users.

Answer 3

Hi Michael,  

Thanks for your post.

You can connect to your TFS Server successfully, only check-in/get latest received this error?

Please ensure your TFS’s SQL Server working fine.

And try to clean the Cache for TFS 2013 manually(delete the content of the folder only, not the cache folder itself), then restart your TFS 2013 Server:

1. Clean the Cache folder on Server machine. The folder path is: C:\ProgramData\Microsoft\Team Foundation\Web Access\Cache_v12.0.
2. After cleaned, on Server machine, click Start and select Run… to open the dialog box, then input iisreset.exe and click OK, wait it run completely.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 4

I had to get in contact with MS Support I found the following error on my SQL Server:

Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating
this process.

looks bad...

Regards,

Michael<o:p></o:p>

Answer 5

Hi Michael, 

Thanks for your reply.

After this issue be resolved from MS Support, please share your experience here.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 6

Hi Michael, 

Did manage to get this error fixed? All of a sudden we also started experiencing the same problem as you described. We have even upgraded SQL Server 2014 to the latest cumulative update released yesterday, but the problem still persists. 

Thanks!

Answer 7

If anyone experiencing this with TFS 2013 Update 2 running on an SQL 2014, the resolution for us was to change the Database Compatibility to SQL 2014.

Hope this helps and saves people one working day of troubleshooting...

Answer 8

which database should we change?

Answer 9

we have fixed this issue by applying SQL Server 2014 CU4 in this weekend.

https://support.microsoft.com/kb/2999197?wa=wsignin1.0

In my enironment, this issue started when a client user was trying to checkin a big set of files (more than 4,000 files). During the uploading, the server return a message "The database operation was canceled by an administrator". Then all the client couldn't upload/download codes from the TFS server and get the same error message, but workitem updating is ok.

We tried to upgrade TFS to update 3/4, but it didn't work.

After installing CU4, the error disappeared.

hope this will give any help to you guys.

Answer 10

I received this error when I changed the SQL Server service account to a domain login and then stopped and restarted the SQL Server service without stopping the Collection in the TFS Administration Console first. The error resolved when I set the service back to the original service account (which was NT Service/MSSQLSERVER) and restarted the SQL Server service.

I didn't get the error when I shut down the collection first and then changed the login for the SQL Server service. I'm running SQL Server 2014 Standard Edition and I haven't installed CU4. Might want to try this first before deciding to install a cumulative update.