Enable ‘Create a new Excel report’ option in HP-ALM

Excel Reports in Quality Center or HP-ALM have always been quite useful in extracting various reports. One of the many advantages has been to export test cases from ALM to excel sheet for convenient use and reporting

From HP-ALM version 12, the option to ‘Create New Excel Report’ is disabled by default. It means, the user cannot create new excel report, but can view, edit and run existing reports (if any) from previous versions.

ALM: Create New Excel Report Option Missing
ALM: Create New Excel Report Option Missing
ALM: Existing Excel Reports
ALM: Existing Excel Reports
 However, the option to ‘Create New Excel Report’ can be enabled by site configuration parameter – ‘ENABLE_CREATE_LEGACY_EXCEL_REPORT’. Following are the steps to do so:
  1. Login to ALM site administration.
  2. Navigate to ‘Site Configuration’ tab.
    ALM: Site Admin Site Configuration
    ALM: Site Admin Site Configuration
  3. Look for the parameter – ‘ENABLE_CREATE_LEGACY_EXCEL_REPORT’. Double click to configure it.
  4. If the above parameter is not found, the site admin can create it by clicking ‘New’. Enter the details as below.
    ALM: Site Admin Site Configuration New Parameter
    ALM: Site Admin Site Configuration New Parameter

  5. Please note that the parameter name is case sensitive and must be entered in all Capital letters.
  6. Click Ok.
ALM: Site Admin Site Configuration Excel Report Parameter
ALM: Site Admin Site Configuration Excel Report Parameter

The users must log off and login again in order to see the changes being effective.
ALM: Create New Excel Report Option Enabled
ALM: Create New Excel Report Option Enabled

HP QC/ALM Create Project – ‘failed to get tablespace info’

This is the second time I faced this issue and actually scolded myself for not documenting before. Here goes the problem.

When when the user click ‘Next’ on following step:

Following error message is displayed:

This is generally because of the password mismatch for ‘System’ user in corresponding Database.

The user need to contact the Database Administrator ion order to get the issue resolved (DBA team generally does not share the password for ‘System’ user.).

Following information is needed while contacting the DB:
1. Server Name – Displayed on the window above.

Sometimes. the DBA might also ask for the connection string or the ‘SID’ for the Database server. The same can be fetched from:
QC SiteAdmin -> DB Servers

Following are the steps to update the password:
1. Select the required DB server from left panel.
2. Click on ‘Database Administrator Password’. Following window would be displayed.
HP-QC-ALM-Update-Datadase-Admistrator-Password
3. Ask the DBA to input latest DB password for System user and click OK.
4. Click at ”Connection String’. Following window would be displayed.
5. Click on ‘Test Connection’. Following window would be displayed.

6. Do not update the password (It would be automatically updated) and click OK.
7. If the password is correct and connection is established, message ‘The Connection String is Ok’ is displayed as below: 
                                                      
8. Click OK, Close the ‘Ping DB Server’ popup and Connection string editor window.
9 Go back to ‘Site Projects’ and try creating a project again. HP-ALM should now successfully pass through the erroneous step as mentioned above.

Adding or Removing Site administrators in HP ALM

Users of HP ALM can be added as site administrators. This can only be done by other site administrators. The first site administrator is created at the time of installation. Before adding the user as site administrator, it must be made sure that the user is added in HP-ALM. If the user is not added to HP-ALM, the site administrator window would not list the same in it’s find section.
Following are the steps to add site administrators in HP ALM.
1. Login to HP ALM Site Administrator URL.
2. Click on ‘Site Users’ tab.
3. Click on ‘Site Administrators’ button.
4. Site Administrators window with list of existing site administrators is opened.
5. Click on add button
6. ALM users can be found by typing their names in find box. Once the match is found, the username would be highlighted in gray color.
7. Click on ‘Add Selected Item’ button on top. The user would be added as Site Administrator.
8. Similarly, the already added Site Administrators can be removed by selecting the user and clicking Remove button from the top.

    Download and Install Microsoft Excel Add-in for HP Quality Center or ALM 11.5x

    The MS-excel Add-in provided by HP QC/ALM enables the user to export requirements, tests, and defects from Microsoft Excel directly to ALM.

    Please note that the Add-In is only compatible with Microsoft Office 32 bit. If you have 64 bit Ms Office, that needs to be updated to 32 bit in order to run this Add-In.
    Unsure of your MS-Office version? Click below link to find out:

    How To Find If The MS Office Version is 32 or 64 Bit?

    Following are the steps to download and install the Microsoft Excel Add-in for HP Quality Center or ALM 11.5x. The steps to install other MS Add-ins like MS-word would also be more or less similar.

    1. Navigate to HP ALM Home Page
    2. Click “Tools” as highlighted above. Following window would be displayed.
    3. Click “More HP ALM Add-ins” as highlighted above. Following window would be displayed.
    4. Click “Add-Ins” icon as highlighted above. Following page would be displayed.
    5. Click “Add-ins for Microsoft Applications” as highlighted above.
    6. Click “Microsoft Excel” as highlighted above. Following window would be displayed.
    7. Click “HP ALM Microsoft Excel Add-in for ALM 11.00 and 11.5x – No Admin Rights Required” as highlighted above. The page will scroll to selected option.
    8. Click “HP ALM 11.5x Microsoft Excel Add-in Download” as highlighted above. Downloading would start. Open the download folder after it completes. 
    9. Run the executable file downloaded. Following window would be displayed.
    10. Click “Next” button as highlighted above. Following window would be displayed.
    11. Select the type of setup type (I selected ‘For All Users’).
    12. Click “Next” and the Add-In would be installed. Following window would be displayed after successful installation.
    13. Click Finish. The installation wizard would close. In order to verify that the add-in is installed, open a new excel sheet.
    14. A new tab named “Add-Ins” would now be displayed. Click on the same and the HP-ALM Add-in can now be seen.

    Click the below links for further read on same topic:
    Upload Test cases from Excel to Quality Center (QC) – HP QC 9.2

      Removing Port Number from QC/ALM URL

      We had been struggling to get rid of the port number in qc URL. Finally, we got it done with the help of HP Support.
      Below is the solution we have found to remove the port number 8080 from QC URL:

      1. Update the port number to 80 in configuration files of the application. In this case, they were ‘qcconfigfile.properties’ and ‘jetty.xml’.
      2. The ALM service would not start now as port 80 is likely to be used by other processes.
      3. Release port number 80 from all processes.
        • The command “netstat -o -n -a | findstr 0.0:80” help us find out if the port is being used or not.
        • If any website in IIS points to port 80, update the same.
      4. Start the ALM service
      5. Re-Start any other services stopped.

      In this case, we stopped 3 services – World Wide Web Publishing Service, Windows Remote Management (WS-Management) Service and IIS Admin Service

      Quality Center(QC) Site Admin Error: [Mercury][Oracle JDBC Driver][Oracle]ORA-28000: the account is locked

      Yesterday, while performing some activities in Quality Center Site Admin, I got following error on one of the projects.
      Messages:
      Failed to Get Users In Project;
      Failed to get users of project id = ***;
      Stack Trace:
      com.mercury.jdbc.base.BaseSQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-28000: the account is locked
      **I have clipped the rest of stack trace
      I got the idea but still, in an effort to not to contact the DBA, I deactivated the project. On trying to activate the project, I again got following message.

      Messages:
      Failed to Get Projects Properties;
      Failed to get projects properties;
      Failed to save projects properties;
      Cannot build directory item for key ‘[***_db@jdbc:mercury:oracle://***:1521;sid=***(***_db)]’ in TD Tables Struct Dir;
      Failed to fill table struct for table null in database ***_db@jdbc:mercury:oracle://***:1521;sid=***(***_db);
      [Mercury][Oracle JDBC Driver][Oracle]ORA-28000: the account is locked
      ;
       **I have clipped the rest of stack trace
      The solution was very simple. I did not have to do anything here. I just dropped an email to the DBA asking him to unlock the account. Bingo!!!
      Still if you want detailed solution from DBA end, following link may help:

      Mercury Screen Recorder: MSR or HP Screen Recorder

      Mercury Screen Recorder or HP Screen Recorder is an add-on provided by HP Quality Center/ALM which enables users to capture movies of events on their PC/screen. The users can use these movies to report bugs back to development teams.
      Details for downloading compatible versions can be seen on below link:
      Below are some of the salient features of Mercury Screen Recorder:
      1. Easy to operate
      2. Built-in Movie Editor
      3. Availability of Exporting the Movies to Different Formats There are five file formats that can be exported from Mercury Screen Recorder:
      ·         Standalone EXE
      ·         Flash
      ·         AVI
      ·         Windows Media Video (WMV)
      ·         MS PowerPoint
      There are two separate applications included in a Mercury Screen Recorder installation: the Recorder and the Player.
      • The Recorder application records what happens on your Windows desktop and saves this as a movie file. It can also record a spoken commentary, if you have a microphone connected to your PC.
      • The Player application plays back movie files created by the Recorder, to display a recreation of what was seen during recording. The Player can also be used to edit, annotate and export the movies to other file formats.
      Prerequisites for using MSR:
      1. Quality Center client must be installed, or Mercury Screen Recorder will not run.
      2. User must be able to connect and authenticate to Quality Center server.
      3. Mercury Screen Recorder will use one ‘Defect’ licence on the connected Quality Center server while running.

      Following are the steps to Install Mercury Screen Recorder: 
      1. Open http://qualitycenter:8080/qcbin/ 

      2. Click on “Add-ins” link. 
      3. Click on “More Mercury Quality Center Add-ins” link. 
      4. Click on “Mercury Screen Recorder Add-in” under section “Others”. 
      5. Mercury Screen Recorder add-in page as shown above will be opened. 
      6. Click on “Download Add-in” link.
      7. Either “Save” it on your machine or click on “Run”. 
      8. Again click on “Run” on security warning window. 
      9. Mercury Screen Recorder is installed on your machine. 
      10. Check Start–> All program –> Quality Center 9.0 –> Mercury Screen Recorder.
      In addition to the salient features, following are some more advantages of Mercury Screen Recorder:

      1. Tester need not waste time in typing the steps to reproduce and attaching snapshots. The same can be      recorder by the tester.
      2. The recording can be directly attached to a defect in Quality Center.
      3. Saves time, prevents confusion/conflicts.
      4. Movie watching is always better than reading.
      5. Can also be used to record a demo on applications which may also be saved for further reference.

      QC Export Wizard – Error on Step 4 of 8 – User is not permitted to export this kind of data – Quality Center

      While exporting from Excel to QC, the export wizard throws following error at step 4 –

      • Above error is thrown when the user does not have required rights to upload data.
      • In this case, if the user would not be able to create requirements/test/defects manually also.
      • To resolve the issue, please verify the permissions or the role on project you are trying to export data. This may be checked by navigating to Tools-> customizations. 
      • If you do not have proper rights, chances are that you would not be able to view the customizations screen. 
      • In that case, either try logging with admin login or ask your teammates for the same.

      QC Export Wizard-Excel 2007-Stuck on Step 5 of 8 – Quality Center

      While exporting from Excel 2007 to QC 9.2, the export wixard gets struck at –

       Step 5 of 8: Choose a Map Option.

      When I try to create a new or temp, – nothing happens.

      Following action solved issue for me –

      – you must have admin rights on folder 
      – C:ProgramFilesMicrosoft OfficeOffice12XLSTARTTDAddinTasks.
      – If you haven’t the folder Tasks, create it, and then try again. 

      Remove Locks in Quality Center (QC)

      Many times, users face problem in quality center when they receive an error stating that the entity has been locked by other user.

      The lock may be removed by the user by deselecting the entity or it may also be removed by the Quality Center Site Administrator. Following simple steps helps in unlocking an entity:-
      1. Log in to Quality Center Site Administrator

      2. Expand the required domain.
      3. Expand the reruired project. It would show the list of tables for that project.
      4. Every project would have a Locks table. Click on Locks table.
          It will display the Select * from Locks query executed by default with list of locks on the project.


      5. Type the query –
         delete from locks where lk_session_id=

      6. Hit Execute button. It deletes the lock allowing users to edit the entity again.