Moving folders causes DB error.

[Jamie Clayton]

G'day,

I'm just moving the structure of my repository around to suit a better branching strategy with my projects. When I try and move a folder which includes some shared code files I get the following error. I've had a look at this from an obliteration point of view (bangs head against keyboard!), because it looks like back in 2008 I was learning vault and did silly things like branch files and rename them, share folders randomly, rather than from one central place etc. It looks like there might be circular shares/branches etc. Know I know I've got my branching strategy wrong (did some work with TFS 2010 for a client), and I'm trying to re-apply this to my company repository and failing badly.

GUI Warning

a database error has occured (FailDBReader)

Vault Server Log

Violation of PRIMARY KEY constraint 'PK__#4C13815__956BCC474DFBC9C9'. Cannot insert duplicate key in object 'dbo.@tblfsobjectshares'.

Sql Profiler failure Stored Procedure

Code: Select all

exec dbo.spgetpathchangeaffecteditems....

Similar Forum posts
http://support.sourcegear.com/viewtopic ... and+rename

Version - 5.0.4 (18845)

What do I need to do so I can re-organise my repositories?

[lbauer]

It looks like there may be some issues with shares in the database. We'd like to see more of the Vault Server log.
It's called sgvault.log and is in %windir%\temp\sgvault on the server machine. Send the log zipped up to support at sourcegear.com, Attn: Linda. Please include a link to this forum post.

[Jamie Clayton]

Linda,
Cheers, detailed log sent for your review. Have fun!

[lbauer]

Thanks, we've got the informaiton we need to troubleshoot this.

HS:223830

[Jamie Clayton]

Linda,
The SQL Script that you emailed me with the folder fix has been applied. I've got some branch merging to complete then will test the move folder again.

[lbauer]

OK. Let us know if you encounter further problems.

HS:22830