import test execution record for certain test case using RQM excel import tool
Hi, I'm trying to import a test Execution record for a test case (Which was already created in RQM). My Question is How do I link the test Execution Record to a test case during the import?
Assume I want my execution record link to a test case name "MyTest" and this string locate in A1 of the excel spreadsheet.
My cfg file look like this:
executionworkitem.XLSStartRow=1
executionworkitem.dc:title=I
executionworkitem.alm:owner=H
executionworkitem.dc:description=D2
executionworkitem.testcase=A1
I keep getting Internal error (500). And I looked at the log file AppData\Roaming\Mso2Rqm it has the following message:
"Internal server error</ns2:message><ns2:trace>com.ibm.team.repository.common.TeamRepositoryException: Testcase is required for creating TER
at com.ibm.rqm.execution.service.internal.rest.TestcaseExecutionRecordRestService.helperPostWorkItem(TestcaseExecutionRecordRestService.java:1166)
at com.ibm.rqm.execution.service.internal.rest.TestcaseExecutionRecordRestService.postWorkItemEx(TestcaseExecutionRecordRestService.java:1155)
at sun.reflect.GeneratedMethodAccessor2151.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
"
The error message is long I just posted part of it. I just wonder if the way I specified the test case is wrong. I have seen some post that use XLSArtifactID for the testcase value, but I don't have XLSArtifactID for my testcase. Would anybody please help me on this. Thanks
Assume I want my execution record link to a test case name "MyTest" and this string locate in A1 of the excel spreadsheet.
My cfg file look like this:
executionworkitem.XLSStartRow=1
executionworkitem.dc:title=I
executionworkitem.alm:owner=H
executionworkitem.dc:description=D2
executionworkitem.testcase=A1
I keep getting Internal error (500). And I looked at the log file AppData\Roaming\Mso2Rqm it has the following message:
"Internal server error</ns2:message><ns2:trace>com.ibm.team.repository.common.TeamRepositoryException: Testcase is required for creating TER
at com.ibm.rqm.execution.service.internal.rest.TestcaseExecutionRecordRestService.helperPostWorkItem(TestcaseExecutionRecordRestService.java:1166)
at com.ibm.rqm.execution.service.internal.rest.TestcaseExecutionRecordRestService.postWorkItemEx(TestcaseExecutionRecordRestService.java:1155)
at sun.reflect.GeneratedMethodAccessor2151.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
"
The error message is long I just posted part of it. I just wonder if the way I specified the test case is wrong. I have seen some post that use XLSArtifactID for the testcase value, but I don't have XLSArtifactID for my testcase. Would anybody please help me on this. Thanks
Accepted answer
Hi Giang,
you can check the id of the testcase you want to link to the executionworkitem and using link() modifier.
executionworkitem.testcase=Link("testcase internal/external id")
you can check the id of the testcase you want to link to the executionworkitem and using link() modifier.
executionworkitem.testcase=Link("testcase internal/external id")
Internal ID
Numerical ID unique for the resource within a Rational Quality Manager server. For many resources, these IDs are shown in Rational Quality Manager. When using an internal ID in the Reportable REST API to refer to a resource, the ID MUST be prepended by
urn:com.ibm.rqm: <resource>:
. For example, a test case internal ID would be "urn:com.ibm.rqm:testcase:9". Note, an Internal ID should NEVER be used when doing a PUT to create a new resource, since the resource is assumed to exist and updated or an error is returned if the resource is not found.
External ID
A unique ID provided by the user when creating a new resource with a PUT. Resources created in the Rational Quality Manager UI will not have external IDs. An external ID can contain any characters allowed in a URI (reserved characters except the '/' character MUST be URL encoded in PUT requests) and should NEVER contain
urn:com.ibm.rqm: <resource>:
(internal ID).
Comments
Thanks Hao for the response. but look like I still have the problem with it. I just wonder if I get the right id. how do you get the ID. Is the id the number that show next to the testcase name when I click on the testcase. for example my test case name is "MYTEST". When Click on the test case in RQM it show 8888:MYTEST on the top. is 8888 the id that I need to use.
Thanks
Hi Giang,
the id should be urn:com.ibm.rqm:testcase:8888 in your case.
Comments
Giang Pham
Mar 28 '13, 2:06 p.m.Hi, Hao. thanks for the response. But look like I still have problem with using the internal ID, how do you get the ID, is it the one that pop up next to Name of the test case name. for example if my test case name is "MYTEST". When I click to on the test case it show in the name 8888:MYTEST. Is 8888 the id that i have to use.
Thanks