Various problems after file Move operations

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

Moderator: SourceGear

Locked
rab
Posts: 18
Joined: Tue Apr 12, 2005 5:03 pm
Location: Australia

Various problems after file Move operations

Post by rab » Mon May 12, 2008 5:18 pm

We are using Vault V4.1.1. After some recent file moves my engineers are having trouble doing mainly "Get Latest" and other operations.

Here is some server log trace from and undo checkout:

----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled ASMX: UndoCheckOut started.
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled DB: GetUserRepositoryLastChange started.
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled DB: GetUserRepositoryLastChange finished.
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled Beginning SQL transaction 61938265
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled DB: LockCheckoutList started.
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled DB: CreateDBLockObject started.
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled DB: CreateDBLockObject finished.
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled DB: LockCheckoutList finished.
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled DB: ReleaseLocks started.
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled System.Data.SqlClient.SqlException: Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails.
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)
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled DB: ReleaseLocks finished.
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled SQL transaction 61938265 successfully rolled back.
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled VaultLib.VaultRequestUndoCheckOut returned: FailDBFault
----13/05/2008 9:09:43 AM bshu--BSHU-NB(172.24.252.188)--SSL Disabled UndoCheckout returned: FailDBFault

The most common problem is not being able to do a Get Latest of the folder parent of the files that were moved. Our "work around" is the do a Checkout followed by and "Undo Checkout" when Get Latest fails, once this has been done once the engineer can normally go on with no furtehr problem. However now another engineer has had the Undo Checkout step fail, this is what I have pasted in above.

How can we fix this?

Regards,
Rob Barnes

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Post by Beth » Tue May 13, 2008 7:45 am

Are you performing the moves inside of Vault or inside of Visual Studio?
Are the moves being committed before the Get Latest?

rab
Posts: 18
Joined: Tue Apr 12, 2005 5:03 pm
Location: Australia

Various problems after file Move operations

Post by rab » Tue May 13, 2008 2:40 pm

Beth wrote:Are you performing the moves inside of Vault or inside of Visual Studio?
Are the moves being committed before the Get Latest?
All operations inside of Vault. We do not use Visual Studio integration at all.

Yes, the moves are being comitted first (days or weeks ago).

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Post by Beth » Wed May 14, 2008 2:42 pm

Can you open your Vault client, connect to a repository, then go to Help - Technical Support and copy the information from there to here? That will tell me more about your environment. I don't need the licensing information at the bottom.

rab
Posts: 18
Joined: Tue Apr 12, 2005 5:03 pm
Location: Australia

Post by rab » Wed May 14, 2008 2:47 pm

Beth wrote:Can you open your Vault client, connect to a repository, then go to Help - Technical Support and copy the information from there to here? That will tell me more about your environment. I don't need the licensing information at the bottom.
Client Information
Vault Client Version: 4.1.1.18060
.Net Framework Version: 2.0.50727.1433
Operating System: Microsoft Windows XP Professional
Service Pack: 2.0
OS Version: 5.1.2600
Total Physical Memory: 1.99 GB
Time Zone: (GMT+10:00) Brisbane

Server Information
Vault Server Version: 4.1.1.18060
.Net Framework Version: 2.0.50727.1433
Operating System: Microsoft(R) Windows(R) Server 2003, Standard Edition
Service Pack: 2.0
OS Version: 5.2.3790
Timezone: (GMT+10:00) Brisbane
SQL Version: Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Post by Beth » Wed May 14, 2008 2:51 pm

After that, can you send me a document with some screenshots showing how you make this happen? I can't seem to reproduce it. You can send that to support at sourcegear.com (attn: Beth) with a link to this thread.

Locked