Error when deleting a folder structure

tx.daniel · Post by **tx.daniel** » Mon Jun 23, 2008 12:30 pm

Hi,
We're having problems deleting a folder structure that a user incorrectly loaded into vault 3.0.6. The structure looks like this:
$/
|_ProjectName
...|_ProjectName
.......|_ProjectName
............|_3rdLevel Subfolder
............|_AnotherFolder
...|_Firstlevel subfolder
...|_Firstlevel subfolder
...|_Firstlevel subfolder

The same name was used 3 times for 3 different folders in the same project structure. After this folder was loaded, the following error is recorded when trying to delete an object from the repository:

----6/23/2008 11:07:14 AM admin--fxws0332.domain.com(192.168.1.81)--SSL Disabled BeginTx beginning transaction
----6/23/2008 11:07:18 AM admin--fxws0332.domain.com(192.168.1.81)--SSL Disabled BeginTx returned: Success
----6/23/2008 11:07:18 AM admin--fxws0332.domain.com(192.168.1.81)--SSL Disabled VaultLib.VaultRequestDelete returned: Success
----6/23/2008 11:07:18 AM admin--fxws0332.domain.com(192.168.1.81)--SSL Disabled Ending transaction
----6/23/2008 11:07:38 AM --fxlt0063.domain.com(204.90.92.75)--SSL Disabled Getting repository Structure.
----6/23/2008 11:08:24 AM admin--fxws0332.domain.com(192.168.1.81)--SSL Disabled Violation of PRIMARY KEY constraint 'PK__#tmptree__________5F087FC7'. Cannot insert duplicate key in object 'dbo.#tmptree'.
The statement has been terminated.
----6/23/2008 11:08:26 AM admin--fxws0332.domain.com(192.168.1.81)--SSL Disabled VaultLib.VaultResponseItem returned: Success
----6/23/2008 11:08:26 AM admin--fxws0332.domain.com(192.168.1.81)--SSL Disabled EndTxFailure

I am not certain both of these events are connected but since there's a PK Problem it makes me believe it is so. Can you please help us? Thanks in advance!

Beth · Post by **Beth** » Mon Jun 23, 2008 4:01 pm

The same name was used 3 times for 3 different folders in the same project structure.

What you posted is not supposed to be possible. Do you know if those adds were committed?

Is it possible for you to post a screenshot?

You really should get yourself up to Vault 3.1.9 as well. That's a free upgrade for you.

Does everyone see the same structure in Vault of 3 folders at the same level with the same name?

tx.daniel · Post by **tx.daniel** » Mon Jun 23, 2008 4:09 pm

I'm sorry, the correct structure is as follows:

|_ProjectName
...|_ProjectName
.......|_ProjectName
............|_3rdLevel Subfolder
............|_AnotherFolder
...|_Firstlevel subfolder
...|_AnotherFirstlevel subfolder
...|_YetAnotherFirstlevel subfolder

I've taken a screenshot of the partial current structure. The highlighted folder is the one we're trying to get rid of.

Thanks for your help!