[SOLVED] Error within the Excel Importer

Description
gcueppers
Posts: 16
Joined: Tue Feb 26, 2008 2:24 pm
Location: Aachen, Germany
Contact:

[SOLVED] Error within the Excel Importer

Postby gcueppers » Tue Nov 16, 2010 1:15 pm

Hello everybody,

I tried to import WorkItems using the Excel Importer (Version 1.0.7) and I got the following error:

Maybe someone has a tip how to go on to finish my Import of WorkItems...

...\jre1.5.0_09\bin\java -jar excel-1.0.7/excel-1.0.7.jar "https://<user>:<pw>@<server>/polarion/#/project/<project>/ws/services/" "FEHLER_20101116_TEST.xls" "Mapping.txt" <project> defect

Found Polarion 3 web service URL
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.lang.RuntimeException: Exception in preInvoke : javax.xml.soap.SOAPException: org.xml.sax.SAXParseException: The processing instruction target matching &quot;[xX][mM][lL]&quot; is not allowed.
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:java.lang.RuntimeException: Exception in preInvoke : javax.xml.soap.SOAPException: org.xml.sax.SAXParseException: The processing instruction target matching &quot;[xX][mM][lL]&quot; is not allowed.
at org.apache.axis.handlers.HandlerChainImpl.preInvoke(HandlerChainImpl.java:188)
at org.apache.axis.handlers.HandlerChainImpl.handleResponse(HandlerChainImpl.java:160)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:180)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.polarion.alm.ws.client.session.SessionWebServiceSoapBindingStub.logIn(SessionWebServiceSoapBindingStub.java:208)
at com.polarion.ExcelImporter.polarion3.Polarion3WebService.&lt;init&gt;(Polarion3WebService.java:85)
at com.polarion.ExcelImporter.ExcelProcessor.&lt;init&gt;(ExcelProcessor.java:77)
at ExcelImport.main(ExcelImport.java:91)

{http://xml.apache.org/axis/}hostname:w4de3msynk06036

java.lang.RuntimeException: Exception in preInvoke : javax.xml.soap.SOAPException: org.xml.sax.SAXParseException: The processing instruction target matching "[xX][mM][lL]" is not allowed.
at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:216)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.polarion.alm.ws.client.session.SessionWebServiceSoapBindingStub.logIn(SessionWebServiceSoapBindingStub.java:208)
at com.polarion.ExcelImporter.polarion3.Polarion3WebService.<init>(Polarion3WebService.java:85)
at com.polarion.ExcelImporter.ExcelProcessor.<init>(ExcelProcessor.java:77)
at ExcelImport.main(ExcelImport.java:91)
Caused by: java.lang.RuntimeException: Exception in preInvoke : javax.xml.soap.SOAPException: org.xml.sax.SAXParseException: The processing instruction target matching "[xX][mM][lL]" is not allowed.
at org.apache.axis.handlers.HandlerChainImpl.preInvoke(HandlerChainImpl.java:188)
at org.apache.axis.handlers.HandlerChainImpl.handleResponse(HandlerChainImpl.java:160)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:180)
... 9 more
Exception in thread "main" java.lang.NullPointerException
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:200)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:182)
at com.polarion.ExcelImporter.ExcelProcessor.validateMapping(ExcelProcessor.java:120)
at ExcelImport.main(ExcelImport.java:96)
Last edited by gcueppers on Mon Dec 27, 2010 12:50 pm, edited 1 time in total.
kind regards,
Guido

gcueppers
Posts: 16
Joined: Tue Feb 26, 2008 2:24 pm
Location: Aachen, Germany
Contact:

Re: Error within the Excel Importer

Postby gcueppers » Mon Nov 29, 2010 3:16 pm

The mistake was, that the wrong pass to the Polarion services were used:

wrong URL: https://<user>:<password>@<server>/polarion/#/group/TT2/ws/services/
correct URL: https://<user>:<password>@<server>/polarion/ws/services/

Actually those services are not project-specific so that the solution is clear but really not easy to find, isn't it.

Kind regards,
Guido
kind regards,

Guido


Return to “Polarion Application Lifecycle Management (ALM)”

Who is online

Users browsing this forum: shreyankkr and 6 guests