Unable to Check-in (FailDBInsert)

dereksrd · Post by **dereksrd** » Thu Nov 03, 2005 4:21 pm

I am evaluating Vault as a source control provider for LabVIEW 8. But before I even try to use LabVIEW, I am trying with the Vault client.

I have my server on a separate pc and my client on my local pc. Here is the info on both:

Client Information
Vault Client Version: 3.1.4.3543
.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: 1022.07 MB
Time Zone: (GMT-05:00) Eastern Time (US & Canada)

Server Information
Vault Server Version: 3.1.4.3543
.Net Framework Version: 1.1.4322.2032
Operating System: Microsoft Windows 2000 Professional
Service Pack: 4.0
OS Version: 5.0.2195
Timezone: (GMT-05:00) Eastern Time (US & Canada)
SQL Version: Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4)

License Information
0 serial number(s):

I can connect to the default repository with no problems. When I try to add a simple readme.txt file into the root of the repository, I get this dialog:

> A database error has occurred (FailDBInsert)

I click Ok and get the next dialog:

> The Check In/Commit transaction failed. See the message pane for details.

So here are the contents of the pane:

>[11/3/2005 5:14:20 PM] Ending the transaction
[11/3/2005 5:15:17 PM] An error occurred while trying to end a transaction.
[11/3/2005 5:15:17 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)
[11/3/2005 5:15:17 PM] Transaction failed
[11/3/2005 5:15:17 PM] Transaction failed

Why can't I check anything in?

Thanks in advance!
Derek

dan · Post by **dan** » Thu Nov 03, 2005 4:34 pm

The first step would be to check the server log (at %windir%/temp/sgvault), which should give more info on what the database error is.

dereksrd · Post by **dereksrd** » Fri Nov 04, 2005 7:16 am

Great - I was wondering where the log was. So here's a quick session of logging in and trying to add the readme.txt to the repository:

<log>
----11/4/2005 8:10:58 AM admin--R0793-DPRICE(172.16.4.81)--SSL Disabled Login
----11/4/2005 8:11:24 AM admin--R0793-DPRICE(172.16.4.81)--SSL Disabled System.Data.SqlClient.SqlException: Failed to load Msxml2.dll.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.CreateBubbleFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, String strXml, HybridDictionary& hdBubbles) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.CreateBubbleFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, String strXml, HybridDictionary& hdBubbles)
----11/4/2005 8:11:24 AM admin--R0793-DPRICE(172.16.4.81)--SSL Disabled Could not create bubble folders: Error in the application. at VaultServiceSQL.VaultSqlSCC.CreateBubbleFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, String strXml, HybridDictionary& hdBubbles)
at VaultServiceAPILib.VaultServiceAPI.SaveRepository(VaultTransactionContainer txContainer, VaultRepository repOld, VaultRepository repNew)
----11/4/2005 8:11:24 AM admin--R0793-DPRICE(172.16.4.81)--SSL Disabled (63416c27-5d2e-47aa-bc29-a1ac99115b71) EndTx (Revision - 0) returned: FailDBInsert
----11/4/2005 8:11:24 AM admin--R0793-DPRICE(172.16.4.81)--SSL Disabled (63416c27-5d2e-47aa-bc29-a1ac99115b71) AddFile: $/README.TXT returned: FailDBInsert
</log>

There's an error loading "Msxml2.dll" and another about "bubble folders". Any ideas?

Thanks,
Derek

dan · Post by **dan** » Fri Nov 04, 2005 8:28 am

Ah, good - this is is a known problem. MSXML 2.6 is not redistributed with SQL Server MSDE SP3 or SP3a, so you have to download it from here http://support.microsoft.com/default.as ... -us;823490 to get up and running.

dereksrd · Post by **dereksrd** » Fri Nov 04, 2005 9:57 am

That was it! Now off to test the LabVIEW 8 integration with Vault. I'll keep you posted...

Thanks again,
Derek