RE: Error Installing 2.01 Server

1.  We're using 1.2.3

2.  1.0.1.0

3.  Invalid object name 'sgvault.dbo.tblfsobjectlabels'.

4.  Yes.  I have already done that.

5.  Oh...#3 is the current database since I had to restore it (I had to
revert back since I can't have a whole team not working today...heh)


-----Original Message-----
From: jeff clausius [mailto:[email protected]] 
Sent: Wednesday, March 03, 2004 12:06 PM
To: Monte Kalisch
Cc: [email protected]
Subject: Re: [vault-list] Error Installing 2.01 Server


monte:

1) what version of vault were you upgrading from? 
2)  can you run the following query  SELECT schemaversion FROM
sgvault.dbo.tblschemaversions against the current database?
3)  can you run the following query SELECT COUNT(*) FROM
sgvault.dbo.tblfsobjectlabels against the current database?
3)  do you have a backup of your database before running the 2.0.1
installation?  can you restore that
4)  can you run the following query  SELECT schemaversion FROM
sgvault.dbo.tblschemaversions against the database from step 3?

jeff
sourcegear

*********** REPLY SEPARATOR  ***********

On 3/2/2004 at 8:46 PM Monte Kalisch wrote:

>I just received the following error when trying to install the 2.01
>Server:
> 
>Upgrading your Vault configuration.
>Checking for IIS Version...OK
>Connecting to the SQL Server...OK
>Requesting Vault Admin user password...OK
>Upgrading the existing Vault database...
>This may take a long time. Do NOT stop this process!
> Checking the installed database version...OK
> Upgrading SourceGear Vault database schema...Violation of UNIQUE KEY 
>constraint 'unique_tblfsobjectlabels_labelrepidobjid'. Cannot insert 
>duplicate key in object 'tblfsobjectlabels'. Type added.
>The statement has been terminated.
>Vault Upgrade Setup is exiting due to a failure or cancellation. Error
>Code = -1001
>Please press OK to continue installing the Client and Admin Tools (if
>selected).
> 
>Please advise!!
>
>_______________________________________________
>vault-list mailing list
>[email protected] 
>http://lists.sourcegear.com/cgi-bin/mailman/listinfo/vault-list