Search:     Advanced search

Surround SCM Database Upgrade Fails

Article ID: 705  |  Last updated: 14 Jun, 2017

Note: This information only applies to Surround SCM 2010 and later.

You may encounter errors when you try to upgrade a database from Surround SCM 2009.x format to the current Surround SCM format.

Receiving an error message when attempting to change the server database location

If you receive an error message stating that the Surround SCM Server database is an old format that must be upgraded after attempting to change the server database connection information, you need to manually change the server database registry entries to force the Surround SCM Server to load the database. This error occurs if you attempt to use a server database that was restored from a backup or moved from another machine.

Change the following registry values to update the database connection information:

  • DBHost
  • DBPort
  • DBUsername
  • DBPassword

Note: You can use plain text for the dbusername and dbpassword. The username and password will be automatically encrypted and saved when you restart the server.

If you want to convert the database connection a different RDBMS type, set the ServerDbType value to the corresponding value:

  • 2 – ODBC-SQL Server
  • 3 – Oracle
  • 5 – PostgreSQL

Upgrading a server or mainline database attempt was rejected

If you receive an error message stating that the attempt to upgrade a database that appears to be associated with a different Surround SCM Server was rejected, you need to manually clear the UUID stored in the database. This error occurs if the database was created by a different Surround SCM Server, which causes the upgrade to fail because the current server has a different UUID than the one associated with the database.

Use your database admin tool to clear the UUID value from the servuuid column in the serverid table.

Article ID: 705  |   Last updated: 14 Jun, 2017
database upgrade

Prev   Next
Changing the Surround SCM Server to a Service     Using Guiffy to Compare and Merge Files