Import TCER from XLS for existing Test cases in RQM
Hi,
I am trying to import TCER from XLS using the ExcelImporter tool. My problem is, the server reports an internal error 500, with no clues on what went wrong. The logs down below are from tring to import one single TCER to one test case to check what happens. From the logs it seems to find the test case (sending pooled link...), but this happens after it tried to save the TCER.
Any ideas of how to achieve this / what I am doing wrong?
The test cases were previously imported, so I am trying to use this config:
executionworkitem.XLSStartRow=2
executionworkitem.XLSDelimeter=\n
executionworkitem.XLSArtifactID=J
executionworkitem.XLSLink=testcase
executionworkitem.dc:title=C
executionworkitem.testcase=LinkExisting(K) -->On K column I have "urn:com.ibm.rqm:testcase:45586" which is an existing TC in RQM
My log:
6/15/2018 11:12:25 AM:
--------------------------------------------------------------------------------
6/15/2018 11:12:25 AM:
SESSION: 6/15/2018 11:12:25 AM
6/15/2018 11:12:25 AM: Getting artifacts from current document RQM_ExportGoTestResults_2TestCasesOnly.xls
6/15/2018 11:12:25 AM: Created 1 artifacts, sending to server
6/15/2018 11:12:25 AM: sending executionworkitem0 named 1001
6/15/2018 11:12:25 AM: Server returned code InternalServerError
6/15/2018 11:12:25 AM: Error sending to server 1001 of type executionworkitem
6/15/2018 11:12:25 AM: Internal Server Error
6/15/2018 11:12:25 AM: Server returned code: OK
6/15/2018 11:12:25 AM: Sending pooled link request for urn:com.ibm.rqm:testcase:45586
6/15/2018 11:12:26 AM: Server returned code: OK
6/15/2018 11:12:26 AM: finished writing artifacts
And my MSO2RQM log:
SESSION: 6/15/2018 11:12:25 AM
6/15/2018 11:12:25 AM: Getting artifacts from current document RQM_ExportGoTestResults_2TestCasesOnly.xls
6/15/2018 11:12:25 AM: Created 1 artifacts, sending to server
6/15/2018 11:12:25 AM: INFO: <Unknown Caller Context>: ExportRepositoryDialog.reqUrl :
6/15/2018 11:12:25 AM: sending executionworkitem0 named 1001
6/15/2018 11:12:25 AM: ERROR: <Unknown Caller Context>: RQMConnector: PutToServer - Error putting resource: https://bt-clmserver01.hqs.sbt.siemens.com/qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/CPS%2bFire%2bPeripherals%2b%2528qm%2529/executionworkitem/1001
6/15/2018 11:12:25 AM: ERROR: <Unknown Caller Context>: The remote server returned an error: (500) Internal Server Error.
6/15/2018 11:12:25 AM: EXCEPTION: : The remote server returned an error: (500) Internal Server Error.
6/15/2018 11:12:25 AM: at System.Net.HttpWebRequest.GetResponse()
at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)
6/15/2018 11:12:25 AM: ERROR: <Unknown Caller Context>: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><ns2:Error xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" xmlns:ns1="http://schema.ibm.com/vega/2008/" xmlns:ns4="http://jazz.net/xmlns/prod/jazz/process/0.6/" xmlns:ns3="http://purl.org/dc/elements/1.1/" xmlns:ns6="http://purl.org/dc/terms/" xmlns:ns20="http://jazz.net/xmlns/alm/qm/styleinfo/v0.1/" xmlns:ns5="http://jazz.net/xmlns/alm/v0.1/" xmlns:ns8="http://jazz.net/xmlns/alm/qm/v0.1/testscript/v0.1/" xmlns:ns7="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:ns13="http://www.w3.org/2002/07/owl#" xmlns:ns9="http://jazz.net/xmlns/alm/qm/v0.1/executionworkitem/v0.1" xmlns:ns12="http://jazz.net/xmlns/prod/jazz/rqm/process/1.0/" xmlns:ns11="http://open-services.net/ns/qm#" xmlns:ns10="http://open-services.net/ns/core#" xmlns:ns21="http://www.w3.org/1999/XSL/Transform" xmlns:ns17="http://jazz.net/xmlns/alm/qm/v0.1/catalog/v0.1" xmlns:ns16="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1" xmlns:ns15="http://jazz.net/xmlns/alm/qm/qmadapter/task/v0.1" xmlns:ns14="http://jazz.net/xmlns/alm/qm/qmadapter/v0.1" xmlns:ns18=">http://jazz.net/xmlns/alm/qm/v0.1/tsl/v0.1/"><ns2:statusCode>500</ns2:statusCode><ns2:message>Internal server error</ns2:message></ns2:Error>
6/15/2018 11:12:25 AM: Server returned code: OK
6/15/2018 11:12:25 AM: Sending pooled link request for urn:com.ibm.rqm:testcase:45586
6/15/2018 11:12:26 AM: Server returned code: OK
6/15/2018 11:12:26 AM: finished writing artifacts
6/15/2018 11:12:26 AM: INFO: <Unknown Caller Context>: Exporting completed with 1 failures!
One answer
Hi Jorge,