Synchronous SOAP to JDBC scenario in SAP PO 7.4

758 Views

Hi Folks,

My scenario is SOAP to JDBC and JDBC to SOAP. Order no is the input parameter in SOAP and the JDBC should send the information of the order no. Here I am using SAP PO 7.4 version. I found few blogs and step by step screen shots but they used SAP XI/PI not PO.

Here I created 2 Data Types for SOAP (Request & Response) and 2 Data Type for JDBC (Request & Response), similarly 2 Message Type, 1 Service Interface, 2 Message Mapping and 1 Operation Mapping (which has both the message mapping in Request and Response tab).

In integration builder created a Sender communication channel for SOAP and Receiver communication channel for JDBC and Integrated Configuration.

Issue I am facing here is when I try to execute the SOAP WSDL i am not getting the output. I am getting the error

<context>XIAdapter</context>

<code>ADAPTER.JAVA_EXCEPTION</code>

<text>See log trace with id: n/a</text>

In monitor im seeing this message

Returning to application. Exception: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error encountered while executing mapping: com.sap.aii.af.service.mapping.MappingException: Mapping failed in runtimeRuntime Exception when executing application mapping program com/sap/xi/tf/_MM_Info_Response_To_Order_Response_; Details: com.sap.aii.mappingtool.tf7.IllegalInstanceException; Cannot create target element /ns0:MT_Order_Response. Values missing in queue context. Target XSD requires a value for this element, but the target-field mapping does not create one. Check whether the XML instance is valid for the source XSD, and whether the target-field mapping fulfils the requirement of the target XSD

Please guide me.

Thanks in advance,

Victor