Sharing Problem

kasti · Post by **kasti** » Mon Sep 20, 2004 1:05 am

Hi there,

I am having a problem with sharing a library into a project. I get the following error: "A database error has occured (FailDBFault)".

In the server log I get (sensitive info X'ed out):

----9/20/2004 7:39:04 AM XXXXXXX--XXXXXXX--SSL Disabled
Violation of PRIMARY KEY constraint 'pk_tblfsobjectshares'. Cannot insert duplicate key in object 'tblfsobjectshares'.
The statement has been terminated.
----9/20/2004 7:39:04 AM XXXXXXX--XXXXXXX--SSL Disabled
VaultServiceBase.VaultResponseItem returned: FailDBFault
----9/20/2004 7:39:04 AM XXXXXXX--XXXXXXX--SSL Disabled
EndTxFailDBFault

I have been trying to reproduce this but could not (although I have got the problem in 2 projects).

It has got something to do with sharing, deleting the share and resharing it (maybe from somewhere else to the same location).

Vault repository structure is:

- Proj1
----- imports
-----------Lib1

- Lib1

So Lib1 in imports was deleted. Resharing it now causes the error. Obliterating Lib1 from imports does not solve it either. Even deleting the whole "imports" directory, recreating it and sharing back lib1 fails.

We are using vault 2.0.6.

Thanks for any infos,
Herbert.

Post by **jclausius** » Mon Sep 20, 2004 7:50 am

Do you have multiple repositories? If so, is there another Lib1 in the other repository which was deleted and/or obliterated?

Guest · Post by **Guest** » Wed Sep 22, 2004 3:21 am

Hi,

- Yes we do use multiple repositories.
- Lib1 is definately not in another repository.

Is it possible I can send you 1 repository only? We have got a testing repo as well where this error occurs. It is quite small, if it can be extracted from the SQL Server in any way, let me know.

Ciao,
Herbert.

Post by **jclausius** » Wed Sep 22, 2004 7:55 am

Herbert:

I'd like to take a look at the repository if possible. Click on the email button below, and we'll resolve this problem off-forum.

Thanks,