Repository is gone?!

[CareBear]

Deleting the latest transaction with the sql statements you gave me fixed the problem. I now get both repositories in the Vault Admin Tool and Vault Client.

The database is more than 5GB so I can't really send it to you, but if you perhaps explain to me which tables I can truncate to make it smaller for you, for investigation?

Thanks for all the help!

Regards,
Sondre

[jclausius]

Where do I find the Vault log?

By default it is written to %windir%\temp\sgvault

[jclausius]

Deleting the latest transaction with the sql statements you gave me fixed the problem. I now get both repositories in the Vault Admin Tool and Vault Client.

You're not out of the woods yet. Try a quick transaction, shutdown the client, and then try to re-log in. Are both repositories still there? Did you re-install the server to "refresh" the stored procs / triggers?

The database is more than 5GB so I can't really send it to you, but if you perhaps explain to me which tables I can truncate to make it smaller for you, for investigation?

If you remove the data from tblfsobjectversionfileinfos and tblfileinfo in the backup, and then shrink the database, that might give you some decrease in overall size.

Assuming you have the bandwidth, the 5 GB shouldn't be a problem for transfer over ftp.

[CareBear]

----22.03.2005 14:26:41 sondre--SNB(XX.XX.XX.XXX)--SSL Disabled Cannot insert duplicate key row in object 'tblfsobjectversions' with unique index 'idxfsobjectversionversions'.
----22.03.2005 14:26:41 sondre--SNB(XX.XX.XX.XXX)--SSL Disabled Could not create bubble folders: Error in the application.

This is around the time the problem occured. After deleting the last transaction and looking at the recent checkins in the Vault web interface, the last checkin was 14:24:49.

Hope this helps!


/Sondre

[jclausius]

If that quick transaction test does fail, I'm going to ask Linda to send you a tool which checks folder information. We'll wait to hear back from you.

[CareBear]

The database wasn't that big after all, just the backup with transaction log and everything.

I'll look into this after easter, but so far everything seems to be working fine.


I did nothing more than delete that last transaction, I didn't reinstall Vault or anything else.

There have been multiple checkins already, and our build server is already up and running again.


Regards,
Sondre

[jclausius]

CareBear:

Following up on this.

Do you happen to use shared folders? Do you happen to know if the last transaction was in a shared folder?

Do you happen to have more than one instance of a Vault server?