Search: Advanced search
Please enter a keyword or ID
Surround SCM Database Upgrade Fails
Note: This information only applies to Surround SCM 2010.
You may encounter errors when you try to upgrade a database from Surround SCM 2009.x format to the current Surround SCM 2010 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:
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:
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.