AnuMohanCP 2700023V0K Visits (269)
Have you ever run into a problem with Rational Quality Manager (RQM) where the Excel Import fails with the following error? An invalid XML character (Unicode: 0x1d) was found in the element
Well, if not, consider yourself lucky! Here are a few ways you could run into this error and a potentially way to overcome it.
Here's how you can run into this problem:
Perform a excel import from your Excel Sheet and you notice "ERR
Consider taking a closer look a the debug logs and you might find:
Export error log:
11/13/2015 5:40:54 AM: ERROR: <Unknown Caller Context>: The remote server returned an error: (400) Bad Request.
Debug log file:
Log file location : C:
11/17/2015 11:58:05 AM: sending testscript0 named US40
Here's why this could be happening:
The error recorded here attributed to a Invalid Character inline with the plain text failing to get exported.
Here's how you can find the character:
1.Export the Excel to XML (use Export to File option).
Now fix the problem!
1.Copy the Excel Cell contents to a text editor and retype the erroneous text again and paste it back to the Excel cell.
AnuMohanCP 2700023V0K Visits (309)
You might be familiar with Rational Quality Manager (RQM) REST API's to query your artifacts. The RQM Reportable REST API allows a user to perform CRUD type operations on test resources via XML sequences to the RQM server. This article describes about how to manipulate resources like (test case, test execution record, test results, etc..) in RQM using REST API
I can help you! There are Cheat Sheets available for a few RQM REST URL's, but not specifically for this query. You are looking for help with constructing a REST URL for this query.
Below you'll find a Sample REST URL to perform the GET operation to query Testcase execution Record (TCER) filtered for a specific Testcase.
Choose to use the following URL. which has been tested and working
This gives the TCER's filtered using a Testcase ID from REST Client.
I hope you find this helpful!
AnuMohanCP 2700023V0K Visits (300)
CFG files are used to import data into Rational Quality Manager. The file must be in a specific format for the import to work properly. Here is a sample CFG file created for associating a Single Testplan to Multiple Testcases. Also, each Testcase is associated with multiple Testscripts, which will allow you to use with IBM Rational Quality Manager (RQM) Excel Import utility.
// this configuration file will create a single test case from the defined cells and link to all
// since we aren't defining an ID to use, the tool will create one based on the excel worksheet
// We want to start looking for scripts after row 8
// the literal "execution" will be put into the step type tag, so all steps will be of type execution
// a new script starts when we encounter an empty row
// we want to use the data we got for each test script to create a test case
// test case defined with definite cell locations
//Config for Testplan
Rajeshavanthi 2700022MCX Visits (521)
Imagine a scenario where the Loadrunner (LR) scripts are imported successfully into IBM Rational Quality Manager (RQM) and you want to execute these imported scripts.
Unfortunately, when you attempt to execute these LR scripts from within RQM section, you encounter the following error:
The adapter log present in location <Loadrunner Adapter installation path
22 Sep 2015 02:30:45,366 [AWT-EventQueue-0] INFO com.
Proposed suggestions to Debug this scenario:
Modify the log4j.xml file located at “<HP LR Adapter installation dir>
<priority value =" debug " />
<appender-ref ref="stdout" />
<appender-ref ref="FA" />
Log level should be changed to “debug”.
After changing the log4j.xml file, re run the LR scenario ,stop the adapter and share the log files located at “<HP LR Adapter installation dir>
If LR Scenario has custom result settings as mentioned in below steps then Adapter may not be unable to find the Result Folder to upload it to RQM test case result area.
Follow below steps:
1. Open the LR Scenario in the LR Controller.
2. Go to Menu option Results -> Result Settings
3. A dialog to set the result directory will be opened.
4. Check the option : “Automatically create a result directory for each scenario execution “.
5. Execute the LR Scenario via RQM Test Case.
You may now run scenario after unchecking the “Automatically create a result directory for each scenario execution” option in Result Setting dialog and observe the result.zip in RQM Result section.
Rajeshavanthi 2700022MCX Visits (565)
Here's a scenario which describes certain hurdles which you can face while working with the HP Loadrunner scripts and RQM.
Imagine you have several LoadRunner scripts which you would like to import and execute within RQM.
Following is the snapshot :
Here's couple of suggestions when you intend to import the load-runner scripts into RQM
AnuMohanCP 2700023V0K Visits (677)
This article explains the ways you can export a process template from IBM Rational Quality Manager (RQM).
Steps to be followed:
Additional information is available in the CLM
Rational Quality Manager v6.0: Images which are part of Test-Case Design section do not get exported to Portable Document Format (PDF)
Rajeshavanthi 2700022MCX Visits (549)
Often times, you might have data requirements which are documented in external data source files such as Comma separated Value (CSV) or Microsoft Excel worksheet. Microsoft Excel and Word are popular document formats used by many test organizations to author, store and maintain their test assets. These document formats are easy to use and widely available.
So if any of your project teams are working on such external data sources and want to import the data involving relevant image files into IBM Rational Quality Manager (RQM), they can make use of the RQMExcelImporter utility.
In fact, RQM software helps teams share information seamlessly, use automation to accelerate project schedules and report on metrics for informed release decisions.
Rational Quality Manager helps quality assurance teams by providing the below functionalities.
Below is one such scenario which will describe how to import a few test assets and an image specifically into RQM. It also describes a defect behavior of the imported images (part of Test Case Design section in RQM), not getting exported to PDF file, though the import was successful.
For example: Image is successfully imported into Test case design section, but when we create a comprehensive PDF export, the image does not get exported. Interestingly, if you manually cut past an image within the Test Case Design section in RQM, the import gets exported to PDF successfully.
Debugging this problem, prompted a couple of questions like...
Let's analyze this scenario now...
Below is the snapshot of the data which is documented in the MS Excel worksheet.
Following is the Configuration file (CFG file) which will map to each entries present in the rows and columns of this worksheet .
Using the RQMExcelImporter utility, import the Excel data into RQM and you should see the data layout as shown below:
So, once you have the data imported, you can export this data to available PDF formats in RQM.
However the exported PDF does not display the image as you can see in the below snapshot:
Kiran Byrappa 270001YMWT Visits (939)
You may come across situation where you do not want a user in your Project Area to view data in a particular stream.
SunilKumarR 270001XXSY Visits (1122)
If you are looking for a simple tool to perform GET operation(s) on IBM Rational Quality Manager (RQM), then you are looking at the right post.
The RQM artifacts are exposed in XML format through the RQM's Reportable REST (REpresentation and State Transfer) API's. If you are in need to perform a quick GET (get XML) of the RQM artifacts without having to worry about the REST syntax and other nitty-gritties, then the "RQM GET" utility is a good option. This utility is built on the basis of the RQMUrlUtility and provides an interactive way to download the artifact XML using the artifact web IDs.
RQMGET requires a Java 6 (1.6) or greater.
-password : Login Password
-url : Https Url for the RQM application
Here is a sample command line trace of events on the RQM GET utility used to download artifact from an RQM server.
C:\>java -jar rqmget.jar -user clmadmin -password clmadmin -url http
You can download the RQM GET utility by clicking on RQMGETUtility.zip.
Kiran Byrappa 270001YMWT Visits (970)
Post upgrade of your CLM application you may come across the below error while trying to access any Project Areas in Rational Quality Manager.
The error occurs when QM is not deployed correctly which could be the result of an incomplete / improper upgrade process and when WebSphere cache was not cleaned prior to deploying 5.0.2 war file.
Checking the logs reveals the below error:
You may follow the below steps to redeploy QM:
3. Re-deploy QM.war
4. Redo the group mapping in WebSphere by following the below steps:
Map security roles to a user or repository group:
a) Go to Applications > Application Types > WebSphere enterprise applications.
e) Enter a search string to return your group names from the LDAP server. Click Search to run the query.
Kiran Byrappa 270001YMWT Visits (1048)
Post upgrade of CLM your attempt to login to Rational Quality Manager instance displays an error indicating that your server appears to be in bad state.
You may want to check the following to ensure that the required services are setup properly and are up and running.
Kiran Byrappa 270001YMWT Visits (1120)
This article discusses how you can identify the "Actual Start and End Dates" in Rational Quality Manager.
There will be instances where a testing effort would be delayed and one needs to capture the actual date it started as apposed to the planned date it was supposed to be started.
The planned start and end dates are inherited from the dates in the timeline, as are the actual dates that are shown in brackets next to the iteration name.
The following steps lists the steps you will need to perform to edit the Actual dates:
1. Navigate to 'Test Plan > Test Schedule'
3. Edit the dates under the Planned Start Date and enter the description as required
Also, the other way is to define the "Custom attributes" in the test plan where you will need to manually enter the Proposed / Actual Start / End dates.
When you are defining the custom attributes you may mark the 'Planned/Proposed Start and End Dates" as "Required" so that one cannot save the test plan without specifying the planned dates.
While creating the test plan this should look like below:
You can use the "Browse Test Plans" and compare the 'Actual Start / End Dates' Vs 'Planned / Proposed Start / END Dates".
Rajeshavanthi 2700022MCX Visits (716)
For Example, look at the below screenshot where few execution states are renamed.
The generated report, for example "TSE
STEPS TO REPRODUCE:
1. Navigate to Manage Project Properties → Execution States and rename the existing Execution state Permanently Failed to Unavailable.
2. Save the Changes
3. Log out and log back in
4. Create a Test Suite with a few Test Cases
5. Run the Test Suite. Set each of the Test Case results to Unavailable
6. Browse the TCER's and verify the results are set to Unavailable
7. Run the “TSER using Test Case Count (Live)” Report".
8. Note that the column names and Graphs do not reflect the modifications done to the execution states
This behavior is identified as a product defect
Rajeshavanthi 2700022MCX Visits (1233)
In a very typical scenario, To create a test, many testers currently sit at a PC and alternate between completing an action in the application under test and writing the step on a notepad. When the test is complete on paper, the tester (or in some cases an administrative assistant for the testing group) types the steps into a standard test template, frequently using either Microsoft Word or Microsoft Excel. Following this procedure, a single manual test is essentially written twice.
Eliminating the need to write each test twice can save you time for other testing.
In addition to writing tests twice, much time is spent adapting existing tests for similar new tests. For example, a tester might create a test to log into the application under test as an administrator, and then adapt that test to log into the application under test as a regular user. This adaptation typically takes one of two forms:
• Open the existing test, edit steps as needed, and save the test with a new filename.
• Open a new test template, copy steps from the existing test, edit steps as needed, and save the new test.
Reducing duplication among many tests reduces the time you spend maintaining test scripts.
Testers typically receive many new software builds during a development cycle, often at an increasingly rapid rate toward the end of the cycle.
When a build contains a new feature or a fix that requires modifying the steps of a test, all of the tests that relate to the new feature or fix must be updated to reflect the change in the application under test. Although this update process is not difficult to manage when only a few tests require updating, when dozens (or hundreds) of tests are affected by changes to a commonly used area of the application under test, such as a login screen, updating can be very time-consuming. Eliminating or reducing the work that is required to keep many tests up to date can save you time for additional testing.
As you increase the efficiency of your testing effort, you can use the saved time to conduct additional tests. Rational Quality Manager can help you work more efficiently in each of the testing activities:
• Creating tests: Rational Quality Manager helps you to manage reusable content and use it in similar tests. As a result, you spend less time authoring tests.
• Running tests: Rational Quality Manager associates text to be typed in the application under test with an execution step. Rational Quality Manager also associates verification text with a test step, and then compares the comparison. Rational Quality Manager provides test data variables so that you can define a test once and run it many times to accommodate different data input values. These features save you time typing in the application under test, comparing actual to expected results, and testing different data values.
• Reporting test results: Rational Quality Manager provides customizable reports that reflect test result data from all phases of the project. These reports save time that you would have spent manually tabulating test results for reporting.
• Maintaining tests: Rational Quality Manager reduces the amount of required test maintenance by storing reusable content only once. As a result, you spend less time updating many similar tests.
IBM Rational Quality Manager: Execution variable displays deleted when execution status is changed from Approved to re-open
Rajeshavanthi 2700022MCX Visits (732)
Under IBM Rational Quality Manager v4.0.3 , say you have added a few execution variables and these variables are assigned to Test Steps for a given Test Case.
Modified date: Mar 25, 2015 1:19:33 PM
From the UI perspective; the Execution Variables are still associated with each of the steps; however, the Execution Variables View is empty. So basically there are two issues here.
dmmckinn 1200006SCS Visits (1438)
Are you planning an upgrade to a newer release of IBM Rational Team Concert (RTC), Rational Quality Manager (RQM), Rational Requirements Composer (RRC), Rational DOORS Next Generation (DNG) or your Jazz Team Server (JTS) and unsure about whether or not your clients or servers need to be upgraded together or can be upgraded separately?
AcdntlPoet 2700019V2G Visits (1830)
Stéphane Leroy (Unleash the Labs CLM, IBM Software Engineer) has created a wonderfully simple table to outline the Test Lab mana
And don't miss Stéphane's most recent posts surrounding his expertise in RTC and enterprise modernization!
How to create a full link after checking 'Save partial changes' in Rational Quality Manager linked to DOORS
Maeve OReilly 270001WE6Q Visits (1269)
The missing links are identified and can be fixed by the broken link icon.
This has been implemented as a user setting. A customer recently asked why is this not the default? Well, consider the actual impact of this if you have thousands of test cases linked to requirements. It will send thousands of requests to DWA. With hundreds of users, DWA would need to be scaled to manage that increase in load. I would leave this feature for the users who need it. I would not activate it for every user as every user is not interested in the link status.
Maeve OReilly 270001WE6Q Visits (1443)
I most commonly see DOORS Web Access (DWA) installed on its own server and I prefer this for two reasons:
An important related note is that DWA should be close to the DOORS database server. A ping should be less than 50ms between where the database server is running and where DWA is running. I have twice seen DWA put in a remote location (a different city), with ping times significantly in excess of 50ms. The performance was unacceptable with operations such as login and opening modules timing out.
Maeve OReilly 270001WE6Q Visits (1472)
There was a time when either was fine. And it still is if you are only using DWA (DOORS Web Access). However, if DWA is used to integrate with other browser based applications, this becomes a critical point.