02-19-2013 10:17 AM
I am currently trying to upgrade from QC 10 to QC 11 (SQL Server 2005 to 2008) but there is an issue with upgrading the Site Administration database. The QC 11 and SQL Server 2008 is on a separate box so the project/SA tables are being migrated to the new installation
After encountering similar problems from others' upgrade attempts, I created the 'td' user with the following to get past the 'td' user permission issues -
User Mapping for qcsiteadmin_db:
However, after these changes, when I try and upgrade the SA database (disabled SA schema validation checking b/c the generic failed validation error does not help), I get the following error:
Upgrading schema of table 'ADMIN' in database qcsiteadmin_db
Failed to upgrade table 'ADMIN';
wrapped in com.mercury.optane.core.CTdException: Failed to upgrade table 'ADMIN'
Solved! Go to Solution.
02-19-2013 11:52 AM
The following may help.
To upgrade a Quality Center 10 project to Quality Center 11 on a new Microsof SQL Database server.
1. Deactivate the project in version 10.
(NB: If this is a version control project ensure all checked out entities have been checked in before taking a backup of the project)
2. Make a DB backup of the QC project schema.
3. Make a backup of the QC 10 project folder from the repository on the file system.
4. Create a new project in QC 11 and name it the same way as the desired restored project name.
5. Remove the newly created project from QC 11. (DO NOT DELETE IT)
6. Restore the DB backup of the QC 10 project schema in the new DB server on the schema that was created when the new QC 11 project was created and restore project repository to the new location.
7. Link the td user with the td login by executing the below SQL query on the restored project schema in the DB server:
EXEC sp_change_users_login 'update_one', 'td', 'td'
exec sp_change_users_login 'report'
8. Edit the dbid.xml file. There is only 1 entry that needs to be edited from Y to N, please check below:
9. Delete the folder called "ProjRep" and leave just the already edited dbid.xml file.
10. Restore the project from Site Administrator.
11. Run the Verify tool.
12. Run the Repair tool if needed.
13. Upgrade the project.
14. Activate the project.
15. Login in order to verify if everything is ok.
Also is attached is the QC 10 Database Best Practices Guide.
I hope this helps.
John Scarpino, D.Sc.
02-20-2013 11:26 AM - edited 02-20-2013 11:27 AM
Thanks! This method eventually worked for me. There were a couple extra steps where I had to tweak the migrated project databases for td user/schema permissions, but it worked.
04-02-2013 01:34 PM
SO what wer ethe xtra steps you needed to tweek so I can se ethe full list of steps that eventually worked for you? I'm going through the same thing now but we're coming from QC 9.52.