Web-service error in Sybase Unwired Platform.

[Former Member]

Iu2019m having trouble getting a web-service call to work for creating an MBO.

Iu2019ve copied and pasted the WSDL into this thread.

The web-method I'm calling is valuesOf_Country_Name_Details.

I know the credentials are correct.

The error I get is "Execution failed: Error transforming into a ResultSet. Column metadata not found - probable cause is invalid XSLT."

Do you know what the issue might be?

Note: I've replaced <> with | because it parses better for the forum.

Thanks,

Dan

definitions targetNamespace="Cerebro_Mobile_View2" name="queryasaservice"	types	s:schema elementFormDefault="qualified" targetNamespace="Cerebro_Mobile_View2"	s:element name="runQueryAsAService"	s:complexType	s:sequence	s:element name="login" type="s:string"/	s:element name="password" type="s:string"/	s:element name="_4_Calendar_Period" type="s:string" nillable="true"/	s:element name="_3_Vendor" type="s:string" nillable="true"/	s:element name="_2_Operator" type="s:string" nillable="true"/	s:element name="_1_Country" type="s:string" nillable="true"/	/s:sequence	/s:complexType	/s:element	s:element name="runQueryAsAServiceEx"	s:complexType	s:sequence	s:element name="login" type="s:string"/	s:element name="password" type="s:string"/	s:element name="_4_Calendar_Period" type="s0:LovValueIndex" nillable="true"/	s:element name="_3_Vendor" type="s0:LovValueIndex" nillable="true"/	s:element name="_2_Operator" type="s0:LovValueIndex" nillable="true"/	s:element name="_1_Country" type="s0:LovValueIndex" nillable="true"/	/s:sequence	/s:complexType	/s:element	s:element name="valuesOf_Country_Name_Details"	s:complexType	s:sequence	s:element name="login" type="s:string"/	s:element name="password" type="s:string"/	s:element name="searchLov" type="s:string"/	/s:sequence	/s:complexType	/s:element	s:element name="valuesOf_Operator_Details"	s:complexType	s:sequence	s:element name="login" type="s:string"/	s:element name="password" type="s:string"/	s:element name="searchLov" type="s:string"/	s:element name="Country_Name_Details" minOccurs="0" maxOccurs="unbounded" type="s0:LovValueIndex"/	/s:sequence	/s:complexType	/s:element	s:element name="valuesOf_Vendor_Details"	s:complexType	s:sequence	s:element name="login" type="s:string"/	s:element name="password" type="s:string"/	s:element name="searchLov" type="s:string"/	s:element name="Operator_Details" minOccurs="0" maxOccurs="unbounded" type="s0:LovValueIndex"/	/s:sequence	/s:complexType	/s:element	s:element name="valuesOf_Calendar_Period_Details"	s:complexType	s:sequence	s:element name="login" type="s:string"/	s:element name="password" type="s:string"/	s:element name="searchLov" type="s:string"/	/s:sequence	/s:complexType	/s:element	s:complexType name="Row"	s:sequence	s:element name="Vendor_Details" type="s:string" nillable="true"/	s:element name="Sum_Sales_Units_Details" type="s:double" nillable="true"/	s:element name="Sum_Street_ASP_Details" type="s:double" nillable="true"/	/s:sequence	/s:complexType	s:complexType name="Table"	s:sequence	s:element name="row" maxOccurs="unbounded" type="s0:Row"/	/s:sequence	/s:complexType	s:complexType name="LovValueIndex"	s:sequence	s:element name="value" type="s:string"/	s:element name="index" type="s:string"/	/s:sequence	/s:complexType	s:complexType name="Lov"	s:sequence	s:element name="valueindex" minOccurs="0" maxOccurs="unbounded" type="s0:LovValueIndex"/	/s:sequence	/s:complexType	s:element name="valuesOf_Country_Name_DetailsResponse"	s:complexType	s:sequence	s:element name="lov" type="s0:Lov"/	s:element name="message" type="s:string"/	s:element name="delegated" type="s:boolean"/	s:element name="partialResult" type="s:boolean"/	/s:sequence	/s:complexType	/s:element	s:element name="valuesOf_Operator_DetailsResponse"	s:complexType	s:sequence	s:element name="lov" type="s0:Lov"/	s:element name="message" type="s:string"/	s:element name="delegated" type="s:boolean"/	s:element name="partialResult" type="s:boolean"/	/s:sequence	/s:complexType	/s:element	s:element name="valuesOf_Vendor_DetailsResponse"	s:complexType	s:sequence	s:element name="lov" type="s0:Lov"/	s:element name="message" type="s:string"/	s:element name="delegated" type="s:boolean"/	s:element name="partialResult" type="s:boolean"/	/s:sequence	/s:complexType	/s:element	s:element name="valuesOf_Calendar_Period_DetailsResponse"	s:complexType	s:sequence	s:element name="lov" type="s0:Lov"/	s:element name="message" type="s:string"/	s:element name="delegated" type="s:boolean"/	s:element name="partialResult" type="s:boolean"/	/s:sequence	/s:complexType	/s:element	s:element name="runQueryAsAServiceResponse"	s:complexType	s:sequence	s:element name="table" type="s0:Table"/	s:element name="message" type="s:string"/	s:element name="creatorname" type="s:string"/	s:element name="creationdate" type="s:dateTime"/	s:element name="creationdateformated" type="s:string"/	s:element name="description" type="s:string"/	s:element name="universe" type="s:string"/	s:element name="queryruntime" type="s:int"/	s:element name="fetchedrows" type="s:int"/	/s:sequence	/s:complexType	/s:element	s:element name="runQueryAsAServiceExResponse"	s:complexType	s:sequence	s:element name="table" type="s0:Table"/	s:element name="message" type="s:string"/	s:element name="creatorname" type="s:string"/	s:element name="creationdate" type="s:dateTime"/	s:element name="creationdateformated" type="s:string"/	s:element name="description" type="s:string"/	s:element name="universe" type="s:string"/	s:element name="queryruntime" type="s:int"/	s:element name="fetchedrows" type="s:int"/	/s:sequence	/s:complexType	/s:element	s:element name="QaaWSHeader"	s:complexType	s:sequence	s:element name="sessionID" type="s:string" minOccurs="0" maxOccurs="1" nillable="true"/	s:element name="serializedSession" type="s:string" minOccurs="0" maxOccurs="1" nillable="true"/	/s:sequence	/s:complexType	/s:element	/s:schema	/types	message name="runQueryAsAServiceSoapIn"	part name="parameters" element="s0:runQueryAsAService"/	part name="request_header" element="s0:QaaWSHeader"/	/message	message name="runQueryAsAServiceSoapOut"	part name="parameters" element="s0:runQueryAsAServiceResponse"/	/message	message name="runQueryAsAServiceExSoapIn"	part name="parameters" element="s0:runQueryAsAServiceEx"/	part name="request_header" element="s0:QaaWSHeader"/	/message	message name="runQueryAsAServiceExSoapOut"	part name="parameters" element="s0:runQueryAsAServiceExResponse"/	/message	message name="valuesOf_Country_Name_DetailsSoapIn"	part name="parameters" element="s0:valuesOf_Country_Name_Details"/	part name="request_header" element="s0:QaaWSHeader"/	/message	message name="valuesOf_Country_Name_DetailsSoapOut"	part name="parameters" element="s0:valuesOf_Country_Name_DetailsResponse"/	/message	message name="valuesOf_Operator_DetailsSoapIn"	part name="parameters" element="s0:valuesOf_Operator_Details"/	part name="request_header" element="s0:QaaWSHeader"/	/message	message name="valuesOf_Operator_DetailsSoapOut"	part name="parameters" element="s0:valuesOf_Operator_DetailsResponse"/	/message	message name="valuesOf_Vendor_DetailsSoapIn"	part name="parameters" element="s0:valuesOf_Vendor_Details"/	part name="request_header" element="s0:QaaWSHeader"/	/message	message name="valuesOf_Vendor_DetailsSoapOut"	part name="parameters" element="s0:valuesOf_Vendor_DetailsResponse"/	/message	message name="valuesOf_Calendar_Period_DetailsSoapIn"	part name="parameters" element="s0:valuesOf_Calendar_Period_Details"/	part name="request_header" element="s0:QaaWSHeader"/	/message	message name="valuesOf_Calendar_Period_DetailsSoapOut"	part name="parameters" element="s0:valuesOf_Calendar_Period_DetailsResponse"/	/message	portType name="QueryAsAServiceSoap"	operation name="runQueryAsAService"	documentation	Get Web Service Provider server info	/documentation	input message="s0:runQueryAsAServiceSoapIn"/	output message="s0:runQueryAsAServiceSoapOut"/	/operation	operation name="runQueryAsAServiceEx"	documentation	Get Web Service Provider server info	/documentation	input message="s0:runQueryAsAServiceExSoapIn"/	output message="s0:runQueryAsAServiceExSoapOut"/	/operation	operation name="valuesOf_Country_Name_Details"	documentation	Get Web Service Provider server info	/documentation	input message="s0:valuesOf_Country_Name_DetailsSoapIn"/	output message="s0:valuesOf_Country_Name_DetailsSoapOut"/	/operation	operation name="valuesOf_Operator_Details"	documentation	Get Web Service Provider server info	/documentation	input message="s0:valuesOf_Operator_DetailsSoapIn"/	output message="s0:valuesOf_Operator_DetailsSoapOut"/	/operation	operation name="valuesOf_Vendor_Details"	documentation	Get Web Service Provider server info	/documentation	input message="s0:valuesOf_Vendor_DetailsSoapIn"/	output message="s0:valuesOf_Vendor_DetailsSoapOut"/	/operation	operation name="valuesOf_Calendar_Period_Details"	documentation	Get Web Service Provider server info	/documentation	input message="s0:valuesOf_Calendar_Period_DetailsSoapIn"/	output message="s0:valuesOf_Calendar_Period_DetailsSoapOut"/	/operation	/portType	binding name="QueryAsAServiceSoap" type="s0:QueryAsAServiceSoap"	soap:binding transport="http://schemas.xmlsoap.org/soap/http" style="document"/	operation name="runQueryAsAService"	soap:operation soapAction="Cerebro_Mobile_View2/runQueryAsAService" style="document"/	input	soap:header message="s0:runQueryAsAServiceSoapIn" part="request_header" use="literal"	soap:headerfault message="s0:runQueryAsAServiceSoapIn" part="request_header" use="literal"/	/soap:header	soap:body use="literal" parts="parameters"/	/input	output	soap:body use="literal"/	/output	/operation	operation name="runQueryAsAServiceEx"	soap:operation soapAction="Cerebro_Mobile_View2/runQueryAsAServiceEx" style="document"/	input	soap:header message="s0:runQueryAsAServiceExSoapIn" part="request_header" use="literal"	soap:headerfault message="s0:runQueryAsAServiceExSoapIn" part="request_header" use="literal"/	/soap:header	soap:body use="literal" parts="parameters"/	/input	output	soap:body use="literal"/	/output	/operation	operation name="valuesOf_Country_Name_Details"	soap:operation soapAction="Cerebro_Mobile_View2/valuesOf_Country_Name_Details" style="document"/	input	soap:header message="s0:valuesOf_Country_Name_DetailsSoapIn" part="request_header" use="literal"	soap:headerfault message="s0:valuesOf_Country_Name_DetailsSoapIn" part="request_header" use="literal"/	/soap:header	soap:body use="literal" parts="parameters"/	/input	output	soap:body use="literal"/	/output	/operation	operation name="valuesOf_Operator_Details"	soap:operation soapAction="Cerebro_Mobile_View2/valuesOf_Operator_Details" style="document"/	input	soap:header message="s0:valuesOf_Operator_DetailsSoapIn" part="request_header" use="literal"	soap:headerfault message="s0:valuesOf_Operator_DetailsSoapIn" part="request_header" use="literal"/	/soap:header	soap:body use="literal" parts="parameters"/	/input	output	soap:body use="literal"/	/output	/operation	operation name="valuesOf_Vendor_Details"	soap:operation soapAction="Cerebro_Mobile_View2/valuesOf_Vendor_Details" style="document"/	input	soap:header message="s0:valuesOf_Vendor_DetailsSoapIn" part="request_header" use="literal"	soap:headerfault message="s0:valuesOf_Vendor_DetailsSoapIn" part="request_header" use="literal"/	/soap:header	soap:body use="literal" parts="parameters"/	/input	output	soap:body use="literal"/	/output	/operation	operation name="valuesOf_Calendar_Period_Details"	soap:operation soapAction="Cerebro_Mobile_View2/valuesOf_Calendar_Period_Details" style="document"/	input	soap:header message="s0:valuesOf_Calendar_Period_DetailsSoapIn" part="request_header" use="literal"	soap:headerfault message="s0:valuesOf_Calendar_Period_DetailsSoapIn" part="request_header" use="literal"/	/soap:header	soap:body use="literal" parts="parameters"/	/input	output	soap:body use="literal"/	/output	/operation	/binding	service name="Cerebro_Mobile_View2"	documentation/	port name="QueryAsAServiceSoap" binding="s0:QueryAsAServiceSoap"	soap:address location="http://boxi31sbx.rim.net:8080/dswsbobje/qaawsservices/queryasaservice?&cuid=5E2wsWYADeYJFEAAPwBr1sRDOE5KpQ&authType=secLDAP&locale=en_US&timeout=60&ConvertAnyType=false"/	/port	/service	/definitions

Edited by: DanGifford on Apr 27, 2011 2:21 PM

Edited by: DanGifford on Apr 27, 2011 2:22 PM

[Former Member]

I had this same issue and resovled it.  I am very new to this platform, so I don't know if this is the actual root cause, or if I just got lucky.  I am sort of guessing as to what the platform is actually doing.

I believe that the XSLT generator is assuming that the namespace for the response messages is equal to the target namespace in the WSDL.  With SAP based web service calls, this doesn't always have to be true.  SAP genetrated WSDLs can have different namespaces at multiple levels. 

To resolve this problem I changed the namespace in the generated XSLT to match the namespace in the response message.

Here is a quick Example:

This is the request message:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
                  xmlns:ord="http://mycompany.com/examples/mySAPWebService">

   <soapenv:Header/>

   <soapenv:Body>

      <ord:Req_Query>

         <value>1</value>

      </ord:Req_Query>

   </soapenv:Body>

</soapenv:Envelope>

This is the response message:

<SOAP:Envelope xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/">

   <SOAP:Header/>

   <SOAP:Body>

      <ns1:Req_Response xmlns:ns1="http://mycompany.com/system/value1/Value2/Value3">

         <Items>

            <Item>

               <Number>10</Number>

               <Code>ABCD</Plant>

               <SubItem>

                  <Number>1</Number>

                  <Date>2013-01-01</Date>

                  <Time>00:00:00</Time>

               </SubItem>

            </Item>

         </Items>

      </ns1:Req_Response>

   </SOAP:Body>

</SOAP:Envelope>

The generated XSLT looks like this.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

xmlns:ns1="http://mycompany.com/examples/mySAPWebService">

  <xsl:template match="//ns1:Req_Response">

    ...

  </xsl:template>

</xsl:stylesheet>

You will notice that the namespace indicated in ns1 does not actually match the namespace value that is returned from the service call.

I changed the XSLT to match the response namespace and the generator works.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

xmlns:ns1="http://mycompany.com/system/value1/Value2/Value3">

  <xsl:template match="//ns1:Req_Response">

    ...

  </xsl:template>

</xsl:stylesheet>

[Former Member]

hi.

I am trying to use a web service but facing some issue regarding it.

Can u refer please refer the below link and provide a solution for it.

http://scn.sap.com/thread/3288582

Regards,

Namrata

[Vlad]

Hello Dan,

When I played with WSDL and Sybase Unwired Workspace, I found out that the problem might arise if the XSLT file applied to the webservice response gives you an incorrect result.

I am not sure at 100%, but in my case it helped to correct the <xsl:template match="...."> line. Instead of "..." you have to use "//SomeItem".

Would you please show us your WSDL response and generated XSLT?

Kind regards,
Vlad

[former_member190457]

Hi all,

I am experiencing the same error when connecting to an SAP-based WSDL.

Can anyone please help?

Thanks, regards

Vincenzo