Check out failed for ...

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
CCericola
Posts: 9
Joined: Wed Dec 26, 2007 3:39 pm

Check out failed for ...

Post by CCericola » Mon May 12, 2008 1:07 pm

I keep getting a "Check out failed for" certain files within my project. It only seems to affect certain files.

I've tried deleting the project from source control and readding it, deleting all my cache files, and even checking the file in from the admin control panel but it does not seem to correct the error.

Here is output from the log(in debug mode):

----5/12/2008 3:02:51 PM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#releaselistitem__303740BF'. Cannot insert duplicate key in object '#releaselistitems___________________________________________________________________________________________________00010001C555'.
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/12/2008 3:02:51 PM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/12/2008 3:02:51 PM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/12/2008 3:02:51 PM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/12/2008 3:02:51 PM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled UndoCheckout returned: FailDBFault

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

Post by lbauer » Mon May 12, 2008 3:01 pm

The error message indicates an undo checkout operation is failing. This can happen if you are undoing a checkout from a different machine.

Try this sequence:

First, undo the checkout from the Vault admin web client.

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

Next, close any open clients and delete the client-side cache file. Restart IIS. This will clear the server cache.

Re-open your client and see if the problem persists.
Linda Bauer
SourceGear
Technical Support Manager

CCericola
Posts: 9
Joined: Wed Dec 26, 2007 3:39 pm

Post by CCericola » Tue May 13, 2008 7:03 am

Thank for your reply, Linda however the same symptoms are still occuring.

----5/13/2008 9:02:28 AM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled DB: ReleaseLocks started.
----5/13/2008 9:02:28 AM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#releaselistitem__6EC019CB'. Cannot insert duplicate key in object '#releaselistitems___________________________________________________________________________________________________00010001C84C'.
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/13/2008 9:02:28 AM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled DB: ReleaseLocks finished.
----5/13/2008 9:02:28 AM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled SQL transaction 49998812 successfully rolled back.
----5/13/2008 9:02:28 AM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/13/2008 9:02:28 AM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/13/2008 9:02:28 AM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----5/13/2008 9:02:28 AM ccericola--IT-CCERICOLA-LT(192.168.150.79)--SSL Disabled UndoCheckout returned: FailDBFault

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

Post by lbauer » Wed May 14, 2008 9:16 am

What version of Vault are you using?

What specific files are generating this error?

How are you checking in the files -- through Visual Studio (if so, what version), the GUI Client, CLC?
Linda Bauer
SourceGear
Technical Support Manager

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

Post by lbauer » Thu May 15, 2008 9:25 am

We'd like to investigate this further. Could you e-mail in support at SourceGear.com Attn: Linda, and we'll send you some queries to check the status of the database.
Linda Bauer
SourceGear
Technical Support Manager

CCericola
Posts: 9
Joined: Wed Dec 26, 2007 3:39 pm

Post by CCericola » Thu May 15, 2008 2:52 pm

lbauer wrote:We'd like to investigate this further. Could you e-mail in support at SourceGear.com Attn: Linda, and we'll send you some queries to check the status of the database.
Linda,

I meant to post early but this has been a busy week. I've upgraded to using the enhanced client with VS2008 and it seems to have fixed the issue.

However, if you would like to take alook at this still please let me know and I will send over the email.

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

Post by lbauer » Thu May 15, 2008 9:01 pm

If the problem has corrected itself, there may be nothing in the database to investigate at this point. It is related to undo checkout, and there may have been inconsistent checkout entries that no longer exist in the database.

Please do let us know if you encounter this again in the future, and an undo checkout from the Admin Client does not resolve it.
Linda Bauer
SourceGear
Technical Support Manager

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

Post by mshe » Mon May 26, 2008 12:24 am

Hi Linda,

I'm having the same issue! I'm using the classic client in VS.NET 2008 ... is there an incompatiblity?

I posted my log in the "Gold Forum".

Thanks.

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

Post by lbauer » Fri May 30, 2008 9:31 am

Linda Bauer
SourceGear
Technical Support Manager

Post Reply