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

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

Moderator: SourceGear

Locked
mshe
Posts: 38
Joined: Tue Nov 29, 2005 4:18 pm

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

Post by mshe » 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?

mshe
Posts: 38
Joined: Tue Nov 29, 2005 4:18 pm

Post by mshe » 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?

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » 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

Locked