sgvault Database Insert Error

tvesper · Post by **tvesper** » Mon Feb 18, 2008 11:15 am

We have recently begun receiving the following error when trying to check in files to Vault:

"A database error has occurred(FailDBInsert)"

When I go to the vault log it has the following message.

"Violation of PRIMARY KEY constraint 'pk_tblfsobjectversions'. Cannot insert duplicate key in object 'tblfsobjectversions'"

Can anyone tell me what is going on and how to correct this error?

Beth · Post by **Beth** » Mon Feb 18, 2008 3:36 pm

Can you tell me the version of Vault you are on?

Have you upgraded recently or made any large changes?

Is this happening for everyone?

Is this error occurring in the Vault GUI or in VS with the IDE integration?

tvesper · Post by **tvesper** » Tue Feb 19, 2008 12:20 pm

Version 2.0.1(2137)

We have made no recent changes to Vault or SQL Server.

Yes, it is happening to everyone.

It is happening in the GUI.

Thanks for your help!

Beth · Post by **Beth** » Tue Feb 19, 2008 1:11 pm

Can you tell me what .NET version(s) you have on your server?

Also, can you open your Vault - GUI, connect to a repository, and then go to Help - Technical Support and copy the environment information from there and post it?

tvesper · Post by **tvesper** » Wed Feb 20, 2008 12:29 pm

Microsoft .NET Framework SDK v1.1

----------------------------------------------------------------------------------
Client Information
Vault Client Version: 2.0.1.2137
Operating System: Microsoft(R) Windows(R) Server 2003, Enterprise Edition
Service Pack: 1.0
OS Version: 5.2.3790
Total Physical Memory: 3.62 GB
Time Zone: (GMT-06:00) Central Time (US & Canada)

Server Information
Vault Server Version: 2.0.1.2137
Operating System: Microsoft(R) Windows(R) Server 2003, Enterprise Edition
Service Pack: 1.0
OS Version: 5.2.3790
Timezone: (GMT-06:00) Central Time (US & Canada)
SQL Version: Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Beth · Post by **Beth** » Thu Feb 21, 2008 1:26 pm

I think this one may need to be looked at closer. Can you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread?

Beth · Post by **Beth** » Wed Mar 05, 2008 6:15 pm

I had replied to your original email, but received no response back. Are you receiving the emails ok?