Upgrade Dragnet failed error 402

[cs]

I am trying to upgrade a test dragnet database on MS SQL Server 2000 Personal Edition SP4.

I uninstalled Dragnet app with 'leave database' option.

The Fortress Server install fails, in the log:

Database 'sgdragnet' already exists.
CreateDatabase Error2: Database 'sgdragnet' already exists.
Fortress Setup is exiting due to a failure or cancellation. Error Code = 402
Database 'sgdragnet' already exists.
Fortress Setup is exiting due to a failure or cancellation. Error Code = 402ExitCode on exit: 402

I then have to Exit the install and it has failed. I thought the database would be detected and upgraded?

(All 3 databases - sgdragnet, sgmaster, sgvault - have same collation of SQL_Latin1_General_CP1_CI_AS by the way)

[mskrobul]

The installer will upgrade the database, but it doesn't look like the installer is detecting the Dragnet database correctly before trying to upgrade. It looks like there may be a bug in the way the installer is trying to detect the Dragnet database.

Try putting an sgvault database on the same machine as the Dragnet database then do the Fortress install and see if that works (install the Vault 3.5.1 server on the same machine then uninstall it then install Fortress).

Sorry for the inconvenience.

[cs]

Steps:

1) Install dragnet, detach empty database and restore test database
2) Install vault
3) Uninstall dragnet, keep database
4) Uninstall vault, keep database
5) Install Fotress server (fails)

Upgrade of dragnet fails:

Upgrading SourceGear Vault database schema...OK
Upgrading SourceGear Dragnet database schema...Line 63: Incorrect syntax near 'Importing'.
Line 126: Incorrect syntax near ')'.
Cannot drop the table '#tmpErrors', because it does not exist in the system catalog.
The database update failed
Fortress Setup is exiting due to a failure or cancellation. Error Code = -1280

sgvault database is left in Single User mode when install fails.

All databases are using SQL_Latin1_General_CP1_CI_AS collation.

[jeremy_sg]

cs,

We're pretty sure that we know what's going on. Email me by using the button below this post with your address. When I've got a new build for you to try, I'll notify you.