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

Unhandled exception: length cannot be less than zero Excel Import

Questions
Tags
Users
Badges
Corey Jacobs
(64●25●39) 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


0 votes

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

No longer receiving this error.

3 answers
6,276 views
0 votes

3 answers

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

0 votes

Permanent link
Hao Wan
JAZZ DEVELOPER (1.5k●3●5) May 21 '13, 10:28 p.m.
 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.

0 votes

Permanent link
Corey Jacobs
(64●25●39) 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!


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.

Ask a question
Guidelines
FAQ
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
× 12,020

Question asked: May 21 '13, 9:11 p.m.

Question was seen: 6,276 times

Last updated: Jun 03 '13, 2:42 p.m.

Confirmation Cancel Confirm