Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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!

0 votes



One answer

Permanent link

 Hi Jorge,


Anytime the RQM server returns a 500 (Internal Server Error) response, it's a defect.  Please open a RQM defect (https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.newWorkItem).

0 votes

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,927

Question asked: Jun 15 '18, 5:18 a.m.

Question was seen: 1,804 times

Last updated: Jun 26 '18, 1:47 p.m.

Confirmation Cancel Confirm