How can I make deletion works?

[fenixchen]

I can check out and check in files correctly, but when I want to delete some files from vault, It always failed and product following messages:

[2009-7-20 10:44:03] Preparing data to begin transaction
[2009-7-20 10:44:03] Beginning transaction
[2009-7-20 10:44:03] Delete $/AAA.dll
[2009-7-20 10:44:03] Ending the transaction
[2009-7-20 10:44:04] Transaction failed
[2009-7-20 10:44:03] An error occurred while trying to end a transaction.
[2009-7-20 10:44:03] An exception was encountered during the transaction. Exception: Exception of type System.Exception was thrown. at VaultClientOperationsLib.ClientInstance.Commit(ChangeSetItemColl givenItems, Boolean keepCheckedOut, Boolean removeLocalCopy, Boolean bIsImport, DateTime dateImport, Int32 nUserIDImport, Int64& nRevID)
[2009-7-20 10:44:03] Transaction failed
[2009-7-20 10:44:03] Item $/AAA.dll caused the transaction to fail: Deletion Failed.

Does any one can help me resolved it thanks a lot.
BTW, when i share a file and commit, the same message appears and action failed.

Here is my version information.

Client Information
Vault Client Version: 3.1.5.3546
.Net Framework Version: 1.1.4322.2032
Operating System: Microsoft Windows XP Professional
Service Pack: 2.0
OS Version: 5.1.2600
Total Physical Memory: 1.99 GB
Time Zone: (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi

Server Information
Vault Server Version: 3.1.5.3546
.Net Framework Version: 1.1.4322.2407
Operating System: Microsoft(R) Windows(R) Server 2003, Enterprise Edition
Service Pack: 2.0
OS Version: 5.2.3790
Timezone: (GMT+08:00) 北京，重庆，香港特别行政区，乌鲁木齐
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]

Can you look in your Vault Server Log for any errors that occur at the same time as when you perform a deletion or share? Could you post either the log (you can delete it when we're done) or the errors? If you prefer, you can also email the log to support at sourcegear.com (attn: Beth) with a link to this forum thread.

[fenixchen]

Hi Dear Beth,
Thanks a lot for your help, here is my log after a failed deletion action.

----2009-7-21 9:19:06 abc-abc.hello.com(172.16.50.63)--SSL Enabled Attempting to acquire repository lock.
----2009-7-21 9:19:06 abc-abc.hello.com(172.16.50.63)--SSL Enabled Acquired repository lock.
----2009-7-21 9:19:06 abc-abc.hello.com(172.16.50.63)--SSL Enabled TreeManager Signal - Tx Begin - CacheLockId:206870
----2009-7-21 9:19:06 abc-abc.hello.com(172.16.50.63)--SSL Enabled TreeManager: A transaction is pending, but it belongs to the current user. Returning cached tree, revID 81952
----2009-7-21 9:19:06 abc-abc.hello.com(172.16.50.63)--SSL Enabled System.Data.SqlClient.SqlException: UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.DeleteFromDB(VaultSqlConn conn, Int32 nRepID, Int64 nObjID, Int64 nObjVerID, Int64 nOwnerFolderID, Int64 nTxID, Int32 nTxItem, String strItemPath, String strComment, DateTime dtMod, String strShareObjIDPathXml) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.DeleteFromDB(VaultSqlConn conn, Int32 nRepID, Int64 nObjID, Int64 nObjVerID, Int64 nOwnerFolderID, Int64 nTxID, Int32 nTxItem, String strItemPath, String strComment, DateTime dtMod, String strShareObjIDPathXml)
----2009-7-21 9:19:06 abc-abc.hello.com(172.16.50.63)--SSL Enabled EndTx(): Failed commit changes for TxID 81953
----2009-7-21 9:19:06 abc-abc.hello.com(172.16.50.63)--SSL Enabled TreeManager Signal - Tx End - TxID:81953 CacheLockId:206870 RepID:1
----2009-7-21 9:19:06 abc-abc.hello.com(172.16.50.63)--SSL Enabled (4ab15983-9269-4ea4-8b29-7af979a86db6) EndTx (Revision - 0) returned: FailDBDelete
----2009-7-21 9:19:06 abc-abc.hello.com(172.16.50.63)--SSL Enabled (4ab15983-9269-4ea4-8b29-7af979a86db6) Delete: $/HiDTV/TFCSDK/BinSX/NewColorManagement.dll returned: FailDBDelete
----2009-7-21 9:19:11 abc-abc.hello.com(172.16.50.63)--SSL Enabled Getting repository Structure-> Rep ID: 1 Base: 81952 Target: -1
----2009-7-21 9:19:11 abc-abc.hello.com(172.16.50.63)--SSL Enabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 81952
----2009-7-21 9:19:11 abc-abc.hello.com(172.16.50.63)--SSL Enabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:20 RepID:1 Base:81952 Target:81952 Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff.
----2009-7-21 9:19:11 abc-abc.hello.com(172.16.50.63)--SSL Enabled GetRepositoryStructure returned: Success
----2009-7-21 9:19:11 abc-abc.hello.com(172.16.50.63)--SSL Enabled Getting list of checkout changes.
----2009-7-21 9:19:11 abc-abc.hello.com(172.16.50.63)--SSL Enabled GetCheckOutListChanges returned: Success
----2009-7-21 9:19:27 Jerryjie--jane-f28a5e1203(172.16.50.94)--SSL Enabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 81952
----2009-7-21 9:19:31 abc-abc.hello.com(172.16.50.63)--SSL Enabled Getting repository Structure-> Rep ID: 1 Base: 81952 Target: -1
----2009-7-21 9:19:31 abc-abc.hello.com(172.16.50.63)--SSL Enabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 81952
----2009-7-21 9:19:31 abc-abc.hello.com(172.16.50.63)--SSL Enabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:20 RepID:1 Base:81952 Target:81952 Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff.
----2009-7-21 9:19:31 abc-abc.hello.com(172.16.50.63)--SSL Enabled GetRepositoryStructure returned: Success
----2009-7-21 9:19:31 abc-abc.hello.com(172.16.50.63)--SSL Enabled Getting list of checkout changes.
----2009-7-21 9:19:31 abc-abc.hello.com(172.16.50.63)--SSL Enabled GetCheckOutListChanges returned: Success

[Beth]

Back up your database and then go to item number 2 in this KB article: Vault SQL Database Options. That will have instructions on what to do with arithabort. Then let me know your results.