It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,961

question asked: Apr 24 '12, 9:26 a.m.
question was seen: 5,698 times
last updated: Apr 24 '12, 9:26 a.m.

Related questions

Import Testcase and Requirement with RQM ExcelImporter

0
Magnus Klöker (26●2●2) | asked Apr 24 '12, 9:26 a.m.
Hello,

i cant import/create a requirement with the RQM ExcelImporter, but my config work with RQM 2.0.1.1. The test cases are work fine.
This error message i will find in the Logfiles
4/24/2012 3:08:04 PM: sending requirement0 named 1.42_IT-31526

4/24/2012 3:08:04 PM: ERROR: : RQMConnector: PutToServer - Error putting resource: https://rthpweb007.ihost.com:9440/qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Vodafone%2b%2528KBA-COM%2529%2bTEST/requirement/1.42_IT-31526

4/24/2012 3:08:04 PM: EXCEPTION: : The remote server returned an error: (500) Internal Server Error.

4/24/2012 3:08:04 PM: at System.Net.HttpWebRequest.GetResponse()
at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)

4/24/2012 3:08:04 PM: ERROR: : The remote server returned an error: (500) Internal Server Error.

4/24/2012 3:08:04 PM: Error sending to server 1.42_IT-31526 of type requirement

4/24/2012 3:08:04 PM: ERROR: : ExcelExportRepositoryDialog: Error saving to url https://rthpweb007.ihost.com:9440/qm of type requirement

4/24/2012 3:08:04 PM: EXCEPTION: : Object reference not set to an instance of an object.

4/24/2012 3:08:04 PM: at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)
at RQMExcelExporter.ExcelExportRepositoryDialog.doExport(IList`1 artifacts)


RQM Version: 3.0.1

This is my Config

//---Requirements
//Start looking for requirements after row 4
requirement.XLSStartRow=2
requirement.XLSArtifactID=C2
requirement.dc:title=E2
requirement.dc:description=D2
requirement.jzalm:owner=F2
requirement.dc:creator=F2

// this configuration file creates testscripts with testcases using self referential
// and column based data with categories
// Start looking for scripts after row 3
testscript.XLSWorksheetID="Test Cases"
testscript.XLSStartRow=5

// a new script starts when we encounter an empty row
//testscript.dc:description=H
testscript.XLSDelimeter=\n
testscript.dc:title=D


// step type is defined within the spreadsheet
testscript.steps.type="execution"
testscript.alm:state ="com.ibm.rqm.planning.common.approved"
testscript.steps.description=Q
testscript.steps.title=Q
testscript.steps.name=Q
testscript.steps.expectedResult=R

testcase.XLSWorksheetID="Test Cases"
testcase.XLSStartRow=5
testcase.XLSDelimeter=\n

testcase.XLSLink=requirement

// self referential links must be declared before also using column definitions
testcase.dc:title=testscript.dc:title
testcase.alm:state="com.ibm.rqm.planning.common.approved"
testcase.dc:description=testscript.dc:description
testcase.weight=L

// Categories are defined in a special way
testcase.category term="COM-WF".value=I
testcase.category term="Theme".value=F
testcase.category term="Subtheme".value=G
testcase.category term="Transaction".value=H
testcase.category term="Area".value=E
testcase.category term="Test Phase".value=J
testcase.category term="Customer Type".value=K
testcase.category term="IT-Requirement".value=C

// Sections are defined differently, the first part within the quotes is the section tag, and the optional second part after the comma
// defines the name of the section. Sections that already defined within RQM will use the display name they already have
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=M
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","Expected Results")=O
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=N


Is my Config for RQM 3.0.1 wrong or what is my Problem? Below u find the XML what is send.

4/24/2012 3:07:51 PM: INFO: : response from project contained <xml>
<feed>
<id>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects</id>
<link>
<link>
<entry><id>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/Test+Lifecycle+Project+%28Quality+Management%29</id><title>Test Lifecycle Project (Quality Management)</title><summary>Alias: Test+Lifecycle+Project+%28Quality+Management%29</summary><link></link><content><project><ns3>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/Test+Lifecycle+Project+%28Quality+Management%29</ns3><ns3>Test Lifecycle Project (Quality Management)</ns3><ns3>Alias: Test+Lifecycle+Project+%28Quality+Management%29</ns3><alias>Test+Lifecycle+Project+%28Quality+Management%29</alias><settingsids><settingid>com.ibm.rqm.sharedresourcelocation</settingid><settingid>com.ibm.rqm.testcasesystem</settingid><settingid>com.ibm.rqm.rqmrelatedlinks</settingid><settingid>com.ibm.rqm.planningobjective</settingid><settingid>com.ibm.rqm.risk</settingid><settingid>com.ibm.rqm.planningpreference</settingid><settingid>com.ibm.rqm.executionpreference</settingid><settingid>com.ibm.rqm.category</settingid><settingid>com.ibm.rqm.execution</settingid><settingid>com.ibm.rqm.buildintegration</settingid><settingid>com.ibm.rqm.manualscriptdictionary</settingid><settingid>com.ibm.rqm.artifactstatetransitionconstraints</settingid><settingid>com.ibm.rqm.reporting</settingid></settingsids></project></content><link></link></entry><entry><id>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/Vodafone+%28KBA-COM%29+TEST</id><title>Vodafone KBA-COM TEST</title><summary>Alias: Vodafone+%28KBA-COM%29+TEST</summary><link></link><content><project><ns3>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/Vodafone+%28KBA-COM%29+TEST</ns3><ns3>Vodafone KBA-COM TEST</ns3><ns3>Alias: Vodafone+%28KBA-COM%29+TEST</ns3><alias>Vodafone+%28KBA-COM%29+TEST</alias><settingsids><settingid>com.ibm.rqm.sharedresourcelocation</settingid><settingid>com.ibm.rqm.testcasesystem</settingid><settingid>com.ibm.rqm.rqmrelatedlinks</settingid><settingid>com.ibm.rqm.planningobjective</settingid><settingid>com.ibm.rqm.risk</settingid><settingid>com.ibm.rqm.planningpreference</settingid><settingid>com.ibm.rqm.executionpreference</settingid><settingid>com.ibm.rqm.category</settingid><settingid>com.ibm.rqm.execution</settingid><settingid>com.ibm.rqm.buildintegration</settingid><settingid>com.ibm.rqm.manualscriptdictionary</settingid><settingid>com.ibm.rqm.artifactstatetransitionconstraints</settingid><settingid>com.ibm.rqm.reporting</settingid></settingsids></project></content><link></link></entry><entry><id>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/BMW+Bank+%28AMS%29+Test%28Quality+Management%29</id><title>BMW Bank (AMS) Test(Quality Management)</title><summary>Alias: BMW+Bank+%28AMS%29+Test%28Quality+Management%29</summary><link></link><content><project><ns3>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/BMW+Bank+%28AMS%29+Test%28Quality+Management%29</ns3><ns3>BMW Bank (AMS) Test(Quality Management)</ns3><ns3>Alias: BMW+Bank+%28AMS%29+Test%28Quality+Management%29</ns3><alias>BMW+Bank+%28AMS%29+Test%28Quality+Management%29</alias><settingsids><settingid>com.ibm.rqm.sharedresourcelocation</settingid><settingid>com.ibm.rqm.testcasesystem</settingid><settingid>com.ibm.rqm.rqmrelatedlinks</settingid><settingid>com.ibm.rqm.planningobjective</settingid><settingid>com.ibm.rqm.risk</settingid><settingid>com.ibm.rqm.planningpreference</settingid><settingid>com.ibm.rqm.executionpreference</settingid><settingid>com.ibm.rqm.category</settingid><settingid>com.ibm.rqm.execution</settingid><settingid>com.ibm.rqm.buildintegration</settingid><settingid>com.ibm.rqm.manualscriptdictionary</settingid><settingid>com.ibm.rqm.artifactstatetransitionconstraints</settingid><settingid>com.ibm.rqm.reporting</settingid></settingsids></project></content><link></link></entry><entry><id>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/MeTA+in+a+box+%28Quality+Management%29</id><title>MeTA in a box (Quality Management)</title><summary>Alias: MeTA+in+a+box+%28Quality+Management%29</summary><link></link><content><project><ns3>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/MeTA+in+a+box+%28Quality+Management%29</ns3><ns3>MeTA in a box (Quality Management)</ns3><ns3>Alias: MeTA+in+a+box+%28Quality+Management%29</ns3><alias>MeTA+in+a+box+%28Quality+Management%29</alias><settingsids><settingid>com.ibm.rqm.sharedresourcelocation</settingid><settingid>com.ibm.rqm.testcasesystem</settingid><settingid>com.ibm.rqm.rqmrelatedlinks</settingid><settingid>com.ibm.rqm.planningobjective</settingid><settingid>com.ibm.rqm.risk</settingid><settingid>com.ibm.rqm.planningpreference</settingid><settingid>com.ibm.rqm.executionpreference</settingid><settingid>com.ibm.rqm.category</settingid><settingid>com.ibm.rqm.execution</settingid><settingid>com.ibm.rqm.buildintegration</settingid><settingid>com.ibm.rqm.manualscriptdictionary</settingid><settingid>com.ibm.rqm.artifactstatetransitionconstraints</settingid><settingid>com.ibm.rqm.reporting</settingid></settingsids></project></content><link></link></entry></feed>

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Hao Wan (1.5k●3●5) | answered Apr 24 '12, 9:35 p.m.
JAZZ DEVELOPER
Hi @kloemag,
which version of ExcelImporter and RQM server and RM server are you using when you met the problem?

from Excel Importer4.0, the requirements are created through OSLC.

Hello,

i cant import/create a requirement with the RQM ExcelImporter, but my config work with RQM 2.0.1.1. The test cases are work fine.
This error message i will find in the Logfiles
4/24/2012 3:08:04 PM: sending requirement0 named 1.42_IT-31526

4/24/2012 3:08:04 PM: ERROR: : RQMConnector: PutToServer - Error putting resource: https://rthpweb007.ihost.com:9440/qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Vodafone%2b%2528KBA-COM%2529%2bTEST/requirement/1.42_IT-31526

4/24/2012 3:08:04 PM: EXCEPTION: : The remote server returned an error: (500) Internal Server Error.

4/24/2012 3:08:04 PM: at System.Net.HttpWebRequest.GetResponse()
at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)

4/24/2012 3:08:04 PM: ERROR: : The remote server returned an error: (500) Internal Server Error.

4/24/2012 3:08:04 PM: Error sending to server 1.42_IT-31526 of type requirement

4/24/2012 3:08:04 PM: ERROR: : ExcelExportRepositoryDialog: Error saving to url https://rthpweb007.ihost.com:9440/qm of type requirement

4/24/2012 3:08:04 PM: EXCEPTION: : Object reference not set to an instance of an object.

4/24/2012 3:08:04 PM: at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)
at RQMExcelExporter.ExcelExportRepositoryDialog.doExport(IList`1 artifacts)


RQM Version: 3.0.1

This is my Config

//---Requirements
//Start looking for requirements after row 4
requirement.XLSStartRow=2
requirement.XLSArtifactID=C2
requirement.dc:title=E2
requirement.dc:description=D2
requirement.jzalm:owner=F2
requirement.dc:creator=F2

// this configuration file creates testscripts with testcases using self referential
// and column based data with categories
// Start looking for scripts after row 3
testscript.XLSWorksheetID="Test Cases"
testscript.XLSStartRow=5

// a new script starts when we encounter an empty row
//testscript.dc:description=H
testscript.XLSDelimeter=\n
testscript.dc:title=D


// step type is defined within the spreadsheet
testscript.steps.type="execution"
testscript.alm:state ="com.ibm.rqm.planning.common.approved"
testscript.steps.description=Q
testscript.steps.title=Q
testscript.steps.name=Q
testscript.steps.expectedResult=R

testcase.XLSWorksheetID="Test Cases"
testcase.XLSStartRow=5
testcase.XLSDelimeter=\n

testcase.XLSLink=requirement

// self referential links must be declared before also using column definitions
testcase.dc:title=testscript.dc:title
testcase.alm:state="com.ibm.rqm.planning.common.approved"
testcase.dc:description=testscript.dc:description
testcase.weight=L

// Categories are defined in a special way
testcase.category term="COM-WF".value=I
testcase.category term="Theme".value=F
testcase.category term="Subtheme".value=G
testcase.category term="Transaction".value=H
testcase.category term="Area".value=E
testcase.category term="Test Phase".value=J
testcase.category term="Customer Type".value=K
testcase.category term="IT-Requirement".value=C

// Sections are defined differently, the first part within the quotes is the section tag, and the optional second part after the comma
// defines the name of the section. Sections that already defined within RQM will use the display name they already have
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=M
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","Expected Results")=O
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=N


Is my Config for RQM 3.0.1 wrong or what is my Problem? Below u find the XML what is send.

4/24/2012 3:07:51 PM: INFO: : response from project contained <xml>
<feed>
<id>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects</id>
<link>
<link>
<entry><id>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/Test+Lifecycle+Project+%28Quality+Management%29</id><title>Test Lifecycle Project (Quality Management)</title><summary>Alias: Test+Lifecycle+Project+%28Quality+Management%29</summary><link></link><content><project><ns3>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/Test+Lifecycle+Project+%28Quality+Management%29</ns3><ns3>Test Lifecycle Project (Quality Management)</ns3><ns3>Alias: Test+Lifecycle+Project+%28Quality+Management%29</ns3><alias>Test+Lifecycle+Project+%28Quality+Management%29</alias><settingsids><settingid>com.ibm.rqm.sharedresourcelocation</settingid><settingid>com.ibm.rqm.testcasesystem</settingid><settingid>com.ibm.rqm.rqmrelatedlinks</settingid><settingid>com.ibm.rqm.planningobjective</settingid><settingid>com.ibm.rqm.risk</settingid><settingid>com.ibm.rqm.planningpreference</settingid><settingid>com.ibm.rqm.executionpreference</settingid><settingid>com.ibm.rqm.category</settingid><settingid>com.ibm.rqm.execution</settingid><settingid>com.ibm.rqm.buildintegration</settingid><settingid>com.ibm.rqm.manualscriptdictionary</settingid><settingid>com.ibm.rqm.artifactstatetransitionconstraints</settingid><settingid>com.ibm.rqm.reporting</settingid></settingsids></project></content><link></link></entry><entry><id>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/Vodafone+%28KBA-COM%29+TEST</id><title>Vodafone KBA-COM TEST</title><summary>Alias: Vodafone+%28KBA-COM%29+TEST</summary><link></link><content><project><ns3>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/Vodafone+%28KBA-COM%29+TEST</ns3><ns3>Vodafone KBA-COM TEST</ns3><ns3>Alias: Vodafone+%28KBA-COM%29+TEST</ns3><alias>Vodafone+%28KBA-COM%29+TEST</alias><settingsids><settingid>com.ibm.rqm.sharedresourcelocation</settingid><settingid>com.ibm.rqm.testcasesystem</settingid><settingid>com.ibm.rqm.rqmrelatedlinks</settingid><settingid>com.ibm.rqm.planningobjective</settingid><settingid>com.ibm.rqm.risk</settingid><settingid>com.ibm.rqm.planningpreference</settingid><settingid>com.ibm.rqm.executionpreference</settingid><settingid>com.ibm.rqm.category</settingid><settingid>com.ibm.rqm.execution</settingid><settingid>com.ibm.rqm.buildintegration</settingid><settingid>com.ibm.rqm.manualscriptdictionary</settingid><settingid>com.ibm.rqm.artifactstatetransitionconstraints</settingid><settingid>com.ibm.rqm.reporting</settingid></settingsids></project></content><link></link></entry><entry><id>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/BMW+Bank+%28AMS%29+Test%28Quality+Management%29</id><title>BMW Bank (AMS) Test(Quality Management)</title><summary>Alias: BMW+Bank+%28AMS%29+Test%28Quality+Management%29</summary><link></link><content><project><ns3>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/BMW+Bank+%28AMS%29+Test%28Quality+Management%29</ns3><ns3>BMW Bank (AMS) Test(Quality Management)</ns3><ns3>Alias: BMW+Bank+%28AMS%29+Test%28Quality+Management%29</ns3><alias>BMW+Bank+%28AMS%29+Test%28Quality+Management%29</alias><settingsids><settingid>com.ibm.rqm.sharedresourcelocation</settingid><settingid>com.ibm.rqm.testcasesystem</settingid><settingid>com.ibm.rqm.rqmrelatedlinks</settingid><settingid>com.ibm.rqm.planningobjective</settingid><settingid>com.ibm.rqm.risk</settingid><settingid>com.ibm.rqm.planningpreference</settingid><settingid>com.ibm.rqm.executionpreference</settingid><settingid>com.ibm.rqm.category</settingid><settingid>com.ibm.rqm.execution</settingid><settingid>com.ibm.rqm.buildintegration</settingid><settingid>com.ibm.rqm.manualscriptdictionary</settingid><settingid>com.ibm.rqm.artifactstatetransitionconstraints</settingid><settingid>com.ibm.rqm.reporting</settingid></settingsids></project></content><link></link></entry><entry><id>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/MeTA+in+a+box+%28Quality+Management%29</id><title>MeTA in a box (Quality Management)</title><summary>Alias: MeTA+in+a+box+%28Quality+Management%29</summary><link></link><content><project><ns3>https://rthpweb007.ihost.com:9440/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/MeTA+in+a+box+%28Quality+Management%29</ns3><ns3>MeTA in a box (Quality Management)</ns3><ns3>Alias: MeTA+in+a+box+%28Quality+Management%29</ns3><alias>MeTA+in+a+box+%28Quality+Management%29</alias><settingsids><settingid>com.ibm.rqm.sharedresourcelocation</settingid><settingid>com.ibm.rqm.testcasesystem</settingid><settingid>com.ibm.rqm.rqmrelatedlinks</settingid><settingid>com.ibm.rqm.planningobjective</settingid><settingid>com.ibm.rqm.risk</settingid><settingid>com.ibm.rqm.planningpreference</settingid><settingid>com.ibm.rqm.executionpreference</settingid><settingid>com.ibm.rqm.category</settingid><settingid>com.ibm.rqm.execution</settingid><settingid>com.ibm.rqm.buildintegration</settingid><settingid>com.ibm.rqm.manualscriptdictionary</settingid><settingid>com.ibm.rqm.artifactstatetransitionconstraints</settingid><settingid>com.ibm.rqm.reporting</settingid></settingsids></project></content><link></link></entry></feed>
0
permanent link
Magnus Klöker (26●2●2) | answered Apr 25 '12, 5:00 a.m.
Hello, i use the RQM ExcelImporter 1.0.4387.9167

About the Requirements Management Application

Build Information Version Build ID
Jazz Foundation - Core Libraries 3.0.1.2 RJF-I20111207-1350
Requirements Management - Core Libraries 3.0.1.2 I20111221_1303
About the Rational Jazz Team Server

Build Information Version Build ID
Jazz Foundation - Core Libraries 3.0.1.2 RJF-I20111207-1350
Client Access License Types Assigned to user Magnus Kloeker

Product Edition Type
Rational Quality Manager Quality Professional-Floating


Hi @kloemag,
which version of ExcelImporter and RQM server and RM server are you using when you met the problem?

from Excel Importer4.0, the requirements are created through OSLC.

0
permanent link
Magnus Klöker (26●2●2) | answered Apr 25 '12, 5:03 a.m.
Hello, i use the RQMExcelImporter 1.0.4387.9167

About the Requirements Management Application

Jazz Foundation - Core Libraries 3.0.1.2
Requirements Management - Core Libraries 3.0.1.2
Rational Quality Manager 3.0.1

Hi @kloemag,
which version of ExcelImporter and RQM server and RM server are you using when you met the problem?

from Excel Importer4.0, the requirements are created through OSLC.
0
permanent link
Hao Wan (1.5k●3●5) | answered Apr 25 '12, 9:53 p.m.
JAZZ DEVELOPER
Hi @kloemag,
would you please have a try with the following steps:
1. using "Export to File", and export you excel to local xml file.
and copy one of the requirement XML content to Poster.

2. in the URL input form in Poster input
https://rthpweb007.ihost.com:9440/qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Vodafone%2b%2528KBA-COM%2529%2bTEST/requirement

3. do a "POST" request.

does it import successfully?

Hello, i use the RQM ExcelImporter 1.0.4387.9167

About the Requirements Management Application

Build Information Version Build ID
Jazz Foundation - Core Libraries 3.0.1.2 RJF-I20111207-1350
Requirements Management - Core Libraries 3.0.1.2 I20111221_1303
About the Rational Jazz Team Server

Build Information Version Build ID
Jazz Foundation - Core Libraries 3.0.1.2 RJF-I20111207-1350
Client Access License Types Assigned to user Magnus Kloeker

Product Edition Type
Rational Quality Manager Quality Professional-Floating


Hi @kloemag,
which version of ExcelImporter and RQM server and RM server are you using when you met the problem?

from Excel Importer4.0, the requirements are created through OSLC.

Your answer

Register or 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.