Check out failed for ... : You already have the file checked

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear


Posts: 38
Joined: Tue Nov 29, 2005 4:18 pm
PostPosted: Fri May 23, 2008 10:50 pm
Hello I'm getting the following error alot:

Check out failed for... You already have the file checked out.

This seems to happen quite a bit - happens to several files on my computer, include a new project I just created not too long ago.

This occurs in both VS.NET 2008 and VS.NET 2005.

Running Vault 4.1 - any type of logs I can upload to help debug this issue?

Posts: 38
Joined: Tue Nov 29, 2005 4:18 pm
PostPosted: Fri May 23, 2008 11:05 pm
I did find some errors in my server log:

Code: Select all
----5/23/2008 10:34:56 PM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   Login
----5/24/2008 12:48:37 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#releaselistitem__3BEAF58B'. Cannot insert duplicate key in object '#releaselistitems___________________________________________________________________________________________________00010003A133'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at VaultServiceSQL.VaultSqlSCC.ReleaseLocks(VaultSqlConn conn, Int32 nUserID, String strHostname, Int32 nRepID, String strXml, Boolean bUseUserID)    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at VaultServiceSQL.VaultSqlSCC.ReleaseLocks(VaultSqlConn conn, Int32 nUserID, String strHostname, Int32 nRepID, String strXml, Boolean bUseUserID)
----5/24/2008 12:48:37 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/24/2008 12:48:37 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/24/2008 12:48:37 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/24/2008 12:48:37 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   UndoCheckout returned: FailDBFault
----5/24/2008 12:48:45 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#releaselistitem__3FBB866F'. Cannot insert duplicate key in object '#releaselistitems___________________________________________________________________________________________________00010003A133'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at VaultServiceSQL.VaultSqlSCC.ReleaseLocks(VaultSqlConn conn, Int32 nUserID, String strHostname, Int32 nRepID, String strXml, Boolean bUseUserID)    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at VaultServiceSQL.VaultSqlSCC.ReleaseLocks(VaultSqlConn conn, Int32 nUserID, String strHostname, Int32 nRepID, String strXml, Boolean bUseUserID)
----5/24/2008 12:48:45 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/24/2008 12:48:45 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/24/2008 12:48:45 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/24/2008 12:48:45 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   UndoCheckout returned: FailDBFault
----5/24/2008 12:53:42 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#releaselistitem__2A8B5F5F'. Cannot insert duplicate key in object '#releaselistitems___________________________________________________________________________________________________00010003A133'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at VaultServiceSQL.VaultSqlSCC.ReleaseLocks(VaultSqlConn conn, Int32 nUserID, String strHostname, Int32 nRepID, String strXml, Boolean bUseUserID)    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at VaultServiceSQL.VaultSqlSCC.ReleaseLocks(VaultSqlConn conn, Int32 nUserID, String strHostname, Int32 nRepID, String strXml, Boolean bUseUserID)
----5/24/2008 12:53:42 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/24/2008 12:53:42 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/24/2008 12:53:42 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/24/2008 12:53:42 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   UndoCheckout returned: FailDBFault
----5/24/2008 12:54:03 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   Logout
----5/24/2008 12:54:14 AM    mshe--CPE000f66c58f6b-CM000e5cdfdf76.cpe.net.cable.rogers.com(99.237.237.96)--SSL Enabled   Login


Any ideas how to fix?

Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear
PostPosted: Tue May 27, 2008 10:08 am
The first thing I would do is close any open clients, clear the CacheMember_CheckOutList from the client-side cache file:


Then, undo the checkouts from the Vault Admin Client.

This setting is in the Admin Web Client under Source Control Repositories->(Repository name)-> undo checkout

Restart IIS, and then reopen your clients.

Let me know if you still run into the error.

If you do, let us know if this is reproducible, or if there are certain circumstances that leads up to the error
Linda Bauer
SourceGear
Technical Support Manager

Return to Gold Support (Vault) -- Read-only

Who is online

Users browsing this forum: No registered users and 3 guests

cron