Error FailDBInsert on checkout

PeterS · Post by **PeterS** » Mon Oct 01, 2007 6:33 am

Hi,
vault has been running well so far,
but now I experience an error '"FailDBInsert" on check-in
and "FailDBFault" on undo-check-out.

The Log file says:

# SourceGear Vault Server
----01.10.2007 10:01:40 bastian--DAVID(192.168.97.42)--SSL Disabled Login
----01.10.2007 11:04:59 sgvaultsystem--()--
System Started
Version 3.5.1.4786
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINNT\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain =
SGVault Working Directory = C:\WINNT\Temp
SGVault Server URL = http://server/VaultService
Identity = SERVER\ASPNET
----01.10.2007 11:08:50 bastian--DAVID(192.168.97.42)--SSL Disabled Login
----01.10.2007 11:09:47 bastian--DAVID(192.168.97.42)--SSL Disabled System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_tblcheckoutlists_tblfsobjectversions". The conflict occurred in database "sgvault", table "dbo.tblfsobjectversions", column 'objverid'.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
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.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
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)
----01.10.2007 11:09:47 bastian--DAVID(192.168.97.42)--SSL Disabled CheckOutFiles returned:FailDBInsert

We are running Vault Version 3.5.1
on a Windows 2000 Server
with database MS SQL 2005 Express

What to do?

lbauer · Post by **lbauer** » Mon Oct 01, 2007 8:36 am

Let's try this:

Close any open clients and remove the client side cache files:

CacheMember_CheckOutList
CacheMember_Repository
and CacheMember_LastStructureGetTime

details here:

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

Then restart IIS on the server machine.

Reopen your client and log in again.

Does this resolve the problem?

PeterS · Post by **PeterS** » Mon Oct 01, 2007 8:56 am

No,
I tried but, still the same problem.
Even deleting all cach files doesn't change anything.
Actually the same problem accures on all our computers.

lbauer · Post by **lbauer** » Mon Oct 01, 2007 9:36 am

Ok. We'll need more information.

Turn on server debug logging in the Vault Server log under Server options->Logging, attempt to reproduce the problem, and send us the entire server log. The log portion you posted only shows the checkout portion, not the undo checkout error.

Send the log to support at sourcegear.com ATTN Linda. Be sure to add a link to this post in your email.