Authored by: Paul Oberly, Sr. Support Engineer – Micro Focus ADM – ALM at Orasi Software
. Here we cover some of the pitfalls related to upgrading the Site Admin Schema (usually called “”).
and don’t re-point your project’s database server and repository to the correct/new locations, you could accidentally upgrade the old/original (possibly still in production) database for your project.
gets upgraded as part of a new install, this table gets migrated in and will still point to the old (HP QC11.xx) database server and repository location for the projects.
continue pointing to the old database location from the new HP QC server instead of the new database location, this could result in corruption of the original or production data. So, these database locations will need to be changed to the new location.
This is done with the standard Remove (from Site Admin), then editing the DBID.xml file to point correctly to the new database location, restoring the project, and continuing with the individual project upgrade.
Another method of dealing with this would be the DBA delete all project rows from the Projects table expect for the one referring to “LAB_PROJECT” – do not delete that one. This will leave your HP QC instance with a blank project tree. You should then delete all domains (expect for Default) from the tree in Site Admin and recreate them. Highlight the new domain and take note of the “Physical Directory” on the grey Information tab to the right. You will need to know this when you migrate your project repositories – it needs to be indicated correctly in the DBID.xml file for your project before you restore it.
when installing a new HP QC server, it will often have some projects showing up in the project “tree.” Since these projects use a different server than the one indicated for the during install, both the new and old database server will show up in the Database Servers tab.
delete the old “database server” from the Database Servers tab. this is much cleaner and less confusing for other QC admins to only have the database server listed that you your projects, you can then using.
Download a PDF version here: HP Quality Center Upgrade Tip Warning about Inherited Project Tree in an Upgraded qcsiteadmin_db