Delete problem -> transaction failed.

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

Moderator: SourceGear

Post Reply
hongjie.shi
Posts: 3
Joined: Thu Apr 10, 2008 12:50 am

Delete problem -> transaction failed.

Post by hongjie.shi » Thu Apr 10, 2008 1:16 am

Vault Advanced Client 3.5.2
Value Server 3.5.2
SQL Server 2000 SP4

We have just recently moved the data file to another computer, and I have noticed a problem while I delete some files.

I installed SQL server 2000 SP4 on a new installed, clean computer. And installed Vault Server 3.5.2 version. Then copy sgvault.mdf file from original serve to this new installed computer. Just use this .mdf file to restore my code database. Fortunately, it worked.

I tried some operations, like add files, check out and check in, all work fine except deleting file.

When I tried to delete some files, the Vault client showed me this message:
[2008-4-10 14:28:54] An error occurred while trying to end a transaction.
[2008-4-10 14:28:54] Transaction failed
[2008-4-10 14:28:54] Item $/Project/test.doc caused the transaction to fail: Deletion Failed.
[2008-4-10 14:28:54] Transaction failed.

Whether the files were added before or after the database was restored.

What should I do?[/b]
Top
lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Thu Apr 10, 2008 7:38 am

We'd like to see a copy of the Vault server log for more information. It's sgvault.log in %windir%\temp\sgvault on the Vault Server machine.

Email it to support at sourcegear.com ATTN: Linda
Linda Bauer
SourceGear
Technical Support Manager
Top
hongjie.shi
Posts: 3
Joined: Thu Apr 10, 2008 12:50 am

Post by hongjie.shi » Thu Apr 10, 2008 6:59 pm

lbauer wrote:We'd like to see a copy of the Vault server log for more information. It's sgvault.log in %windir%\temp\sgvault on the Vault Server machine.

Email it to support at sourcegear.com ATTN: Linda

Here is some information from sgvault.log file.

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, VaultDateTime dtMod, String strShareObjIDPathXml, UInt16 nSystemDelete, Int64& nDeletionID) 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, VaultDateTime dtMod, String strShareObjIDPathXml, UInt16 nSystemDelete, Int64& nDeletionID)
----4/10/2008 10:51:56 AM xianfeng.yan--axa-xianfeng.acn.advantech.corp(172.21.73.52)--SSL Disabled (34dfa557-3636-44a7-bf7d-19c4daff4597) EndTx (Revision - 0) returned: FailDBDelete
----4/10/2008 10:51:56 AM xianfeng.yan--axa-xianfeng.acn.advantech.corp(172.21.73.52)--SSL Disabled (34dfa557-3636-44a7-bf7d-19c4daff4597) Delete: $/Project/DAQ/Driver/PCM3813P_Dev/WinCE/CE_DLL/res/PCM-3813P.bmp returned: FailDBDelete
----4/10/2008 10:51:56 AM xianfeng.yan--axa-xianfeng.acn.advantech.corp(172.21.73.52)--SSL Disabled (34dfa557-3636-44a7-bf7d-19c4daff4597) Delete: $/Project/DAQ/Driver/PCM3813P_Dev/WinCE/CE_DLL/res/PCM-3813.bmp returned: FailDBDelete
----4/10/2008 10:53:38 AM lin_lei--172.18.6.131(172.18.6.131)--SSL Disabled Login failed: FailNotValidLogin
----4/10/2008 10:53:48 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled Login
----4/10/2008 10:54:35 AM admin--axardserver.ACN.ADVANTECH.CORP(172.21.73.3)--SSL Disabled Logout
----4/10/2008 10:55:12 AM admin--172.18.6.131(172.18.6.131)--SSL Disabled Logout
----4/10/2008 10:55:37 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled 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, VaultDateTime dtMod, String strShareObjIDPathXml, UInt16 nSystemDelete, Int64& nDeletionID) 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, VaultDateTime dtMod, String strShareObjIDPathXml, UInt16 nSystemDelete, Int64& nDeletionID)
----4/10/2008 10:55:37 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled (1793eb07-5e1e-4534-8275-f501ff0b2c2d) EndTx (Revision - 0) returned: FailDBDelete
----4/10/2008 10:55:37 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled (1793eb07-5e1e-4534-8275-f501ff0b2c2d) Delete: $/Test for jichao/Test001/001_v1.txt returned: FailDBDelete
----4/10/2008 10:55:57 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled 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, VaultDateTime dtMod, String strShareObjIDPathXml, UInt16 nSystemDelete, Int64& nDeletionID) 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, VaultDateTime dtMod, String strShareObjIDPathXml, UInt16 nSystemDelete, Int64& nDeletionID)
----4/10/2008 10:55:57 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled (18addeba-11d4-4c25-977d-5884039d4501) EndTx (Revision - 0) returned: FailDBDelete
----4/10/2008 10:55:57 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled (18addeba-11d4-4c25-977d-5884039d4501) Delete: $/Test for jichao/test1/001.txt returned: FailDBDelete
----4/10/2008 10:56:21 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled 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, VaultDateTime dtMod, String strShareObjIDPathXml, UInt16 nSystemDelete, Int64& nDeletionID) 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, VaultDateTime dtMod, String strShareObjIDPathXml, UInt16 nSystemDelete, Int64& nDeletionID)
----4/10/2008 10:56:21 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled (d16159c8-a675-40ad-be13-bf71d9e3de37) EndTx (Revision - 0) returned: FailDBDelete
----4/10/2008 10:56:21 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled (d16159c8-a675-40ad-be13-bf71d9e3de37) Delete: $/Test for jichao/test1/test003/file003.txt returned: FailDBDelete
----4/10/2008 10:57:47 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled 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, VaultDateTime dtMod, String strShareObjIDPathXml, UInt16 nSystemDelete, Int64& nDeletionID) 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, VaultDateTime dtMod, String strShareObjIDPathXml, UInt16 nSystemDelete, Int64& nDeletionID)
----4/10/2008 10:57:47 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled (a3e4ef75-ada6-46c5-bd90-ad1520ca6dc4) EndTx (Revision - 0) returned: FailDBDelete
----4/10/2008 10:57:47 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled (a3e4ef75-ada6-46c5-bd90-ad1520ca6dc4) Delete: $/Project/Application/PV6000/Windows/SourceCode_DEV/NVR/SourceCode/Bin/Debug/playm4.dll returned: FailDBDelete
----4/10/2008 10:57:56 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled Logout
----4/10/2008 10:58:05 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled Login
----4/10/2008 10:58:26 AM admin--172.18.6.131(172.18.6.131)--SSL Disabled Login
----4/10/2008 10:58:49 AM yu.yan--RD-YUYAN(172.21.73.227)--SSL Disabled Login
----4/10/2008 11:00:09 AM axalin.lei--172.18.6.131(172.18.6.131)--SSL Disabled

Thanks for your kindness.
Top
ian_sg
Posts: 787
Joined: Wed May 04, 2005 10:55 am
Location: SourceGear
Contact:
Contact ian_sg

Post by ian_sg » Thu Apr 10, 2008 9:24 pm

It looks like the ARITHABORT setting is off. It needs to be on. Off is the default, and when moving a database from one machine to another where the installer has already been run, this is known to happen.

There's a knowledge base article here, which includes steps to fix it.
Ian Olsen
SourceGear
Top
hongjie.shi
Posts: 3
Joined: Thu Apr 10, 2008 12:50 am

Delete problem -> transaction failed. (succeeded)

Post by hongjie.shi » Sun Apr 13, 2008 7:01 pm

ian_sg wrote:It looks like the ARITHABORT setting is off. It needs to be on. Off is the default, and when moving a database from one machine to another where the installer has already been run, this is known to happen.

There's a knowledge base article here, which includes steps to fix it.
Thanks very much for your kindness.
We have solved this problem by following your information.
Our problem was answered fastly, many thanks to you, thanks very much.
Top
ian_sg
Posts: 787
Joined: Wed May 04, 2005 10:55 am
Location: SourceGear
Contact:
Contact ian_sg

Post by ian_sg » Sun Apr 13, 2008 9:28 pm

Glad to help. Let us know if there's anything else we can do.
Ian Olsen
SourceGear
Top
Post Reply

Return to “Support (Vault)”