locked
The error is: Method 'ProxyNamespace.ServiceNow_GetMetric.query' not found.. RRS feed

  • Question

  • Hi guys -

    I am working on a project where I need to call a WebService Method via the WebService Task in SSIS, and I am getting below error . The content of the WDSL file is also attached. Has anyone got this kind of error? I use BIDS with SQL Service 2008/Windows XP professional.

    Thanks for your help

    Lazalo

    "[Web Service Task] Error: An error occurred with the following error message: Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException:
    Could not execute the Web method. The error is: Method 'ProxyNamespace.ServiceNow_GetMetric.query' not found..

       at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)
       at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)
       at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()". 

     

    WDSL File content:

    <?xml version="1.0" encoding="UTF-8"?>

    <wsdl:definitions targetNamespace="http://www.service-now.com" xmlns:tns="http://www.service-now.com/GetMetric" xmlns:sncns="http://www.service-now.com" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">

    <wsdl:types>

    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" targetNamespace="http://www.service-now.com/GetMetric"><xsd:element name="query"><xsd:complexType><xsd:sequence><xsd:element maxOccurs="1" minOccurs="0" name="metric_id" type="xsd:string"/></xsd:sequence></xsd:complexType></xsd:element><xsd:element name="queryResponse"><xsd:complexType><xsd:sequence><xsd:element maxOccurs="1" minOccurs="0" name="metric_value" type="xsd:string"/></xsd:sequence></xsd:complexType></xsd:element></xsd:schema>

    </wsdl:types>

    <wsdl:message name="querySoapIn">

    <wsdl:part name="GetMetric" element="tns:query"/>

    </wsdl:message>

    <wsdl:message name="querySoapOut">

    <wsdl:part name="GetMetric" element="tns:queryResponse"/>

    </wsdl:message>

    <wsdl:portType name="ServiceNowSoap">

    <wsdl:operation name="query">

    <wsdl:input message="sncns:querySoapIn"/>

    <wsdl:output message="sncns:querySoapOut"/>

    </wsdl:operation>

    </wsdl:portType>

    <wsdl:binding name="ServiceNowSoap" type="sncns:ServiceNowSoap">

    <soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"/>

    <wsdl:operation name="query">

    <soap:operation soapAction="http://www.service-now.com/GetMetric/query" style="document"/>

    <wsdl:input>

    <soap:body use="literal"/>

    </wsdl:input>

    <wsdl:output>

    <soap:body use="literal"/>

    </wsdl:output>

    </wsdl:operation>

    </wsdl:binding>

    <wsdl:service name="ServiceNow_GetMetric">

    <wsdl:port name="ServiceNowSoap" binding="sncns:ServiceNowSoap">

    <soap:address location="http://snc.svc.bcbsmn.com/GetMetric.do?SOAP"/>

    </wsdl:port>

    </wsdl:service>

    </wsdl:definitions>

    Monday, October 18, 2010 1:24 PM

Answers

  • The obvious thing is to check your url, the service and method are all correct?

    I should also point out that the Web Service task is notoriously difficult to use, and only works with the simplest services. The usual approach is to use a Script Task (in 2008), add the web reference, then write some simple code to call the service.


    http://www.sqlis.com | http://www.konesans.com
    Monday, October 18, 2010 2:44 PM