It's all about the answers!

Ask a question

Unhandled exception: length cannot be less than zero Excel Import


Corey Jacobs (642539) | asked May 21 '13, 9:11 p.m.
I'm using 2010 Excel to import multiple testcases using the RQMExcelWordImporter tool for the first time and RQM 4.0.2.  When attempting to export to either file or repository, I'm receiving an error 'length cannot be less than zero. Parameter name: length'.  I tried removing/commenting some of the fields from my config file and still run into this error.  Any clue?

Config file I created
//configuration file for sample migration for admin
testcase.XLSStartRow=6
testcase.alm:owner=A
testcase.dc:title=B
testcase.dc:description=C
testcase.category term="Test Purpose".value=C
testcase.category term="Product".value=E
testcase.category term="Product Version".value=F
testcase.category term="Test Team".value=G
testcase.category term="CM Enabled".value=H
testcase.category term="CM ID Level".value=I
testcase.category term="Component Tested".value=J
testcase.category term="DB2 Level".value=K
testcase.category term="MVS Level".value=L
testcase.category term="Should this scenario be automated".value=M
//testcase.Section("myns:com.ibm.rqm.planning.editor.section.caseTestDescription", "RQM-KEY-TC-TEST-DESCRIPTION-TITLE")=N



Comments
Corey Jacobs commented Jun 03 '13, 2:42 p.m.

No longer receiving this error.

3 answers



permanent link
Ara Masrof (3.2k15) | answered May 21 '13, 9:37 p.m.
JAZZ DEVELOPER
 Cory,
Is there any additional information regarding the error in the Mso2Rqm_Debug.log (It will be located \Application Data\mso2Rqm folder)?

permanent link
Hao Wan (1.5k35) | answered May 21 '13, 10:28 p.m.
JAZZ DEVELOPER
 Corey,
there's no problem with your config file, would you provide the log as Ara mentioned, and if possible please attach the excel used.

permanent link
Corey Jacobs (642539) | answered May 28 '13, 2:35 p.m.
Here's my log


5/21/2013 3:07:34 PM:
SESSION: 5/21/2013 3:07:34 PM


5/21/2013 3:07:34 PM: INFO: <Unknown Caller Context>: RQMExporter created!


5/21/2013 3:07:34 PM: INFO: <Unknown Caller Context>: RQMExporter Startup!


5/21/2013 3:07:34 PM: INFO: <Unknown Caller Context>: Mso2Rqm: Mso2Rqm instantiated


5/21/2013 3:07:34 PM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands


5/21/2013 3:07:34 PM: INFO: <Unknown Caller Context>: caption : RQM


5/21/2013 3:07:34 PM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Created commands


5/21/2013 5:44:25 PM:
--------------------------------------------------------------------------------

5/21/2013 5:44:25 PM:
SESSION: 5/21/2013 5:44:25 PM


5/21/2013 5:44:25 PM: Getting artifacts from current document Book1.xls

5/21/2013 5:45:25 PM:
--------------------------------------------------------------------------------

5/21/2013 5:45:25 PM:
SESSION: 5/21/2013 5:45:25 PM


5/21/2013 5:45:26 PM: Getting artifacts from current document Book1.xls

5/21/2013 5:45:36 PM:
--------------------------------------------------------------------------------

5/21/2013 5:45:36 PM:
SESSION: 5/21/2013 5:45:36 PM


5/21/2013 5:45:36 PM: Getting artifacts from current document Book1.xls

5/21/2013 5:47:13 PM:
--------------------------------------------------------------------------------

5/21/2013 5:47:13 PM:
SESSION: 5/21/2013 5:47:13 PM


5/21/2013 5:47:14 PM: Getting artifacts from current document Book1.xls

5/21/2013 5:48:17 PM:
--------------------------------------------------------------------------------

5/21/2013 5:48:17 PM:
SESSION: 5/21/2013 5:48:17 PM


5/21/2013 5:48:17 PM: Getting artifacts from current document Book1.xls

5/21/2013 5:49:16 PM:
--------------------------------------------------------------------------------

5/21/2013 5:49:16 PM:
SESSION: 5/21/2013 5:49:16 PM


5/21/2013 5:49:16 PM: Getting artifacts from current document Book1.xls

5/21/2013 5:50:41 PM:
--------------------------------------------------------------------------------

5/21/2013 5:50:41 PM:
SESSION: 5/21/2013 5:50:41 PM


5/21/2013 5:50:42 PM: Getting artifacts from current document Book1.xls

5/21/2013 5:51:41 PM:
--------------------------------------------------------------------------------

5/21/2013 5:51:41 PM:
SESSION: 5/21/2013 5:51:41 PM


5/21/2013 5:51:41 PM: Getting artifacts from current document Book1.xls

5/21/2013 5:51:52 PM:
--------------------------------------------------------------------------------

5/21/2013 5:51:52 PM:
SESSION: 5/21/2013 5:51:52 PM


5/21/2013 5:51:52 PM: Getting artifacts from current document Book1.xls

5/21/2013 5:55:19 PM: INFO: <Unknown Caller Context>: RQMConnector: Logout - Error logging out:https://localhost:9443/rqm


5/21/2013 5:55:19 PM: INFO: <Unknown Caller Context>: Unable to connect to the remote server


5/21/2013 5:55:19 PM: EXCEPTION: : Unable to connect to the remote server


5/21/2013 5:55:19 PM:    at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
   at System.Net.HttpWebRequest.GetRequestStream()
   at Mso2Rqm_Common.RQMConnector.LogOut(String url)


5/21/2013 5:55:19 PM: EXCEPTION: : No connection could be made because the target machine actively refused it 127.0.0.1:9443


5/21/2013 5:55:19 PM:    at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)

5/21/2013 5:56:05 PM: 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://svljazz08.svl.ibm.com:9448/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects</id>
<link href="https://svljazz08.svl.ibm.com:9448/qm/web/console/" rel="alternate"/>
<link rel="self" href="https://svljazz08.svl.ibm.com:9448/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects"/>
<entry xmlns="http://www.w3.org/2005/Atom"><id>https://svljazz08.svl.ibm.com:9448/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/IMTools+QA+Test</id><title type="text">IM Tools QA Test</title><summary type="text">Alias: IMTools+QA+Test</summary><link href="https://svljazz08.svl.ibm.com:9448/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/IMTools+QA+Test" rel="alternate" type="application/xml"></link><content type="application/xml"><ns2:project 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://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1" xmlns:ns14="http://jazz.net/xmlns/alm/qm/v0.1/catalog/v0.1" xmlns:ns16="http://jazz.net/xmlns/alm/qm/styleinfo/v0.1/" xmlns:ns17="http://www.w3.org/1999/XSL/Transform" xmlns:ns1="http://schema.ibm.com/vega/2008/" xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" 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://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:ns7="http://purl.org/dc/terms/" 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/"><ns3:identifier xmlns:ns3="http://purl.org/dc/elements/1.1/">https://svljazz08.svl.ibm.com:9448/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/IMTools+QA+Test</ns3:identifier><ns3:title xmlns:ns3="http://purl.org/dc/elements/1.1/">IM Tools QA Test</ns3:title><ns3:description xmlns:ns3="http://purl.org/dc/elements/1.1/">Alias: IMTools+QA+Test</ns3:description><ns2:alias xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" type="string">IMTools+QA+Test</ns2:alias><ns2:settingsids xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/"><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.customattribute</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.testscript</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.category</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.reporting</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.artifactstatetransitionconstraints</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.executionpreference</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.requirememtrisk</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.buildintegration</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.manualscriptdictionary</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.sharedresourcelocation</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.execution</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.planningobjective</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.rqmrelatedlinks</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.risk</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.testcasesystem</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.planningpreference</ns2:settingid></ns2:settingsids></ns2:project></content><link href="https://svljazz08.svl.ibm.com:9448/qm/web/console/IM+Tools+QA+Test" rel="enclosure" type="text/html" title="Web Console"></link></entry><entry xmlns="http://www.w3.org/2005/Atom"><id>https://svljazz08.svl.ibm.com:9448/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/SDI+Lifecycle+Project+%28Quality+Management%29</id><title type="text">SDI Lifecycle Project (Quality Management)</title><summary type="text">Alias: SDI+Lifecycle+Project+%28Quality+Management%29</summary><link href="https://svljazz08.svl.ibm.com:9448/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/SDI+Lifecycle+Project+%28Quality+Management%29" rel="alternate" type="application/xml"></link><content type="application/xml"><ns2:project 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://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1" xmlns:ns14="http://jazz.net/xmlns/alm/qm/v0.1/catalog/v0.1" xmlns:ns16="http://jazz.net/xmlns/alm/qm/styleinfo/v0.1/" xmlns:ns17="http://www.w3.org/1999/XSL/Transform" xmlns:ns1="http://schema.ibm.com/vega/2008/" xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" 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://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:ns7="http://purl.org/dc/terms/" 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/"><ns3:identifier xmlns:ns3="http://purl.org/dc/elements/1.1/">https://svljazz08.svl.ibm.com:9448/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects/SDI+Lifecycle+Project+%28Quality+Management%29</ns3:identifier><ns3:title xmlns:ns3="http://purl.org/dc/elements/1.1/">SDI Lifecycle Project (Quality Management)</ns3:title><ns3:description xmlns:ns3="http://purl.org/dc/elements/1.1/">Alias: SDI+Lifecycle+Project+%28Quality+Management%29</ns3:description><ns2:alias xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" type="string">SDI+Lifecycle+Project+%28Quality+Management%29</ns2:alias><ns2:settingsids xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/"><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.customattribute</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.testscript</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.category</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.reporting</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.artifactstatetransitionconstraints</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.executionpreference</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.requirememtrisk</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.buildintegration</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.manualscriptdictionary</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.sharedresourcelocation</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.execution</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.planningobjective</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.rqmrelatedlinks</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.risk</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.testcasesystem</ns2:settingid><ns2:settingid xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/">com.ibm.rqm.planningpreference</ns2:settingid></ns2:settingsids></ns2:project></content><link href="https://svljazz08.svl.ibm.com:9448/qm/web/console/SDI+Lifecycle+Project+%28Quality+Management%29" rel="enclosure" type="text/html" title="Web Console"></link></entry></feed>



5/21/2013 5:56:05 PM: INFO: <Unknown Caller Context>: response from project has response content key


5/21/2013 5:56:05 PM: INFO: <Unknown Caller Context>: response has keys: System.Collections.Hashtable+HashtableEnumerator


5/21/2013 5:56:17 PM:
--------------------------------------------------------------------------------

5/21/2013 5:56:17 PM:
SESSION: 5/21/2013 5:56:17 PM


5/21/2013 5:56:17 PM: Getting artifacts from current document Book1

5/21/2013 5:57:03 PM:
--------------------------------------------------------------------------------

5/21/2013 5:57:03 PM:
SESSION: 5/21/2013 5:57:03 PM


5/21/2013 5:57:04 PM: Getting artifacts from current document Book1.xls

5/21/2013 6:06:30 PM:
--------------------------------------------------------------------------------

5/21/2013 6:06:30 PM:
SESSION: 5/21/2013 6:06:30 PM


5/21/2013 6:06:30 PM: Getting artifacts from current document Book1.xls

5/21/2013 6:08:52 PM:
--------------------------------------------------------------------------------

5/21/2013 6:08:52 PM:
SESSION: 5/21/2013 6:08:52 PM


5/21/2013 6:08:52 PM: Getting artifacts from current document Book1.xls

5/21/2013 6:09:55 PM:
--------------------------------------------------------------------------------

5/21/2013 6:09:55 PM:
SESSION: 5/21/2013 6:09:55 PM


5/21/2013 6:09:55 PM: Getting artifacts from current document Book1.xls

5/21/2013 6:12:27 PM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands


5/21/2013 6:12:27 PM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands


5/21/2013 6:12:27 PM: INFO: <Unknown Caller Context>: Mso2Rqm Shutdown!


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.