RQM Excel importer error, Error sending to server ** of type executionworkitem
![]()
We are experiencing an issue when using the RQM excel importer to import test cases and results into RQM. Our excel file consists of the test case, execution record and result on one line of the excel. A second test case, execution record and result exist on the next line. When we run the import, the import finishes, but we are receiving the following error Error sending to server tcerid20006 of type executionworkitem
When reviewing the test cases in RQM, both results are getting placed on one test cases, which is not the expected and desired outcome. One line on the excel comprises all of the details for test case A and the next line for test case B. What else do we need to include on our config file to insure that one line on the excel is processed completely, before the next line?
Details of the import:
Sending testcase 0 named 20007...
Sending testcase 1 named 20006...
Sending executionworkitem 2 named tcerid20007...
Sending executionworkitem 3 named tcerid20006...
Error sending to server tcerid20006 of type executionworkitem
Sending executionresult 4 named resultid20006_01...
Sending executionresult 5 named resultid20007_01...
Exporting completed with 1 failures!
Details of config file:
testcase.customAttributes identifier="QC_TC_ID".name="External Test Case ID".type="Integer".value=A
// static test case definition
testcase.XLSStartRow=2
testcase.XLSArtifactID=A
testcase.dc:title=B
testcase.dc:description=B
// static configured testcase definition with link to testcase
executionworkitem.XLSStartRow=2
executionworkitem.XLSArtifactID=C
executionworkitem.XLSLink=testcase
executionworkitem.dc:title=D
executionworkitem.dc:description=D
// result definition starting at line 2 in the spreadsheet
executionresult.XLSStartRow=2
executionresult.XLSArtifactID=E
executionresult.XLSLink=executionworkitem
executionresult.dc:title=F
executionresult.er:details=F
executionresult.jzalm:state=I
executionresult.er:starttime=G
executionresult.er:endtime=H
//links all results to all of the configured testcases in the worksheet.
|
Accepted answer
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.