Webservice is not giving any output when called through BODS

[former_member188392]

Dear All,

I am facing a issue while using a webservice function, it couldn't return any output.

On troubleshooting , I have seen there is an "Type mismatch" error in axi log

However, this function returns output when called using SOAP UI for the same input parameter.

<ns1:TenantLocationList><ns1:SetTenantLocations><ns1:TenantCode>UAE</ns1:TenantCode>
<ns1:LocationCode>370</ns1:LocationCode>
</ns1:SetTenantLocations>
</ns1:TenantLocationList>
<ns1:DocumentType/>
<ns1:DocumentSubType/>
<ns1:SalesmanCode/>
<ns1:RouteCode/>
<ns1:SyncKey>bfd0e3aa-c7ab-424a-8d02-4f887474a2c5</ns1:SyncKey>
<ns1:PageNo/>
<ns1:StartDateTime/>
<ns1:EndDateTime/>
<ns1:PostingDateTime/>
<ns1:CountryID/>
<ns1:IncludeVoidDocument/>
</ns1:SalesOrder_Request>
</ns1:GetSalesOrder></soapenv:Body></soapenv:Envelope>
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\phase.c(210) Invoke the handler AddressingOutHandler within the phase MessageOut
[Tue Jul 04 14:55:03 2017] [info]  Starting addressing out handler
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\modules\mod_addr\addr_out_handler.c(133) No action present. Stop processing addressing
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\transport\http\sender\http_transport_sender.c(246) ctx_epr:http://RTM:82/IntegrationService.svc
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\transport\http\sender\http_transport_sender.c(805) using axis2 native http sender.
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\transport\http\sender\http_sender.c(416) msg_ctx_id:urn:uuid:e7b0d291-9eef-45c3-9391-ca47e63195e9
[Tue Jul 04 14:55:03 2017] [error] ..\..\src\core\transport\http\sender\http_sender.c(1411) Error occurred in transport
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\transport\http\sender\http_transport_sender.c(822) OP name axutil_qname_get_localpart = http://www.w3.org/2004/08/wsdl/out-in
[Tue Jul 04 14:55:03 2017] [debug] ..\..\axiom\src\soap\soap_builder.c(930) Identified soap version is soap11
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\phase.c(210) Invoke the handler request_uri_based_dispatcher within the phase Transport
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\phase.c(210) Invoke the handler AddressingInHandler within the phase Transport
[Tue Jul 04 14:55:03 2017] [info]  Starting addressing in handler
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\phase.c(210) Invoke the handler addressing_based_dispatcher within the phase Transport
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\phase.c(210) Invoke the handler LoggingInHandler within the phase PreDispatch
[Tue Jul 04 14:55:03 2017] [info]  Starting logging in handler .........
[Tue Jul 04 14:55:03 2017] [info]  Input message: <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body><s:Fault><faultcode xmlns:a="http://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation/dispatcher">a:InternalServiceFault</faultcode><faultstring xml:lang="en-US">Error in deserializing body of request message for operation 'GetSalesOrder'.</faultstring><detail><ExceptionDetail xmlns="http://schemas.datacontract.org/2004/07/System.ServiceModel" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><HelpLink i:nil="true"/><InnerException><HelpLink i:nil="true"/><InnerException><HelpLink i:nil="true"/><InnerException i:nil="true"/><Message>Input string was not in a correct format.</Message><StackTrace>   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at System.Byte.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Xml.XmlConvert.ToByte(String s)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderIIntegrationService.Read74_GetSalesOrder_Request(Boolean isNullable, Boolean checkType)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderIIntegrationService.Read559_GetSalesOrder()
   at Microsoft.Xml.Serialization.GeneratedAssembly.ArrayOfObjectSerializer248.Deserialize(XmlSerializationReader reader)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)</StackTrace><Type>System.FormatException</Type></InnerException><Message>There is an error in XML document (6, 21).</Message><StackTrace>   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
   at System.ServiceModel.Dispatcher.XmlSerializerOperationFormatter.DeserializeBody(XmlDictionaryReader reader, MessageVersion version, XmlSerializer serializer, MessagePartDescription returnPart, MessagePartDescriptionCollection bodyParts, Object[] parameters, Boolean isRequest)</StackTrace><Type>System.InvalidOperationException</Type></InnerException><Message>Error in deserializing body of request message for operation 'GetSalesOrder'.</Message><StackTrace>   at System.ServiceModel.Dispatcher.XmlSerializerOperationFormatter.DeserializeBody(XmlDictionaryReader reader, MessageVersion version, XmlSerializer serializer, MessagePartDescription returnPart, MessagePartDescriptionCollection bodyParts, Object[] parameters, Boolean isRequest)
   at System.ServiceModel.Dispatcher.XmlSerializerOperationFormatter.DeserializeBody(XmlDictionaryReader reader, MessageVersion version, String action, MessageDescription messageDescription, Object[] parameters, Boolean isRequest)
   at System.ServiceModel.Dispatcher.OperationFormatter.DeserializeBodyContents(Message message, Object[] parameters, Boolean isRequest)
   at System.ServiceModel.Dispatcher.OperationFormatter.DeserializeRequest(Message message, Object[] parameters)
   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.DeserializeInputs(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)</StackTrace><Type>System.ServiceModel.CommunicationException</Type></ExceptionDetail></detail></s:Fault></s:Body></s:Envelope>
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\phase.c(210) Invoke the handler rest_dispatcher within the phase Dispatch
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\phase.c(210) Invoke the handler soap_message_body_based_dispatcher within the phase Dispatch
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\soap_body_disp.c(127) Checking for service using SOAP message body's first child's namespace URI : http://schemas.xmlsoap.org/soap/envelope/
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\phase.c(210) Invoke the handler soap_action_based_dispatcher within the phase Dispatch
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\soap_action_disp.c(89) Checking for service using SOAPAction is not implemented
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\phase.c(210) Invoke the handler dispatch_post_conditions_evaluator within the phase PostDispatch
[Tue Jul 04 14:55:03 2017] [debug] ..\..\src\core\engine\phase.c(210) Invoke the handler context_handler within the phase PostDispatch
[Tue Jul 04 14:55:03 2017] [info]  [rampart][rampart_mod] rampart_mod shutdown

Could anybody please guide, what could be the reason.