1

When checkin my pending changes VS got the errror:

%error="500004";%:(null): database update failure - error %error="(null)";% executing (null) statement for (null)`

enter image description here

I have no idea about this.Please give me a hand,thanks!

huoxudong125
  • 1,966
  • 2
  • 26
  • 42
  • Any update on this error, did you fix it? – PatrickLu-MSFT Jun 16 '17 at 02:12
  • Pre Checkin is OK, But this time is not working now. – huoxudong125 Jun 16 '17 at 02:14
  • Usually this kind of issue is related to cache. You could close VS, clear the cache follow the link in my answer , reopen VS, try the check in operation again. If the error still exist, back up/move your files in local, delete the old workspace , recreate a workspace, which should do the trick. – PatrickLu-MSFT Jun 16 '17 at 02:39
  • Hi huoxudong125, any update on this issue, did my reply helped to figure out it ? – PatrickLu-MSFT Jun 20 '17 at 17:26
  • @Patrick-MSFT I reinstall the vs2015 before you replied – huoxudong125 Jun 21 '17 at 05:30
  • Did the issue fixed? If still exists even after reinstall VS, then you could try to back up local files including pending changes, delete the old local workspace, recreated a new workspace, get files from server, add changes, finally check in the changes. Another way please refer my update reply. – PatrickLu-MSFT Jun 21 '17 at 05:45
  • I don't clear the old workspace, reopen it with Vs2015(reinstalled) I can check in. BTW Where the error is thrown, or which component may cause the error.@Patrick-MSFT – huoxudong125 Jun 21 '17 at 06:24
  • Thank you for your feedback huoxudong125. According to the error info in screenshot and your description `Pre Checkin is OK, But this time is not working now.` this generic a **database update error** which could occur for a wide range of reasons such as disk issues or cache issues. – PatrickLu-MSFT Jun 21 '17 at 06:30

1 Answers1

0

Try to clear TFS and VS cache. Make sure you have backed up the changes first.


Update

If above is not working, then you could try to backup local files including pending changes, delete the old workspace, recreated a new workspace, get files from server, add changes, finally check in the files.

Another way is unbind and rebind TFS source control binding of that special file, detail steps please refer this link: How can I completely remove TFS Bindings

PatrickLu-MSFT
  • 49,478
  • 5
  • 35
  • 62