Mapping Transformation - Splitting for Target Structure having Occurence 1...1 in WSDL

[former_member666669]

Hi Experts,

          I am facing the Issues for Splitting the Messages in the Mapping level.

Here My Scenario

                      JDBC------->PI----->SOAP.

Source is from JDBC, where it will fetch multiple records at single shot and it will push to Target side of WSDL. The JDBC structure we have made to (0...Unbounded) so it pushing multiple records. But my WSDL structure is having occurrence(1...1) in the Parent Node, which it will not handle the Multiple Record in the Target side.So we need to split the Header Node for every "ROW" formed in the JDBC.

I have put the "SPLIT BY VALUE" node function in the Header node, the splitting not happening because of the 1...1 occurrence.

And i have also tried with the Changing the Occurence in the "Messages Tab"of Message Mapping (0...Unbounded), where it generating to "Messages" and "Message1" node in Structures.And also it gives the "http://sap.com/xi/XI/SplitAndMerge" namespace in the "After Mapping" in the Integration Engine level, where the Target WSDL is not supporting.

For the WSDL need to support, i need to remove the "Meassages" and "Message1" node where the  "http://sap.com/xi/XI/SplitAndMerge"  Namespace

is generating.

Below are the Two cases:

Case 1: For Single Occurence -  Message successfully Processing with Request and response Message(Splitting Not happening in the Mapping Level).

Case 2: For Multiple Occurence -  WSDL throwing the error in the Response message as shown in the enclosed document.

Please suggest Me any other possible cases and is there any Java UDF is there for Removing the Extra Nodes Occurred on the Target side.

Below are the Sample Target Structure:

  Header Node             ProcessMultiple                                1...1

                                             Materials                                 1..1

                                                    Items                                0...Unbounded

Please Reply at earliest, awaiting for your reply to proceed further.

Thanks in advance,

Harish...

[Former Member]

Hi Harish,

If possible instead of complicating the things try the below

Change the occurrence to 0..unbounded in wsdl by opening the wsdl in editplus or xmlspy etc..

else discuss the same issue with target system folks and ask them to change the occurrence .

Regards

Venkat

[Former Member]

Hi Harish,

If the webservice has 1:1 occurrence then it will be able to handle one record at a time and you will have to make multiple calls to webservice. After splitting the message in mapping did you use enhanced interface determination in ID? It will call the web service for each record.

However as suggested by Venkat, the best thing would be to check with wsdl team and get the occurrence changed to 0..unbounded.

Regards,

Beena.