Unhandled exception: length cannot be less than zero Excel Import
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 |
3 answers
Cory,
Is there any additional information regarding the error in the Mso2Rqm_Debug.log (It will be located \Application Data\mso2Rqm folder)?
|
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.
|
|
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
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.
Comments
No longer receiving this error.