It's all about the answers!

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

×10,958

question asked: Dec 15 '15, 2:44 a.m.
question was seen: 1,470 times
last updated: Jan 14 '16, 11:05 p.m.

Related questions

Problem when exporting many test cases

0
Daniel Gálvez (11●2) | asked Dec 15 '15, 2:44 a.m.
edited Dec 15 '15, 2:46 a.m. by Ralph Schoon (63.6k●3●36●46)
 Hi,

I have a problem when I export a excel doc to RQM with many tests cases. I press the button "Export", RQM Export only show "Creating Artifacts" and then it remain in the last state and it doesn't export any test case.

If my Excel document have few tests cases, I haven't got any problem.

I'm using Excel 2013 and version 5.0 of RQM.

Thanks.
Comments
William Chen commented Dec 16 '15, 11:45 a.m. | edited Jan 14 '16, 11:05 p.m.

Hi Daniel,

Can you upload the debug log?

The debug log file location:

C:\Documents and Settings\USER\Application Data\Mso2Rqm log directory, where USER is the ID of the user (pre-Windows 7)

C:\Documents and Settings\USER\AppData\Roaming\Mso2Rqm log directory, where USER is the ID of the user (Windows 7)

Cheers,
Will

Daniel Gálvez commented Dec 17 '15, 3:55 a.m.
Hi,
This is the docs:

 Log 
17/12/2015 9:39:33: 
--------------------------------------------------------------------------------
17/12/2015 9:39:33: 
SESSION: 17/12/2015 9:39:33

17/12/2015 9:39:33: Getting artifacts from current document Cliente3.xlsx
Daniel Gálvez commented Dec 17 '15, 3:59 a.m. | edited Jan 14 '16, 11:05 p.m.
Mso2Rqm_Debug

17/12/2015 8:40:04: 
SESSION: 17/12/2015 8:40:04


17/12/2015 8:40:04: INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands


17/12/2015 8:40:04: INFO: <Unknown Caller Context>: caption : RQM


17/12/2015 8:40:04: INFO: <Unknown Caller Context>: ExcelApplicationContext: Created commands


17/12/2015 9:39:20: INFO: <Unknown Caller Context>: response from project contained <?xml version="1.0" encoding="UTF-8"?><feed xmlns="http://www.w3.org/2005/Atom"><title type="text">projects ATOM feed for all project areas</title><id>https://adtclmemea00605.accenture.com/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects</id><link href="https://adtclmemea00605.accenture.com/qm/web/console/" rel="alternate"/><link rel="self" href="https://adtclmemea00605.accenture.com/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects"/><entry xmlns="http://www.w3.org/2005/Atom"><id>https://adtclmemea00605.accenture.com/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/ATG11ALI</id><updated></updated><title type="text">ATG11ALI</title><summary type="text">Alias: ATG11ALI</summary><link href="https://adtclmemea00605.accenture.com/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/ATG11ALI" rel="alternate" type="application/xml" title=""/><link href="https://adtclmemea00605.accenture.com/qm/web/console/ATG11ALI" rel="enclosure" type="text/html" title="Web Console"/><content type="application/xml"><ns2:project xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" xmlns:ns1="http://schema.ibm.com/vega/2008/" xmlns:ns3="http://purl.org/dc/elements/1.1/" xmlns:ns4="http://jazz.net/xmlns/prod/jazz/process/0.6/" xmlns:ns5="http://jazz.net/xmlns/alm/v0.1/" xmlns:ns6="http://purl.org/dc/terms/" xmlns:ns7="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:ns8="http://jazz.net/xmlns/alm/qm/v0.1/tsl/v0.1/" xmlns:ns9="http://jazz.net/xmlns/alm/qm/v0.1/testscript/v0.1/" xmlns:ns10="http://jazz.net/xmlns/alm/qm/qmadapter/task/v0.1" xmlns:ns11="http://jazz.net/xmlns/alm/qm/qmadapter/v0.1" xmlns:ns12="http://jazz.net/xmlns/alm/qm/v0.1/executionworkitem/v0.1" xmlns:ns13="http://open-services.net/ns/core#" xmlns:ns14="http://open-services.net/ns/qm#" xmlns:ns15="http://jazz.net/xmlns/prod/jazz/rqm/process/1.0/" xmlns:ns16="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1" xmlns:ns17="http://jazz.net/xmlns/alm/qm/v0.1/catalog/v0.1" xmlns:ns19="http://jazz.net/xmlns/alm/qm/styleinfo/v0.1/" xmlns:ns20="http://www.w3.org/1999/XSL/Transform"><ns3:identifier>https://adtclmemea00605.accenture.com/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/ATG11ALI</ns3:identifier><ns3:title>ATG11ALI</ns3:title><ns3:description>Alias: ATG11ALI</ns3:description><ns2:alias type="string">ATG11ALI</ns2:alias><ns2:settingsids><ns2:settingid>com.ibm.rqm.customattribute</ns2:settingid><ns2:settingid>com.ibm.rqm.testscript</ns2:settingid><ns2:settingid>com.ibm.rqm.category</ns2:settingid><ns2:settingid>com.ibm.rqm.reporting</ns2:settingid><ns2:settingid>com.ibm.rqm.artifactstatetransitionconstraints</ns2:settingid><ns2:settingid>com.ibm.rqm.executionpreference</ns2:settingid><ns2:settingid>com.ibm.rqm.requirememtrisk</ns2:settingid><ns2:settingid>com.ibm.rqm.buildintegration</ns2:settingid><ns2:settingid>com.ibm.rqm.manualscriptdictionary</ns2:settingid><ns2:settingid>com.ibm.rqm.sharedresourcelocation</ns2:settingid><ns2:settingid>com.ibm.rqm.execution</ns2:settingid><ns2:settingid>com.ibm.rqm.planningobjective</ns2:settingid><ns2:settingid>com.ibm.rqm.rqmrelatedlinks</ns2:settingid><ns2:settingid>com.ibm.rqm.risk</ns2:settingid><ns2:settingid>com.ibm.rqm.testcasesystem</ns2:settingid><ns2:settingid>com.ibm.rqm.planningpreference</ns2:settingid></ns2:settingsids></ns2:project></content></entry></feed>


17/12/2015 9:39:20: INFO: <Unknown Caller Context>: response from project has response content key

17/12/2015 9:39:20: INFO: <Unknown Caller Context>: response has keys: System.Collections.Hashtable+HashtableEnumerator


17/12/2015 9:39:33: 
--------------------------------------------------------------------------------

17/12/2015 9:39:33: 
SESSION: 17/12/2015 9:39:33


17/12/2015 9:39:33: Getting artifacts from current document Cliente3.xlsx
Daniel Gálvez commented Dec 17 '15, 4:01 a.m. | edited Jan 14 '16, 11:05 p.m.

 And my file configuration:


testscript.XLSStartRow=5
testscript.XLSArtifactID=J
testscript.dc:title=K
testscript.dc:description=J
testscript.steps.type="execution"
testscript.steps.description=N
testscript.steps.expectedResult=O
testscript.XLSDelimeter=\n
testcase.ID=testscript.XLSArtifactID
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description
testcase.XLSArtifactID=J
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=RichText(F)

Thank you!

William Chen commented Dec 17 '15, 6:25 p.m.

I have not seen this problem before but there might be a problem in your Excel file. A working import log should capture below information:

INFO: <Unknown Caller Context>: RQMExporter Startup!
INFO: <Unknown Caller Context>: Mso2Rqm: Mso2Rqm instantiated
INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands
INFO: <Unknown Caller Context>: caption : RQM
INFO: <Unknown Caller Context>: ExcelApplicationContext: Created commands
INFO: <Unknown Caller Context>: offline exec form created
INFO: <Unknown Caller Context>: Browse in offline exec form pressed
INFO: <Unknown Caller Context>: Doing RQMS import
INFO: <Unknown Caller Context>: Reading script XML

......

INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands
INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands
INFO: <Unknown Caller Context>: Mso2Rqm Shutdown!

Can you import any of our samples? They can be found here:

C:\Program Files (x86)\IBM\RQMExcelImporter\Samples

Will

Be the first one to answer this question!

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.