Installation of 3.1.9/3.5.1 fails

jmckenzie · Post by **jmckenzie** » Wed Jan 17, 2007 8:44 am

Running an existing Vault 3.1.9 Windows 2003 server with SQL Server 2000 database on a separate Windows 2003 server.

Would like to move to SQL Server 2005 (on a separate server). Am trying to do an installation of 3.1.9 (preferably) but also tried with 3.5.1. The failure is similar.

I have backed up the Vault database, copied it to the new SQL Server 2005 server. I created a new sgvault shell and then restored the backed up copy.

I then start the installation from a Windows 2003 R2 server. I specify SQL authentication during the installation and give the sa account and password. The installation recognizes the existing database and asks if I want to preserve it. I do and it proceeds.

The error during the 3.1.9 installation is "Upgrading SourceGear Vault stored procedures...Must declare the scalar variable "@labelid". Vault Setup is exiting due to a failure or cancellation. Error Code = -1280.

The error during the 3.5.1 installation is: Upgrading SourceGear Vault stored procedures...Incorrect syntax near '!'. Vault Setup is exiting due to a failure or cancellation. Error Code = -1280

Any suggestions on how to work through this error?

Post by **jclausius** » Wed Jan 17, 2007 9:13 am

The @labelid scalar error seems like something has been corrupted when the installation tries to re-create the new stored procedures.

On your multiple attempts of installation, did you re-download the Vault server?

Exactly what steps did you use to backup/restore the database? Some people use DTS, and that will not work. You'll need to use a FULL backup / restore or detach, copy, and attach.

jmckenzie · Post by **jmckenzie** » Wed Jan 17, 2007 9:24 am

I'm not sure what you mean by re-downloading the server? I have done one installation each of 3.1.9 and 3.5.1. In both cases I did a download of the MSI file from the SourceGear site.

For the backup I did a full backup, copied the BAK file to the new SQL Server and then did a restore. No DTS involved.

Post by **jclausius** » Wed Jan 17, 2007 9:28 am

jmckenzie wrote:I'm not sure what you mean by re-downloading the server?

Yes. Try re-downloading the server's .msi file.

Are both installations giving you the same error message regarding @labelid? It seems unlikely that both downloads would be corrupted in the same exact place. But it wouldn't hurt to re-try with a fresh installation.

I'm wondering if it has something to do with the backup or any user security permissions. Can you verify 'sa' is a valid user of the sgvault database, and has db_owner rights?

Post by **jclausius** » Wed Jan 17, 2007 9:31 am

You said you restored into an existing database.

Log in as 'sa', and then try the restoration where the sgvault database does not exist. Just specify 'sgvault' in the database restore dialog.

jmckenzie · Post by **jmckenzie** » Wed Jan 17, 2007 10:08 am

The error is slightly different (see my original posting) but the error code is the same.

I re-downloaded the 3.1.9 MSI file.

I verified that sa is a db_owner of the sgvault database.

I deleted the sgvault database. I then logged in as sa and restored the database as you suggested. This completed without error.

I tried the installation of 3.1.9 again. It failed in the same location. This time the error was: Upgrading SourceGear Vault stored procedures...Incorrect syntax near '!'. Vault Setup is exiting due to a failure or cancellation. Error Code = -1280

Post by **jclausius** » Wed Jan 17, 2007 10:48 am

In your %temp% directory, you should find a vault_install.log file. Can you post or email (support at sourcegear dot com) that log file?

jmckenzie · Post by **jmckenzie** » Wed Jan 17, 2007 11:05 am

Vault log started at 17 Jan 2007 - 10.53.27

Custom action assembly location: C:\Vault\bin\CustomActionExe.exe
Custom Action version: 3.1.9

FileVersionInfo: File: C:\Vault\bin\CustomActionExe.exe
InternalName: CustomActionExe.exe
OriginalFilename: CustomActionExe.exe
FileVersion: 3.1.9.3798
FileDescription:
Product:
ProductVersion: 3.1.9.3798
Debug: False
Patched: False
PreRelease: False
PrivateBuild: False
SpecialBuild: False
Language Language Neutral

The commandline args as passed in to us:

/TARGETDIR=C:\Vault\
/TARGETDIR2=C:\Vault\VaultShadowFolder\
/CUSTOMNAME=
/CUSTOMPW =
/PARAMS=
/DROPDB=
/UPGRADE=
/ADMINPW=
/SQLLOGIN=
/SQLPW=
/WINAUTH=
/SQLSERVER=
/IISPROCESS=0
End commandline args.

Found local name of NT AUTHORITY\NETWORK SERVICE for Network Service account.
Validate the target dir for shadow folders
See if we need to do an upgrade or an install...Configuring your new Vault Installation
Entered CreateCryptoRegistryValues.
CreateCryptoRegistryValues completed successfully.
Entered GetIISProcessUser.
Checking for IIS Version... IIS Process Model user: NT AUTHORITY\NETWORK SERVICE
GetIISProcessUser completed successfully.
Requesting Vault Admin user password... Hashing the admin pw
OK
Connecting to the SQL Server...ConnectToDatabase() completed successfully.
dialog result for uninstall is: OK
OK
Verifying the SQL Server requirements... User is trying to install Vault to Microsoft SQL version 9.00.1399.06
OK
Checking for an existing Vault database...Found.
Asking for database's fate...Keep existing.
Upgrading the existing Vault database...
This may take a long time. Do NOT stop this process!
Checking the installed database version... 3.1.5.0
OK
Putting sgvault database in single-user mode.
Upgrading existing database user information with a new install.
UpgradeExistingDB (revoke) failed for sgvaultuser:
User or role 'sgvaultuser' does not exist in this database.. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at CustomActionExe.SetupForm.ExecuteSqlCommand(String cmd)
at CustomActionExe.SetupForm.UpgradeExistingDB(Boolean bOverwriteUserInfo)
Ensuring that sgvaultuser has access to the Vault database... Grant database access to sgvaultuser...OK
Executing commands in vault_upgrade.sql
Read vault_upgrade.sql from our resources.
Upgrading SourceGear Vault database schema...OK
DoSqlCommandsFromFile completed successfully.
Executing commands in vault_sp.sql
Read vault_sp.sql from our resources.
Upgrading SourceGear Vault stored procedures...Vault Setup is exiting due to a failure or cancellation. Error Code = -1280
Incorrect syntax near '!'.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280ExitCode on exit: -1280

Post by **jclausius** » Wed Jan 17, 2007 12:51 pm

Do you still have the database from "post installation"?

If so, can you report back the following:

SELECT schemaversion FROM sgvault.dbo.tblschemaversions

jmckenzie · Post by **jmckenzie** » Wed Jan 17, 2007 12:56 pm

This comes back as 3.1.5.0.

Post by **jclausius** » Wed Jan 17, 2007 12:59 pm

OK. Can you send me an e-mail? Use the button below.

I'd like to try something out that we cannot do over the forum.

Thanks.