Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: webservices support

  1. #1
    Join Date
    Jan 2006
    Posts
    313

    Default webservices support

    In the 2.5.0 version, i tested the webservices functionality in the experimental section. Depending on the webservice used, i got different errors, ranging from input parameter problems till outpur parameter parsing problems. I wanted to have a look at the source code to see what went wrong. So i downloaded the trunk at source.pentaho.org/svnkettleroot.
    When i run this version and imported the Kettle transformation, it gave me the message
    "Error reading object from XML file
    Unable to load step info from XML step nodeorg.pentaho.di.core.exception.KettleStepLoaderException:
    Unable to load class for step/plugin with id [WebServiceLookup]. Check if the plugin is available in the plugins subdirectory of the Kettle distribution.

    Unable to load class for step/plugin with id [WebServiceLookup]. Check if the plugin is available in the plugins subdirectory of the Kettle distribution."

    This plugin is not available in the plugins directory. Has it been removed intentionally? Where can i find the source code of this plugin?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    That plug-in hasn't been ported yet to 3.0 so you can't edit/run any transformation using them in Kettle 3.0-M1 (for now)... the code of the step (of v2.5) is in the directory KEEP_OUT right under the trunk in SVN.

    Regards,
    Sven

  3. #3
    Join Date
    Jan 2006
    Posts
    313

    Default test results

    Hi,

    I tested the webservices component in the 2.5.0 release with the webservices that are available internally in our company. The result was as expected experimental. None of the webservices worked correctly. I tried to debug. I see where it goes wrong, but i have no solution because of a lack of "how it should" work knowledge

    I searched and found some public available webservices that could be used to test the webservices component against. Attached are a bunch of ktr files that each call a webservice. The results are below. Maybe someone can have a look at it.


    CelciusToFahrenheit
    works OK

    YahooUserPingService
    works OK

    ISOcodesService,freeibanvalidate
    Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : Unexpected error in : java.lang.StringIndexOutOfBoundsException: String index out of range: -1



    CityStateByZip2,reversephone90day,phoneintel,RealEDA
    2007/08/07 09:25:30 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : Unexpected error in : be.ibridge.kettle.core.exception.KettleStepException:
    2007/08/07 09:25:30 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : Internal server error while calling the web service


    CurrencyConvertor
    <?xml version="1.0" encoding="utf-8"?>
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : <soap:Body>
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : <soap:Fault>
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : <faultcode>soap:Client</faultcode>
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : <faultstring>System.Web.Services.Protocols.SoapException: Server did not recognize the value of HTTP Header SOAPAction: http://www.webserviceX.NET//ConversionRate.
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : at System.Web.Services.Protocols.Soap11ServerProtocolHelper.RouteRequest()
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean&amp; abortProcessing)</faultstring>
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : <detail />
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : </soap:Fault>
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : </soap:Body>
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : </soap:Envelope>
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : Unexpected error in : be.ibridge.kettle.core.exception.KettleStepException:
    2007/08/07 09:33:47 - Web services lookup.0 - ERROR (version 2.5.0, build 25004 from 2007/08/06 10:39:30) : Internal server error while calling the web service

    geoipservice
    server unavailable at time of testing

    If you enter the following URL in the webservice step and press load, a window pops up with title "Oops!" showing the following error message.
    http://ws.srlink.com/GeoServices/Cou...vice.asmx?WSDL
    java.lang.ClassCastException: com.ibm.wsdl.extensions.soap12.SOAP12BindingImpl

    If you enter the following URL in the webservice step and press load, a window pops up with title "Oops!" showing the following error message.
    http://www.webservicemart.com/uszip.asmx?WSDL
    java.lang.ClassCastException: com.ibm.wsdl.extensions.http.HTTPBindingImpl

    For the examples where a code is entered into the username field of the webservice you need to go to http://www.strikeiron.com and register for a free trial. The codes currently entered are still valid for a limited number of tries.
    Attached Files Attached Files
    Last edited by begunrom; 08-07-2007 at 05:13 AM.

  4. #4
    Join Date
    Jan 2006
    Posts
    313

    Default fix for ClassCastException

    Attached is a fix for a number of problems in the webservices step.

    All ClassCastException problems have been solved. Webservices that have input/output parameters of a simple type (string, ...) will work. (I don't know any that do not work)
    Complex types will not work
    Attached Files Attached Files

  5. #5
    Join Date
    Nov 1999
    Posts
    459

    Default

    Added the patch to

    http://jira.pentaho.org/browse/PDI-21

    Thanks a lot,
    Jens

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.