Commit Error During Transaction

Randyp · Post by **Randyp** » Sun Oct 09, 2005 2:15 pm

Hi all,

I'm a former SOS-CE user that just installed Vault (3.1.2) today on Win 2000 Server (SP5) and the client on XP SP2. Installation appeared to be successful. We also installed "MSDE Release A" on the server as the database, if that matters.

Problem: We were able to connect from client to server and select a repository, but on attempting to add anything to the repository, we're getting this sequence of errors:

[10/9/2005 4:01:17 PM] Beginning transaction
[10/9/2005 4:01:17 PM] Create folder $/CodeBlock
[10/9/2005 4:01:17 PM] Add $/CodeBlock/codeblck7.PRG
[10/9/2005 4:01:18 PM] Add $/CodeBlock/l7codeblock.prg
... more Add lines here
[10/9/2005 4:01:20 PM] Ending the transaction
[10/9/2005 4:01:26 PM] An error occurred while trying to end a transaction.
[10/9/2005 4:01:26 PM] 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)
[10/9/2005 4:01:26 PM] Transaction failed
[10/9/2005 4:01:27 PM] Transaction failed

We're not sure how to interpret this error or waht to try next.

Thanks for any help!

lbauer · Post by **lbauer** » Sun Oct 09, 2005 6:21 pm

We'd like to see a copy of the Vault Server log. It's sgvault.log, from the %windir%\temp\sgvault directory. Post it here or email linda at sourcegear.com.

randyp21 · Post by **randyp21** » Mon Oct 10, 2005 8:04 am

These are the only 2 lines in the file. (I obscure the user ID and IP.)

# SourceGear Vault Server
----10/9/2005 2:05:29 PM myuserid--111.111.111.111(111.111.111.111)--SSL Disabled Logout

lbauer · Post by **lbauer** » Mon Oct 10, 2005 8:42 am

Not much to go on. Is there another log file? Vault archives logs and the archived log has numbers in the name.

Meanwhile, see if any tips here help:
http://support.sourcegear.com/viewtopic.php?t=735

randyp21 · Post by **randyp21** » Mon Oct 10, 2005 9:14 am

There is another log file, but it has only the header line:

# SourceGear Vault Server

The Message box that pops up when the error occurs says (approximately):

A database error has occurred - failed dbiInsert.

I read the article you referenced and have this input:

- chunked encoding is OFF
- all permissions for ASPNET verified on server
- tried turning off Symantec AV protection -- no difference
- no personal firewall running

lbauer · Post by **lbauer** » Mon Oct 10, 2005 9:29 am

Looks like a database problem. Send me the vault_install.log file so I can see your configuration. It should be in your user's temp directory (%temp%). Email it to Linda at SourceGear.com

randyp21 · Post by **randyp21** » Mon Oct 10, 2005 9:30 am

Interesting. I did this again and suddenly entries are appearing in the log. The same failures earlier did not result in log entries.

Linda, I'm emailing the log file to you separately, so I don't need to obfuscate private info here.

Snippets include:

System.Data.SqlClient.SqlException: Failed to load Msxml2.dll.
I looked and Msxml3.dll is on the server, but not 2. This a problem?

Could not create bubble folders: Error in the application. at VaultServiceSQL.VaultSqlSCC.CreateBubbleFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, String strXml, HybridDictionary& hdBubbles)

-- Randy

lbauer · Post by **lbauer** » Mon Oct 10, 2005 9:43 am

I looked and Msxml3.dll is on the server, but not 2. This a problem?

Yes.

This is a known issue. See this forum post for a fix:

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

randyp21 · Post by **randyp21** » Mon Oct 10, 2005 9:52 am

Thanks. That appears to fix it. (I had figured it couldn't hurt to add that component and had just found the same KB article and initiated the change.)

-- Randy