sgvault.log: Cannot insert duplicate key in object

jschuit · Post by **jschuit** » Mon Jan 24, 2005 3:10 pm

I'm not sure what to do about this one:

We are getting an error when trying to perform a folder share from /Project1/SomeFiles to /Project2. Initially the files within SomeFiles were file shared into /Project2/SomeFiles. They were then shared into /Project1_A/SomeFiles and then branched. (for completeness) Those branched files were then shared from /Project1_A/SomeFiles to /Project2_A/SomeFiles. The files were deleted from /Project2/SomeFiles, and then the attempt to make the folder share was made with this resulting error.

Actual text from logfile: Violation of PRIMARY KEY constraint 'pk_tblfsobjectshares'. Cannot insert duplicate key in object 'tblfsobjectshares'.
The statement has been terminated.

Hans Olav Nymand · Post by **Hans Olav Nymand** » Tue Jan 25, 2005 7:56 am

Hi,

I got the same problem today.

What I am trying to do:
$\Project1\FolderA\FolderB is a shared folder from $\Project2\Shared\FolderB.
I now delete $\Project1\FolderA\FolderB.
Then I go to a third folder, $\Project3\Shared\FolderB, which I now try to shared to the location $\Project1\FolderA\ - and when I try to commit that share I get the problem.

My serverlog contains these entries:
----1-25-2005 14:40:43 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.165)--SSL Disabled Login
----1-25-2005 14:41:09 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.165)--SSL Disabled Violation of PRIMARY KEY constraint 'pk_tblfsobjectshares'. Cannot insert duplicate key in object 'tblfsobjectshares'.
The statement has been terminated.
----1-25-2005 14:41:09 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.165)--SSL Disabled VaultLib.VaultResponseItem returned: FailDBFault
----1-25-2005 14:41:09 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.165)--SSL Disabled EndTxFailDBFault

Regards,
Hans Olav Nymand
Prolog Development Center A/S

Post by **jeremy_sg** » Tue Jan 25, 2005 8:52 am

Vault version 3.0.1 should have fixed this problem. Are you both running 3.0.1?

[Edit -- I said 3.0.1, but I should have said 3.0.2]

Hans Olav Nymand · Post by **Hans Olav Nymand** » Tue Jan 25, 2005 8:56 am

Well, I' not - only 3.0.0. I'll download and try 3.0.1 at once.

Thanx

Post by **jclausius** » Tue Jan 25, 2005 9:02 am

Is SomeFiles Project1 the same as the deleted SomeFiles Project2? If so, you can simply undelete the SomeFiles in Project2.

Also, a bug similar to this scenario described above (sharing a folder / deleting the share / re-sharing the folder )was fixed in Vault 3.0.2. Upgrading to Vault 3.0.2 should also allow the share to succeed.

Post by **jclausius** » Tue Jan 25, 2005 9:12 am

I should note, Vault 3.0.2 can be found in the Vault Downloads section http://www.sourcegear.com/vault/downloads.html

jschuit · Post by **jschuit** » Tue Jan 25, 2005 1:13 pm

Yeah, sorry... forgot to mention we're running v3.0.0. I'll try to get 3.0.2 rolled out as soon as possible to see if it fixes the issue.

SourceGear Support

sgvault.log: Cannot insert duplicate key in object

sgvault.log: Cannot insert duplicate key in object

Same problem