0 Replies Latest reply on Aug 7, 2007 1:07 PM by RemSupport

    Coldfusion to SAP Web Services

    RemSupport
      Hi, hopefully someone has done this before, were trying to connect coldfusion to sap to get information from and to SAP. The error message I am getting is:

      Web service operation "ZISR_SPECIAL_DATA_GET" with parameters {SCENARIO={aSCENARIO},NOTIFICATION_NO={000000001116},SPECIAL_DATA={aQISRSSPECIAL_PARAM},} could not be found.

      Security doesn't seem to be an issue it's not even getting as far as SAP. I have another web service that works with SAP. I have a feeling that it's a parameter issue, but I'm not certain. Any help would be appriciated.


      This web service retrieves data from SAP to update.


      Here's the CF code:

      <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd">
      <html>
      <head>
      <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
      <title>Untitled Document</title>
      </head>
      <cfscript>
      aQISRSSPECIAL_PARAM=StructNew();
      aQISRSSPECIAL_PARAM.FIELDVALUE = "";
      aQISRSSPECIAL_PARAM.FIELDNAME = "";
      aQISRSSPECIAL_PARAM.FIELDINDEX = 1;

      aTableOfQISRSSPECIAL_PARAM = ArrayNew(1);
      bJunk = ArrayAppend(aTableOfQISRSSPECIAL_PARAM, aQISRSSPECIAL_PARAM);
      aSCENARIO = "";
      </cfscript>
      <body>
      <cfinvoke
      webservice=" http://sapdev.comp.wepco.com:8000/sap/bc/srt/rfc/sap/ZISR_SPECIAL_DATA_GET?sap-client=099& wsdl=1.1"
      method="ZISR_SPECIAL_DATA_GET">
      <cfinvokeargument name="NOTIFICATION_NO" value="000000001116"/>
      <cfinvokeargument name="SCENARIO" value= "aSCENARIO" />
      <cfinvokeargument name="SPECIAL_DATA" value= "aQISRSSPECIAL_PARAM" />
      </cfinvoke>

      </body>
      </html>

      here's the WSDL code:

      <?xml version="1.0" encoding="utf-8" ?>
      - <wsdl:definitions targetNamespace="urn:sap-com:document:sap:rfc:functions" xmlns:http=" http://schemas.xmlsoap.org/wsdl/http/" xmlns:soap=" http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tns="urn:sap-com:document:sap:rfc:functions" xmlns:wsdl=" http://schemas.xmlsoap.org/wsdl/" xmlns:xsd=" http://www.w3.org/2001/XMLSchema">
      - <wsdl:types>
      - <xsd:schema xmlns:xsd=" http://www.w3.org/2001/XMLSchema" xmlns:tns="urn:sap-com:document:sap:rfc:functions" targetNamespace="urn:sap-com:document:sap:rfc:functions" elementFormDefault="unqualified" attributeFormDefault="qualified">
      - <xsd:simpleType name="RfcException.Message.Number">
      - <xsd:restriction base="xsd:string">
      <xsd:maxLength value="3" />
      <xsd:pattern value="\d*" />
      </xsd:restriction>
      </xsd:simpleType>
      - <xsd:simpleType name="char12">
      - <xsd:restriction base="xsd:string">
      <xsd:maxLength value="12" />
      </xsd:restriction>
      </xsd:simpleType>
      - <xsd:simpleType name="char255">
      - <xsd:restriction base="xsd:string">
      <xsd:maxLength value="255" />
      </xsd:restriction>
      </xsd:simpleType>
      - <xsd:simpleType name="char30">
      - <xsd:restriction base="xsd:string">
      <xsd:maxLength value="30" />
      </xsd:restriction>
      </xsd:simpleType>
      - <xsd:simpleType name="char4">
      - <xsd:restriction base="xsd:string">
      <xsd:maxLength value="4" />
      </xsd:restriction>
      </xsd:simpleType>
      - <xsd:complexType name="QISRSSPECIAL_PARAM">
      - <xsd:sequence>
      <xsd:element name="FIELDINDEX" type="xsd:int" />
      <xsd:element name="FIELDNAME" type="tns:char30" />
      <xsd:element name="FIELDVALUE" type="tns:char255" />
      </xsd:sequence>
      </xsd:complexType>
      - <xsd:complexType name="RfcException.Message">
      - <xsd:sequence>
      <xsd:element name="ID" type="xsd:string" />
      <xsd:element name="Number" type="tns:RfcException.Message.Number" />
      </xsd:sequence>
      </xsd:complexType>
      - <xsd:complexType name="ZISR_SPECIAL_DATA_GET.RfcException">
      - <xsd:sequence>
      <xsd:element name="Name" type="tns:ZISR_SPECIAL_DATA_GET.RfcExceptions" />
      <xsd:element name="Text" minOccurs="0" type="xsd:string" />
      <xsd:element name="Message" minOccurs="0" type="tns:RfcException.Message" />
      </xsd:sequence>
      </xsd:complexType>
      - <xsd:complexType name="QISRTSPECIAL_PARAM">
      - <xsd:sequence>
      <xsd:element name="item" minOccurs="0" maxOccurs="unbounded" type="tns:QISRSSPECIAL_PARAM" />
      </xsd:sequence>
      </xsd:complexType>
      - <xsd:simpleType name="ZISR_SPECIAL_DATA_GET.RfcExceptions">
      - <xsd:restriction base="xsd:string">
      <xsd:enumeration value="INT_SERVICE_REQUEST_NOT_FOUND" />
      <xsd:enumeration value="INVALID_NOTIF_NUMBER" />
      <xsd:enumeration value="NO_INTERNAL_SERVICE_REQUEST" />
      </xsd:restriction>
      </xsd:simpleType>
      <xsd:element name="ZISR_SPECIAL_DATA_GET.Exception" type="tns:ZISR_SPECIAL_DATA_GET.RfcException" />
      - <xsd:element name="ZISR_SPECIAL_DATA_GET">
      - <xsd:complexType>
      - <xsd:sequence>
      <xsd:element name="NOTIFICATION_NO" type="tns:char12" />
      </xsd:sequence>
      </xsd:complexType>
      </xsd:element>
      - <xsd:element name="ZISR_SPECIAL_DATA_GETResponse">
      - <xsd:complexType>
      - <xsd:sequence>
      <xsd:element name="SCENARIO" type="tns:char4" />
      <xsd:element name="SPECIAL_DATA" type="tns:QISRTSPECIAL_PARAM" />
      </xsd:sequence>
      </xsd:complexType>
      </xsd:element>
      </xsd:schema>
      </wsdl:types>
      - <wsdl:message name="ZISR_SPECIAL_DATA_GET">
      <wsdl:part name="parameters" element="tns:ZISR_SPECIAL_DATA_GET" />
      </wsdl:message>
      - <wsdl:message name="ZISR_SPECIAL_DATA_GETResponse">
      <wsdl:part name="parameters" element="tns:ZISR_SPECIAL_DATA_GETResponse" />
      </wsdl:message>
      - <wsdl:message name="exception00">
      <wsdl:part name="exception00" element="tns:ZISR_SPECIAL_DATA_GET.Exception" />
      </wsdl:message>
      - <wsdl:portType name="ZISR_SPECIAL_DATA_GET">
      - <wsdl:operation name="ZISR_SPECIAL_DATA_GET">
      <wsdl:input message="tns:ZISR_SPECIAL_DATA_GET" />
      <wsdl:output message="tns:ZISR_SPECIAL_DATA_GETResponse" />
      <wsdl:fault name="exception00" message="tns:exception00" />
      </wsdl:operation>
      </wsdl:portType>
      - <wsdl:binding name="ZISR_SPECIAL_DATA_GETSoapBinding" type="tns:ZISR_SPECIAL_DATA_GET">
      <soap:binding style="document" transport=" http://schemas.xmlsoap.org/soap/http" />
      - <wsdl:operation name="ZISR_SPECIAL_DATA_GET">
      <soap:operation soapAction="" />
      - <wsdl:input>
      <soap:body use="literal" />
      </wsdl:input>
      - <wsdl:output>
      <soap:body use="literal" />
      </wsdl:output>
      - <wsdl:fault name="exception00">
      <soap:fault name="exception00" use="literal" />
      </wsdl:fault>
      </wsdl:operation>
      </wsdl:binding>
      - <wsdl:service name="ZISR_SPECIAL_DATA_GETService">
      - <wsdl:port name="ZISR_SPECIAL_DATA_GETSoapBinding" binding="tns:ZISR_SPECIAL_DATA_GETSoapBinding">
      <soap:address location=" http://sapdev.comp.wepco.com:8000/sap/bc/srt/rfc/sap/ZISR_SPECIAL_DATA_GET?sap-client=099" />
      </wsdl:port>
      </wsdl:service>
      </wsdl:definitions>