Check In transaction fails

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

Moderator: SourceGear

Post Reply
kevinhanson
Posts: 33
Joined: Tue Mar 11, 2008 11:27 am
Location: Seattle, WA
Contact:
Contact kevinhanson

Check In transaction fails

Post by kevinhanson » Wed Mar 12, 2008 4:36 pm

And here I was thinking the worst was behind me. :)

I get the same behavior using the IDE, or the Vault Client. Here is the "message" log from the Client:

Code: Select all

[3/12/2008 3:17:36 PM] Preparing data to begin transaction
[3/12/2008 3:17:36 PM] Beginning transaction
[3/12/2008 3:17:36 PM]     Check in $/CondoCompare_2_0/condocompare_web/App_Code/SearchAutoComplete.cs
[3/12/2008 3:17:36 PM] Ending the transaction
[3/12/2008 3:17:36 PM] An error occurred while trying to end a transaction.
[3/12/2008 3:17:36 PM] Transaction failed
[3/12/2008 3:17:36 PM] Transaction failed

When I use the Client tool ON the server, I'm able to Get Latest without trouble. But when I choose a file (any file) and try to Check Out I get:

Code: Select all

A database error has occurred (FailDBInsert)
I didn't do anything special to the database outside of whatever occurred during Vault installation.

I've looked through this forum to see if anyone has already addressed this issue, but found nothing for this, specifically.

Thoughts?
Top
ian_sg
Posts: 787
Joined: Wed May 04, 2005 10:55 am
Location: SourceGear
Contact:
Contact ian_sg

Post by ian_sg » Thu Mar 13, 2008 8:45 am

What does your Vault server log say?
Ian Olsen
SourceGear
Top
kevinhanson
Posts: 33
Joined: Tue Mar 11, 2008 11:27 am
Location: Seattle, WA
Contact:
Contact kevinhanson

Post by kevinhanson » Thu Mar 13, 2008 8:50 am

Good morning, my new friend! :D

I was JUST about to post this. I suppose great minds think alike (although mine appears to be thinking much slower than most).

Here's a part of the log reflecting a single attempt to Check a file Out. I hope you find something in here that's useful:

Code: Select all

----3/13/2008 7:42:59 AM     Kevin--fe80::5efe:192.168.1.20%10(fe80::5efe:192.168.1.20%10)--SSL Disabled	System.Data.SqlClient.SqlException: Failed to load Msxml2.dll.
   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.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at VaultServiceSQL.VaultSqlSCC.CheckOutItems(VaultSqlConn conn, Int32 nUserID, Int32 nRepID, String strHostname, String strXml, String strComment, String strMiscInfo, HybridDictionary& hdResults)    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.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at VaultServiceSQL.VaultSqlSCC.CheckOutItems(VaultSqlConn conn, Int32 nUserID, Int32 nRepID, String strHostname, String strXml, String strComment, String strMiscInfo, HybridDictionary& hdResults)
----3/13/2008 7:42:59 AM     Kevin--fe80::5efe:192.168.1.20%10(fe80::5efe:192.168.1.20%10)--SSL Disabled	CheckOutFiles returned:FailDBInsert
The one thing that sticks out to me is the part about "Failed to load Msxml2.dll". Here's hoping this is just another one of those duh moments.
Top
ian_sg
Posts: 787
Joined: Wed May 04, 2005 10:55 am
Location: SourceGear
Contact:
Contact ian_sg

Post by ian_sg » Thu Mar 13, 2008 8:59 am

I haven't seen this before on Vista, but I have some idea what might be happening.

Is SQL Server 2005 on this same machine? Have you installed SP2 for SQL Server 2005?
Ian Olsen
SourceGear
Top
kevinhanson
Posts: 33
Joined: Tue Mar 11, 2008 11:27 am
Location: Seattle, WA
Contact:
Contact kevinhanson

Post by kevinhanson » Thu Mar 13, 2008 9:31 am

Hmmm.... not exactly sure about the Service Packs.

I inherited the machine with SQL Server 2005 Express installed.

I then installed SQL Server 2000 Developer Edition, but I'm certain I did not install any service packs after that.

I am now downloading SP4 for SQL Server 2000. Large file, will take a few more minutes. Stay tuned.
Top
ian_sg
Posts: 787
Joined: Wed May 04, 2005 10:55 am
Location: SourceGear
Contact:
Contact ian_sg

Post by ian_sg » Thu Mar 13, 2008 10:13 am

I'm not sure SQL Server 2000 is supported on Vista. It's likely you can make it work, but I'd recommend 2005+SP2 (any edition, including Express, will work). I'd bet installing that will also remedy the MSXML error you're seeing.

Otherwise, there's an MSXML package you're somehow lacking. I don't know exactly the right steps on Vista, but there is an older KB article here that will at least get you started.
Ian Olsen
SourceGear
Top
Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:
Contact Beth

Post by Beth » Thu Mar 13, 2008 10:31 am

We have that error mentioned in this article: Failed to load Msxml2.dll error on checkin

And another thread that may help: http://support.sourcegear.com/viewtopic.php?t=275

Definitely sounds like a service pack issue.
Top
kevinhanson
Posts: 33
Joined: Tue Mar 11, 2008 11:27 am
Location: Seattle, WA
Contact:
Contact kevinhanson

Post by kevinhanson » Thu Mar 13, 2008 12:15 pm

Ian & Beth,

Thank you both for your attempted help.

After repeated unsuccessful attempts to install SQL 2000 SP4 on the vista box, and repeated unsuccessful attempts to install just MSXML2 on the vista box, I have given up.

Likely, the act of installing SQL 2000 MSDE on that box, and the series of subsequent tweaks I've tried, has rendered that box a scrambled mess.

As I am unwilling to lose any more critical development time right now trying to get this working, I am going to have to postpone further attempts to get this set up.

I promise to come back to this in a few weeks. We'll get this darn thing setup properly on a fresh box then.

Thanks again for all your help! See you in April.
Kevin
Top
Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:
Contact Beth

Post by Beth » Thu Mar 13, 2008 1:18 pm

Microsoft says here that it won't support SQL 2000 on Vista: http://www.microsoft.com/sql/prodinfo/p ... vista.mspx. Someone mentions here that Vista won't let it install, http://betav.com/blog/billva/2006/08/sq ... orted.html, though another had a suggested work around.
Another user here claims to have it running with some problems: http://www.sqlservercentral.com/Forums/ ... 7-5-1.aspx.
Top
Post Reply

Return to “Support (Vault)”