Check out failed for ...

CCericola · 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 · 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.

CCericola · 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 · 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?

lbauer · 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.

CCericola · 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 · 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.

mshe · 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 · Post by **lbauer** » Fri May 30, 2008 9:31 am

Gold forum post:

http://support.sourcegear.com/viewtopic.php?t=10318