Highlighted
Established Member..
Established Member..
1996 views

QC 9.2 to ALM 11migration - fails after installing Patch 14

Jump to solution

All,

     We have an installation of QC 9.2 installed in a development environment to test the upgrade to ALM 11. I migrated a number of projects without any problem while ALM was patched to Patch 7. Following the installation of Patch 14, the 'Verify' and 'Repair' tools run to completetion on migrated projects but everytime I try to 'upgrade' a project, the upgrade tool returns an error to say that the Project is corrupted. It lists a support document but this has been removed/archived and is no longer visible.

 

Has anyone else experienced this? If so how did you proceed?

 

Many thanks 

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.. Absent Member..
Absent Member..

The following should be of assistance. http://support.openview.hp.com/selfsolve/document/KM1007069 I have it copied below.

 

I hope this helps.

John Scarpino, D.Sc.

Keep finding bugs!

 

Steps to Upgrade from QC 9.2 or QC 10.00 to ALM 11:
 
Pre-requisites:
  1. Check the following page for system requirements of ALM 11:
  1. Move the project repository from the Database (DB) to the File System (QC 9.2 only)
Note: Repository over DB is not supported in ALM11
 
Workarounds:
2.     Install the latest QC patch for the QC 9.2 version which includes a tool to download the repository to the file system
  1. Before migration, deactivate all projects from the Site Administrator
Migration of QC 9.2 or QC 10.00 to ALM 11
  1. Backup the projects’ databases/schemas and Site administration database/schema (default name “qcsiteAdmin_db”) from the QC 9.x database server
    1. For SQL server:
                        i.      Document ID KM169526 - How to backup and restore MS SQL database
                        ii.     Document ID KM186582 - What are the minimum permissions for MS SQL in Quality Center
    1. For Oracle Server:
                        i.      Document ID KM205839 - How to export and import an Oracle database to dump files
                        ii.     Document ID KM186580 - What are the minimum permissions for Oracle in Quality Center
 
  1. Backup the projects’ repositories from the QC 9.x or QC10.00 server. Each project has the location of the repository at the project properties in the Site Administration web site.
    1. Document ID KM189097 - What needs to be backed up when backing up Quality Center
  1. Restore the project databases/schemas and the Site administration’s database/schema at the ALM 11 database server (if you are using a new database server)
Note: If upgrading QC, there’s no need to move projects databases/schemas however is important to take backups.
  1. Install ALM11, if you are using the same application server you must uninstall QC 9.2 or QC10.00
QC has 2 different databases, the project databases and the site admin database. When migrating, to keep users, user configurations, and site administration parameters you must install using the same database name that was used to restore the project in your DB server. Select “Upgrade a copy” or “Upgrade the existing schema” option during installation.
  1. Paste/Restore the repositories in the expected repository location in the new installation
  2. Restore the projects
a)      Login Site Administrator and create a new empty project.
b)      Go to the new empty project’s folder repository and make a copy of the dbid.xml file.
c)      Remove your projects from the Site Administration (Reason: it has connections to the old database server). Do not delete the project because it will remove the project schema from the database server.
d)      Go to the project’s folder and rename the existing “dbid.xml” file to “dbidold.xml”
e)      Paste a copy of the “dbid.xml” file from the empty new project.
f)       Edit the “dbid.xml” to match your project environment description as follow:
 
<?xml version="1.0" encoding="UTF-8" ?>
<ProjectDescription>
 
  <PROJECT_NAME>** Put the project name **</PROJECT_NAME>
 
  <DB_TYPE>XXXXX</DB_TYPE>
  <DESCRIPTION>XXXXX</DESCRIPTION>
  <DB_CONNSTR_FORMAT>XXXXX</DB_CONNSTR_FORMAT>
  <DB_NATIVE_AUTHENTICATION>XXXXX</DB_NATIVE_AUTHENTICATION>
 
  <DB_NAME>** Put the project schema name **</DB_NAME>
 
  <DBSERVER_NAME>XXXXX</DBSERVER_NAME>
  <DB_USER_PASS>XXXXX</DB_USER_PASS>
  <PR_HAS_VCSDB>XXXXX</PR_HAS_VCSDB>
 
  <PHYSICAL_DIRECTORY>** Put the correct path of the repository folder of this project**\</PHYSICAL_DIRECTORY>
 
  <USERS_QUOTA>XXXXX</USERS_QUOTA>
  <PR_IS_ACTIVE>XXXXX</PR_IS_ACTIVE>
  <SAQ_IS_ACTIVE>XXXXX</SAQ_IS_ACTIVE>
  <VM_REPOSITORY />
  <PR_REPOSITORY_IN_DB>XXXXX</PR_REPOSITORY_IN_DB>
  <PR_LANGUAGE>XXXXX</PR_LANGUAGE>
 
  <PROJECT_UID>82a311c5-a440-4ecd-97a2-e97331a447XX</PROJECT_UID>
 
 </ProjectDescription>
 
PROJECT_NAME: the name of the project, for example: NEW_PROJECT.
DB_NAME: the name shown in the database list, for example: NEW_PROJECT_DB
PHYSICAL_DIRECTORY: by default, this values is: <Drive>:\Program Files\Mercury\Quality Center\repository\qc\<Domain_Name>\<Project_Name_Folder>
PROJECT_UID: Keep the same amount of digits and modify the last two values to get a unique ID
PR_SMART_REPOSITORY_ENABLED should be changed from 'Y' to 'N'
 
Note: This step can be skipped if upgrading from existing qcsiteadmin_db as it already contains the project information.

    7.  From the site administrator restore projects using the “dbid.xml” file edited for all projects.

  1. Verify, repair and upgrade projects
    1. Right click on it and select “Maintain Project”
    2. Select Verify Project
    3. After verification finished, select Repair project
    4. After project repair, select Upgrade project
Notes:
  • After upgrade the project you can not change its repository folder location, the reason of that is that there is a new feature in ALM that optimizes the project’s repository, there will be a job implementing this after upgrade the project for at least 1 day if the project is small and 5 days if the project is large.
Here is the information from the administrator guide (page 97):
After upgrading a project to ALM 11.00, ALM migrates the project repository directories to a new file structure in the default project repository location. If the migration process fails, you must fix the problems manually in the project repository. You can also configure the speed at which the migration is performed. For more information, see "Repository Migration" from Administrator Guide on page 120.
  • Recommendation is to try on a Test server, then production
  • After upgrade the project you can not change its repository folder location, the reason of that is that there is a new feature in ALM that optimizes the project’s repository, there will be a job implementing this after upgrade the project for at least 1 day if the project is small and 5 days if the project is large.
  • Version Control Projects --> Upgrading Version Control
    Upgrading Quality Center 10.00 version control enabled projects. Version
    control enabled projects from Quality Center 10.00 cannot be upgraded to
    ALM 11.00 while there are checked out entities. All entities must be checked
    in in Quality Center 10.00.
    Upgrading from legacy version control projects. To work with projects from
    Quality Center 9.0 or Quality Center 9.2 that use version control, you must
    first upgrade to Quality Center 10.00, migrate legacy version control data,
    and then upgrade to ALM 11.00. For information on migrating legacy
    version control data to Quality Center 10.00, see HP Software Self-solve
    knowledge base article KM632120 (
    http://h20230.www2.hp.com/selfsolve/document/KM632120).
These documents may be useful:
 
Installation Guide                       ALM11.00_Installation.pdf
User Guide                                ALM11.00_User.pdf
Administrator Guide                   ALM11.00_Administrator.pdf
What is New                             ALM11.00_WhatsNew.pdf
Upgrade Best Practices             ALM11.00_UpgradeBestPractices.pdf

View solution in original post

0 Likes
3 Replies
Highlighted
Outstanding Contributor.
Outstanding Contributor.

Hi 

 

Please remove and restore a fresh backup of the project, remove/restore the project in ALM, then set the SA logs in debug mode, and  re-run the verify , repair and upgrade. when the error appears, get the time shown in the upgrade console, and review the SA logs at the same time to find the  error.

 

When an upgrade failes, the project become corrupted, and a fresh backup of the database needs to be resotred. Please pay attention to the upgrade info . The Maiteinance information is in <ALM repository>\Sa\ManteinanceData\out\{Domain}\{Project name}\.

 

Cordially

"HP Support
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution"
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

The following should be of assistance. http://support.openview.hp.com/selfsolve/document/KM1007069 I have it copied below.

 

I hope this helps.

John Scarpino, D.Sc.

Keep finding bugs!

 

Steps to Upgrade from QC 9.2 or QC 10.00 to ALM 11:
 
Pre-requisites:
  1. Check the following page for system requirements of ALM 11:
  1. Move the project repository from the Database (DB) to the File System (QC 9.2 only)
Note: Repository over DB is not supported in ALM11
 
Workarounds:
2.     Install the latest QC patch for the QC 9.2 version which includes a tool to download the repository to the file system
  1. Before migration, deactivate all projects from the Site Administrator
Migration of QC 9.2 or QC 10.00 to ALM 11
  1. Backup the projects’ databases/schemas and Site administration database/schema (default name “qcsiteAdmin_db”) from the QC 9.x database server
    1. For SQL server:
                        i.      Document ID KM169526 - How to backup and restore MS SQL database
                        ii.     Document ID KM186582 - What are the minimum permissions for MS SQL in Quality Center
    1. For Oracle Server:
                        i.      Document ID KM205839 - How to export and import an Oracle database to dump files
                        ii.     Document ID KM186580 - What are the minimum permissions for Oracle in Quality Center
 
  1. Backup the projects’ repositories from the QC 9.x or QC10.00 server. Each project has the location of the repository at the project properties in the Site Administration web site.
    1. Document ID KM189097 - What needs to be backed up when backing up Quality Center
  1. Restore the project databases/schemas and the Site administration’s database/schema at the ALM 11 database server (if you are using a new database server)
Note: If upgrading QC, there’s no need to move projects databases/schemas however is important to take backups.
  1. Install ALM11, if you are using the same application server you must uninstall QC 9.2 or QC10.00
QC has 2 different databases, the project databases and the site admin database. When migrating, to keep users, user configurations, and site administration parameters you must install using the same database name that was used to restore the project in your DB server. Select “Upgrade a copy” or “Upgrade the existing schema” option during installation.
  1. Paste/Restore the repositories in the expected repository location in the new installation
  2. Restore the projects
a)      Login Site Administrator and create a new empty project.
b)      Go to the new empty project’s folder repository and make a copy of the dbid.xml file.
c)      Remove your projects from the Site Administration (Reason: it has connections to the old database server). Do not delete the project because it will remove the project schema from the database server.
d)      Go to the project’s folder and rename the existing “dbid.xml” file to “dbidold.xml”
e)      Paste a copy of the “dbid.xml” file from the empty new project.
f)       Edit the “dbid.xml” to match your project environment description as follow:
 
<?xml version="1.0" encoding="UTF-8" ?>
<ProjectDescription>
 
  <PROJECT_NAME>** Put the project name **</PROJECT_NAME>
 
  <DB_TYPE>XXXXX</DB_TYPE>
  <DESCRIPTION>XXXXX</DESCRIPTION>
  <DB_CONNSTR_FORMAT>XXXXX</DB_CONNSTR_FORMAT>
  <DB_NATIVE_AUTHENTICATION>XXXXX</DB_NATIVE_AUTHENTICATION>
 
  <DB_NAME>** Put the project schema name **</DB_NAME>
 
  <DBSERVER_NAME>XXXXX</DBSERVER_NAME>
  <DB_USER_PASS>XXXXX</DB_USER_PASS>
  <PR_HAS_VCSDB>XXXXX</PR_HAS_VCSDB>
 
  <PHYSICAL_DIRECTORY>** Put the correct path of the repository folder of this project**\</PHYSICAL_DIRECTORY>
 
  <USERS_QUOTA>XXXXX</USERS_QUOTA>
  <PR_IS_ACTIVE>XXXXX</PR_IS_ACTIVE>
  <SAQ_IS_ACTIVE>XXXXX</SAQ_IS_ACTIVE>
  <VM_REPOSITORY />
  <PR_REPOSITORY_IN_DB>XXXXX</PR_REPOSITORY_IN_DB>
  <PR_LANGUAGE>XXXXX</PR_LANGUAGE>
 
  <PROJECT_UID>82a311c5-a440-4ecd-97a2-e97331a447XX</PROJECT_UID>
 
 </ProjectDescription>
 
PROJECT_NAME: the name of the project, for example: NEW_PROJECT.
DB_NAME: the name shown in the database list, for example: NEW_PROJECT_DB
PHYSICAL_DIRECTORY: by default, this values is: <Drive>:\Program Files\Mercury\Quality Center\repository\qc\<Domain_Name>\<Project_Name_Folder>
PROJECT_UID: Keep the same amount of digits and modify the last two values to get a unique ID
PR_SMART_REPOSITORY_ENABLED should be changed from 'Y' to 'N'
 
Note: This step can be skipped if upgrading from existing qcsiteadmin_db as it already contains the project information.

    7.  From the site administrator restore projects using the “dbid.xml” file edited for all projects.

  1. Verify, repair and upgrade projects
    1. Right click on it and select “Maintain Project”
    2. Select Verify Project
    3. After verification finished, select Repair project
    4. After project repair, select Upgrade project
Notes:
  • After upgrade the project you can not change its repository folder location, the reason of that is that there is a new feature in ALM that optimizes the project’s repository, there will be a job implementing this after upgrade the project for at least 1 day if the project is small and 5 days if the project is large.
Here is the information from the administrator guide (page 97):
After upgrading a project to ALM 11.00, ALM migrates the project repository directories to a new file structure in the default project repository location. If the migration process fails, you must fix the problems manually in the project repository. You can also configure the speed at which the migration is performed. For more information, see "Repository Migration" from Administrator Guide on page 120.
  • Recommendation is to try on a Test server, then production
  • After upgrade the project you can not change its repository folder location, the reason of that is that there is a new feature in ALM that optimizes the project’s repository, there will be a job implementing this after upgrade the project for at least 1 day if the project is small and 5 days if the project is large.
  • Version Control Projects --> Upgrading Version Control
    Upgrading Quality Center 10.00 version control enabled projects. Version
    control enabled projects from Quality Center 10.00 cannot be upgraded to
    ALM 11.00 while there are checked out entities. All entities must be checked
    in in Quality Center 10.00.
    Upgrading from legacy version control projects. To work with projects from
    Quality Center 9.0 or Quality Center 9.2 that use version control, you must
    first upgrade to Quality Center 10.00, migrate legacy version control data,
    and then upgrade to ALM 11.00. For information on migrating legacy
    version control data to Quality Center 10.00, see HP Software Self-solve
    knowledge base article KM632120 (
    http://h20230.www2.hp.com/selfsolve/document/KM632120).
These documents may be useful:
 
Installation Guide                       ALM11.00_Installation.pdf
User Guide                                ALM11.00_User.pdf
Administrator Guide                   ALM11.00_Administrator.pdf
What is New                             ALM11.00_WhatsNew.pdf
Upgrade Best Practices             ALM11.00_UpgradeBestPractices.pdf

View solution in original post

0 Likes
Highlighted
Established Member..
Established Member..
Thanks John. I'll go through this and see if I can get the projects to restore. Not sure why the restoration process was fine prior to installing Patch 14
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.