Vault database problems with label and export folder tool

[M Wickardt]

Hi,

We're having problems with the "label" command, and also with the "export folder tool".

We're using Vault 5.0.3 (on a vault test system).

The label problem:
After "label" we get:
Label error: A database error has occured (FailDBInsert)
sgvault.log says:
----17-5-2010 11:15:35 admin--localhost(127.0.0.1)--SSL Disabled DB: AddLabel started.
----17-5-2010 11:15:36 admin--localhost(127.0.0.1)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#tbllabelview_____2DD1C37F'. Cannot insert duplicate key in object 'dbo.#tbllabelview'.

That's pretty clear... but how do we solve it?

The export folder tool gives the following problem:
I export "$", and it stops at transaction retrieved 200/17782(1%), Labels 267, with the following error:
A database error has occured (FailDBReader)
Folder Export Error
An error was encountered processing a transaction for the folder. The export cannot continue. An exception was encountered retrieving the Tx Information for $. Tx: 17408 Previous Tx: 17407
sgvault.log says:
----17-5-2010 11:20:18 admin--tijs-vpc1.bertus.lokaal(192.168.4.154)--SSL Disabled Getting Vault Folder Export delta -> Rep ID: 3 Base: 17408 Target: 17407
----17-5-2010 11:20:18 admin--tijs-vpc1.bertus.lokaal(192.168.4.154)--SSL Disabled VaultAdminServiceAPI::GetFolderExportRepositoryDelta() RepID:3 Base:17408 Target:17407 Calling VaultSqlSCC.GetRepositoryTreeDelta().
----17-5-2010 11:20:18 admin--tijs-vpc1.bertus.lokaal(192.168.4.154)--SSL Disabled DB: GetFolderExportRepositoryDelta started.
----17-5-2010 11:20:18 admin--tijs-vpc1.bertus.lokaal(192.168.4.154)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#foldermodfolder__2F10007B'. Cannot insert duplicate key in object 'dbo.#foldermodfolderentries'.
The statement has been terminated.
bij System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

Again, pretty clear... but how do we solve it?

I could upload out database to your ftp site, if possible. It's about 1GB, but 7-zipped only about 70MB.

Thanks for your help, M (Tijs) Wickardt

[Beth]

What version of Vault are you currently using?

When you first started using Vault, what version was it?

Do you use the obliterate function at all? If you aren't sure, perform a Show History on $, and in the history dialog go to the Actions tab and only check Obliterate. Does anything show up?

So that we can take a closer look could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread?

[M Wickardt]

>> What version of Vault are you currently using?

5.0.3

>> When you first started using Vault, what version was it?
3.5.1

>> Do you use the obliterate function at all? If you aren't sure, perform a Show History on $, and in the history >> dialog go to the Actions tab and only check Obliterate. Does anything show up?
We use it very rarely, but have done so with 15 individual files in the past two years.

I'll send you an e-mail, thanks for your help.

Kind regards, Tijs Wickardt

[Beth]

The obliterates can get in the way of an export import. In nearly all cases, once an obliterate is performed, an export/import cannot be performed.

On the label, can you perform a Show Labels and make sure that there isn't a label with the same name anywhere as what you were trying to apply when you received the error?