If the host names or IP addresses of ALM server and database server are changed.

Recently our ALM POC server DB got changed from one server to other server. Inorder to point to new server we followed below steps to point to the new server.

Solution :

Step 1: Change siteadmin.xml
            
           Login to the ALM server where ALM is installed and navigate to the below path 
           
           "C:\ProgramData\HP\ALM\jboss\server\default\deploy\20qcbin.war\WEB-INF\siteadmin.xml".

           We need to change the content inside the tag "<DbUrl>DbUrl>", which will change the IP address of the DB server that contains siteadmin DB.

Step 2: Change DBSERVERS table

           Access to DB server. Open siteadmin DB, then modify the IP address or hostname of DB server under the table "DBSERVERS"

Step 3: Change PROJECTS table

           Access to DB server. Open siteadmin DB, then modify the IP address and hostname of DB server under the table "PROJECTS"

Step 4: Restart ALM service.

Now the ALM will points to New DB Server

What are the 3rd party software products we can integrate with ALM/QC?

IBM ReqPro
BM Rational Team Concert
IBM Rational Req. Composer
IBM DOORS
Atlassian JIRA
Atlassian GreenHopper
Selenium
Rally
Serena
Version One
BugZilla
TeamForge
IRIS
Microsoft TFS
ARIS
BluePrint
Caliber Requirements Manager
Remedy
Proprietary

JVM appears hung: Timed out waiting for signal from JVM. error in Jetty server

ERROR  | wrapper  | 2014/06/04 15:53:55.147 | JVM appears hung: Timed out waiting for signal from JVM.

ERROR  | wrapper  | 2014/06/04 15:53:55.585 | JVM did not exit on request, terminated STATUS | wrapper  | 2014/06/04 15:54:01.163 | Launching a JVM...

Cannot build directory item for key 'communication_security_passphrase' in TD Params Directory,

This summary is not available. Please click here to view the post.

step by step upgrade from Quality Center 10 to Quality Center 11 (ALM 11.0)

Follow the below steps to upgrade from Quality Center 10 to Quality Center 11 (ALM 11.0)

 Backup the projects’ databases and site administration database (“qcsiteadmin_db”) from the Quality Center 10 database server.

1.     Backup the projects’ repositories from the Quality Center 10 server. Each project has the location of the repository at the project properties in the Site Administration web site.

1.     Restore the project databases and the Site administration’s database at the Quality Center 11 database server.

1.     Install Quality Center 11.

 Note: Quality Center has 2 different databases, the project databases and the site admin database. When migrating, to keep users, user configurations, and site administration parameters, the same database name that was used to restore the project on the database server must be used. Select “Upgrade a copy” or “Upgrade the existing schema” option during installation.

 

5. Paste/Restore the repositories in the expected repository location in the new installation.

6.  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

 

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

 8. Verify, repair and upgrade project

a) Right click on it and select “Maintain Project”

b) Select Verify Project

c) After verification finished, select Repair project

d) After project repair, select Upgrade project

"Compile error in hidden module: mdlGlobal" while opening installed HP ALM Excel Addins

Follow below steps

1) Uninstall the existing excel add-in with admin rights and restart your system
2) install it again with admin privilege (it is very important to install the add-in with admin rights. It is even mentioned in excel add-in installation guide provided by HP)
3) Now open IE (32 bit) with admin rights
4) go to QC add-ins page and register "HP ALM Client Registration" component (register it also with admin rights) OR you can directly go to link
http://<servername>/qcbin/start_a.jsp?common=true
and install component

After that hope this issue will be resolved.Please follow all the steps mentioned in sequence above and don't leave or ignore any step (like restarting the system)