Interface Mappings in BPM Collect Pattern

[Former Member]

Hello

I am new to XI development and currently facing problems while implementing collect pattern of BPM.

I am trying to map IDoc structure with target legacy format.In BPM I had a block with infinite loop where I am transforming IDocs to target legacy format.Then I am trying to transform list element (Multiline Abstract container variable) to form a single message.For this I tried to have interface map with Occurences 0..unbound..but while activation of Interface Map it gives error

<b> Mapping program Message does not match the interface mapping. The number or frequencies of source or target messages for the message mapping are not identical to the number or frequencies of source or target interfaces.</b>

If I use single line in Interface map then in BPM it gives error when passed Multiline element to this Interface map.

I checked the sample program provided by SAP but I found out that every message interface was using same Message Type which has got occurence as 1 but in the message mapping program its 0..unbound.

My question is can we have data type (or Message type )with Occurence as 1 and Message Mapping program using same message type with occurences 0..unbound..I tried to find such option but could'nt find that.Otherwise how to do Interface Map for transforming Multiline parameter of BPM to a single message.

Please help..Thanks in advance..

Regards

Rajeev Patkie

[Former Member]

Hello Rajeev/Sridhar,

I am also facing same problem as you faced.

I am trying to collect po line item xmls and form a final po xml.evenif in mapping editor i have added 2 xmls using duplicate subtree, i am getting only one po line item in target xml. Pl can you suggest me which step I am missing.In this web log Sridhar has suggested to use splitbyvalue..this is for what????pl can you explain.

See my source xml is as this

<?xml version="1.0" encoding="UTF-8"?>

<ns1:Messages xmlns:ns1="http://sap.com/xi/XI/SplitAndMerge">

<ns1:Message1>

<ns:Purchase_Order_Request_new_one xmlns:ns="http://rapidigm.com/test">

<header>

<key>2</key>

<DocDate>1</DocDate>

<DocType>1</DocType>

<PurchOrg>1</PurchOrg>

<PurchGroup>1</PurchGroup>

<Vendor>1</Vendor>

</header>

<item>

<itemno>1</itemno>

<materialno>1</materialno>

<qty>1</qty>

<description>1</description>

</item>

</ns:Purchase_Order_Request_new_one>

<ns:Purchase_Order_Request_new_one xmlns:ns="http://rapidigm.com/test">

<header>

<key>2</key>

<DocDate>1</DocDate>

<DocType>1</DocType>

<PurchOrg>1</PurchOrg>

<PurchGroup>1</PurchGroup>

<Vendor>1</Vendor>

</header>

<item>

<itemno>1</itemno>

<materialno>1</materialno>

<qty>1</qty>

<description>1</description>

</item>

</ns:Purchase_Order_Request_new_one>

</ns1:Message1>

</ns1:Messages>

thanks in advance,

Sharada

[Former Member]

Please can you suggest on this

thanks,

Sharada

[former_member185751]

Hi Rajeev,

The Multi-line container with the collected Idocs will look like this for e.g.:

<ns2:Messages xmlns:ns2="http://sap.com/xi/XI/SplitAndMerge">

<ns2:Message1>

<Orders>

<Idoc>

................

</Idoc>

</orders>

<Orders>

<Idoc>

................

</Idoc>

</orders>

</ns2:Message1>

</ns2:Messages>

For simplicity of explanation let me assume that you are composing a target message with one header and mutiple detail records which may look like this fo e.g.:

<ns3:Messages>

<ns3:Message1>

<Target>

<Header>

<Value1>123</Value1>

<Value2>abcd<Value2>

</Header>

<Details>

<Value3>456</Value3>

<Value4>tyyy<Value4>

</Details>

<Details>

<Value3>789</Value3>

<Value4>aqwed<Value4>

</Details>

</Target>

</ns3:Message1>

</ns3:Messages>

When you are creating the message mapping, change the occurence rate of the message to "unbounded" . Now the <Orders> tag in the source message which can occur "n" times should be mapped to the <Details> tag of the target message which can also occur "n" times. The remaining fields are mapped as per your requirement.

When you are creating the interface mapping make sure you set the instance to 0 ..to...unbounded for the IDoc source abstract interface.

Test the interface mapping in the Integration Builder test tool with a sample multi-line message.

Hope this will clarify your doubt !!

Regards,

Sridhar

[Former Member]

Sridhar,

Thanks for your reply.

Actually in message mappings I changed occurances of source from 0..unbounded. But should I generate new message type with as a multi-line type.Actually the example given by SAP is very confusing (BpmPatternCollectMerge). It has got message mapping of same Message Type but one with occurance rate of 0..unbounded and other with single line. Thats what confuses me is if they are expecting to collect multiple message to one message, the target message should be a multi-line message.

For the same I created another data type with occurances of root element as 0..unbounded.But when tested from test tool it gives the target message blank.

Can you please clear whether for collecting message do we need to create a new data type of multiple lines and how should we perform the maps?

Thanks in advance.

Regards

Rajeev

[former_member185751]

Hi Rajeev,

For the Source message...what you have done is correct i.e. setting it to 0..unbounded.

For the target message...the occurence should be set to "1".This target message is a single message structure which may or may not have a node which can occur "n" times. See the example sighted in my previous post: the target has one header and multiple details.

If you still have problems understanding, drop your email address here, i will send you an example.

Regards,

Sridhar

[moorthy]

HI,

I have my source IDOC ( 0..unbound) and target is file structure. I need to do N:1 mapping. After doing mapping I am getting following error. The entire scenario is exactly same as what you have explained.

"Cannot produce target element /ns:Messages. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd"

Can u tell me what may be the problems?

Thanks in advance,

Moorthy

[former_member185751]

Hi Moorthy,

1.Check your mapping and also the message interfaces used.

2.Check the input data

3.Check the namespaces

Regards,

Sridhar

[Former Member]

Hi,

we have to do a one to one mapping only. But once the mapping is thru, the source side root nodes context should be made Message whcih will be the root most node. Why because, when the BPM is collecting the messages into the container and sending the same, in the source structure, its the messages that is coming in and this should be appended to the target structure depending on its occurence and mapping.

Cheers

JK

[former_member185751]

Hi JK,

I'm not sure whether i understand you correctly.

As soon as you change the occurence of the source message to 0..unbounded, the source and target message structure in the integration builder will be automatically changed as follows e.g.:

Source message:

<ns3:Messages xmlns:ns3="http://sap.com/xi/XI/SplitAndMerge">

<ns3:Message1>

......................

</ns3:Message1>

</ns3:Messages>

Target Message:

<ns4:Messages xmlns:ns4="http://sap.com/xi/XI/SplitAndMerge">

<ns4:Message1>

.....................

</ns4:Message1>

</ns4:Messages>

I would recommend to first set the occurences and then do the mapping in case of a multi-mapping.

Regards,

Sridhar

[Former Member]

Sridhar,

Thanks for the reply. I will describe my scenario in brief.

1] I am having a IDoc which needs to be converted to legacy file format for which I created necessary mappings and interfaces which are running fine if its a one IDoc i.e. it creates one file per IDoc.In order to have a combined file of IDocs(say for 3 IDocs) I am using BPM.

I am having a loop in which IDoc receiver is set to recevie the IDoc and then transform into the legacy file format.The loop will transform the IDoc into legacy file and collect legacy file structure as a multiline structure. Then I am doing transformation from multi-line legacy file format to 1 file (i.e. 1 file containing multiple records).

For the same I designed a <b>Interface mapping</b> with occurances as 0..unbound as a source and occurance 1 in the target.

In the <b>message mapping</b>, since I am expecting multiple lines in the target file I have designed a multi-line structure(I recreated my data type with occurences 1..unbound) and then had map 1 to 1.

Also when checked from testing tool of interface or message map, it does'nt give any error.

Thanks in advance.

Regards

Rajeev

[former_member185751]

Hi Rajeev,

I understand your scenario clearly now but you have not mentioned what is the problem you are facing.

Did you use a multi-line message to test your message/interface mapping?

What is the output structure of the test? can you represent the structure here with an example?

Source Message:

<ns3:Messages xmlns:ns3="http://sap.com/xi/XI/SplitAndMerge">

<ns3:Message1>

<TestInput>

<Details>

<Value3>456</Value3>

<Value4>tyyy<Value4>

</Details>

</TestInput>

<TestInput>

<Details>

<Value3>789</Value3>

<Value4>aqwed<Value4>

</Details>

</TestInput>

</ns3:Message1>

</ns3:Messages>

Target message that you want:

Target Message:

<ns4:Messages xmlns:ns4="http://sap.com/xi/XI/SplitAndMerge">

<ns4:Message1>

<TestOutput>

<Details>

<Value3>456</Value3>

<Value4>tyyy<Value4>

</Details>

<Details>

<Value3>789</Value3>

<Value4>aqwed<Value4>

</Details>

</TestOutput>

</ns4:Message1>

</ns4:Messages>

The above example representation shows what you are trying to achieve. When you do the mapping make sure the output values are separated by a context separator. Note, In the above example <TextInput> tag which occurs "n" will be mapped to <Details> tag (which can also occur "n" times) in the target message. Rest of the mapping are done as usual.

Let me know.

Regards,

Sridhar

Message was edited by: Sridhar Rajan Natarajan

[Former Member · Accepted solution]

Sridhar,

It throws error in mappings.When monitored through Workflow log it gives following errors:

At the beginning of the workflow it gives exception

Error handling for work item 000000007250

Message no. SWF_RUN630

In mapping step it gives

Work item 000000007250: Object CL_SWF_XI_MSG_BROKER method CALL_TRANSFORMATION cannot be executed

and com/sap/xi/tf/_MultiLine_Test_com.sap.aii.utilxi.misc.api.BaseRuntimeExceptionRuntimeException in Message-Mapping transformatio~

Message no. SAI_MAPPING217

there any way to debug the process of BPM?

Regards

Rajeev

[former_member185751 · Accepted solution]

Hi Rajeev,

BaseRuntimeExceptionRuntimeException is a common exception if there is something wrong with the mapping done.

Test your message mapping/Interface mapping in the Integration builder test tool first and ensure you get proper/expected output.

Then go ahead and test your scenario fully.

Regards,

Sridhar

[Former Member]

When tested Interface mapping from the test tool it does not give any error. All the time it says the test is successful.

Regards

Rajeev

[former_member185751]

What is the generated output XML (target) look like in the integration builder test tool?

Regards,

Sridhar

[Former Member]

Initially I tried to perform test by tree view and it worked fine.But it was one message in the source and the same was in target.Later as given by you I updated XML source message.The source message looks like

******************Source Message***********************

<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">

<ns0:Message1>

<ns1:MATMAS_to_Stockware_MT xmlns:ns1="http://mccormick.com/ez_dev">

<MAT_List>

<ZPITNO>121212</ZPITNO>

<ZPIDS>Test Message</ZPIDS>

<ZPPOPN />

<ZPCNQT />

<ZPZLOC />

<ZPZPCB />

<ZPZCPA />

<ZPGRWE />

<ZPSAEL />

<ZSPLDY />

<ZPFRAG />

<ZPZCRO />

<ZPZOPT />

</MAT_List>

</ns1:MATMAS_to_Stockware_MT>

</ns0:Message1>

</ns0:Messages>

<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">

<ns0:Message2>

<ns1:MATMAS_to_Stockware_MT xmlns:ns1="http://mccormick.com/ez_dev">

<MAT_List>

<ZPITNO>78912</ZPITNO>

<ZPIDS>Test Message12</ZPIDS>

<ZPPOPN />

<ZPCNQT />

<ZPZLOC />

<ZPZPCB />

<ZPZCPA />

<ZPGRWE />

<ZPSAEL />

<ZSPLDY />

<ZPFRAG />

<ZPZCRO />

<ZPZOPT />

</MAT_List>

</ns1:MATMAS_to_Stockware_MT>

</ns0:Message2>

</ns0:Messages>

************************End Source*********************

if this would be the message multiline is generating its bound to fail as I guess every XML has one topmost element and over here.So I changed my source XML to look like

******************Start message******************

<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">

<ns0:Message1>

<ns1:MATMAS_to_Stockware_MT xmlns:ns1="http://mccormick.com/ez_dev">

<MAT_List>

<ZPITNO>121212</ZPITNO>

<ZPIDS>Test Message</ZPIDS>

<ZPPOPN />

<ZPCNQT />

<ZPZLOC />

<ZPZPCB />

<ZPZCPA />

<ZPGRWE />

<ZPSAEL />

<ZSPLDY />

<ZPFRAG />

<ZPZCRO />

<ZPZOPT />

</MAT_List>

</ns1:MATMAS_to_Stockware_MT>

</ns0:Message1>

<ns0:Message2>

<ns1:MATMAS_to_Stockware_MT xmlns:ns1="http://mccormick.com/ez_dev">

<MAT_List>

<ZPITNO>78912</ZPITNO>

<ZPIDS>Test Message12</ZPIDS>

<ZPPOPN />

<ZPCNQT />

<ZPZLOC />

<ZPZPCB />

<ZPZCPA />

<ZPGRWE />

<ZPSAEL />

<ZSPLDY />

<ZPFRAG />

<ZPZCRO />

<ZPZOPT />

</MAT_List>

</ns1:MATMAS_to_Stockware_MT>

</ns0:Message2>

</ns0:Messages>

**********************End Message****************

but this produces only one output message

******************Start Message***********************

<?xml version="1.0" encoding="UTF-8"?>

<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">

<ns0:Message1>

<ns1:MATMAS_to_Stockware_List xmlns:ns1="http://mccormick.com/ez_dev">

<MAT_List>

<ZPITNO>121212</ZPITNO>

<ZPIDS>Test Message</ZPIDS>

<ZPPOPN />

<ZPCNQT />

<ZPZLOC />

<ZPZPCB />

<ZPZCPA />

<ZPGRWE />

<ZPSAEL />

<ZSPLDY />

<ZPFRAG />

<ZPZCRO />

<ZPZOPT />

</MAT_List>

</ns1:MATMAS_to_Stockware_List>

</ns0:Message1>

</ns0:Messages>

**********************End Message****************

I am also pasting schema of message mappings

*****************Source Schema************************

<?xml version="1.0" encoding="UTF-8"?>

<xsd:schema targetNamespace="http://sap.com/xi/XI/SplitAndMerge" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://sap.com/xi/XI/SplitAndMerge">

<xsd:import namespace="http://mccormick.com/ez_dev" />

<xsd:element name="Messages" xmlns:p0="http://mccormick.com/ez_dev">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Message1" form="qualified">

<xsd:complexType>

<xsd:sequence>

<xsd:element ref="p0:MATMAS_to_Stockware_MT" minOccurs="0" maxOccurs="unbounded" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:schema>

********************End Source***********************

********************Target Schema******************

<?xml version="1.0" encoding="UTF-8"?>

<xsd:schema targetNamespace="http://sap.com/xi/XI/SplitAndMerge" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://sap.com/xi/XI/SplitAndMerge">

<xsd:import namespace="http://mccormick.com/ez_dev" />

<xsd:element name="Messages" xmlns:p0="http://mccormick.com/ez_dev">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Message1" form="qualified">

<xsd:complexType>

<xsd:sequence>

<xsd:element ref="p0:MATMAS_to_Stockware_List" />

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:schema>

****************************End Target*************

Thanks in advance.

Regards

Rajeev

[former_member185751]

Hi Rajeev,

Looks like you have made a mistake contructing your source XML. My guess is that you duplicated subtree at "Message1" level.You should do it at this tag "MATMAS_to_Stockware_MT" level.Test with the following source XML:

<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">

<ns0:Message1>

<ns1:MATMAS_to_Stockware_MT xmlns:ns1="http://mccormick.com/ez_dev">

<MAT_List>

<ZPITNO>121212</ZPITNO>

<ZPIDS>Test Message</ZPIDS>

<ZPPOPN/>

<ZPCNQT/>

<ZPZLOC/>

<ZPZPCB/>

<ZPZCPA/>

<ZPGRWE/>

<ZPSAEL/>

<ZSPLDY/>

<ZPFRAG/>

<ZPZCRO/>

<ZPZOPT/>

</MAT_List>

</ns1:MATMAS_to_Stockware_MT>

<ns1:MATMAS_to_Stockware_MT xmlns:ns1="http://mccormick.com/ez_dev">

<MAT_List>

<ZPITNO>78912</ZPITNO>

<ZPIDS>Test Message12</ZPIDS>

<ZPPOPN/>

<ZPCNQT/>

<ZPZLOC/>

<ZPZPCB/>

<ZPZCPA/>

<ZPGRWE/>

<ZPSAEL/>

<ZSPLDY/>

<ZPFRAG/>

<ZPZCRO/>

<ZPZOPT/>

</MAT_List>

</ns1:MATMAS_to_Stockware_MT>

</ns0:Message1>

</ns0:Messages>

The above representation shows how the collected message will look like in a multi-line container.

Instead of manually creating the second source XML message, In the "Test" tab just go the tabular tree right click on this tag "MATMAS_to_Stockware_MT" and select "duplicate subtree". Then you can edit the values in it.

Ensure that you have mapped the "MATMAS_to_Stockware_MT" which can occur "n" times to the node in target structure which can also occurs "n" times.

Let me know how it goes.

Regards,

Sridhar

[Former Member]

Even I tried that.It generates only one node.But it does not throws error.Here the target structure I created by copy pasting same data type but changing the occurences of Mat_List element (Similar to what SAP has done by exporting schema of IDoc as XSD and then reimporting the same).I guess in the target format, multiple Mat_list element would generate multiple lines.

Regards

Rajeev

[former_member185751]

Hi Rajeev,

The objective is we shld not get any error and the mapping shld generate the second node also.

Did you map this element <ns1:MATMAS_to_Stockware_MT> in source structure to this element <MAT_List> in target structure?

Just "Display queue" and see how the values are arranged in the queue. Are they separated by a context separator?

If not use splitbyvalue to introduce context separator.

Le me know.

Regards,

Sridhar

[Former Member]

Now its showing multiple messages but the error persists. I tested my other interface(IDoc to File) with 2 different IDocs,combined outputs of the both and again did test for multiple map which again is fine.

So theres no possibility of mapping errors according to me.However when I analyzed my workflow logs (by clicking on PE tag and then getting a detailed view) the date and time it shows of Workflow started is not same as what I am doing the test.Is it something related to cache updates? (I cleared cache also by SXI_CACHE).

Thanks in advance.

Regards

Rajeev

[former_member185751]

Hi Rajeev,

Good to know that the mapping is working fine.

Now, lets try to resolve this problem occuring in BPM.

Execute SWDD and check whether the correct version of workflow is available. Investigate the graphical flow to see and ensure that its the same as the one you have designed.

In SXI_CACHE did u see the return code as 0?

Let me know.

Regards,

Sridhar

Message was edited by: Sridhar Rajan Natarajan

[Former Member]

I had checked SXI_CACHE and it has got return code 0.But when I checked Workflow log Graphical view it did not showed me the exception branches which I added to BPM yesterday.

Also as I mentioned earlier for Workflow Started it shows date and time of yesterday which is quite wierd.When clicked on the details it says background work item created.

Regards

Rajeev

[former_member185751]

OK good....i have seen this many times when i built my scenario.

Do the following to resolve the problem:

1.From the integration repository, make a small change to your integration process say for e.g. add and remove description and SAVE& ACTIVATE the changes.

2.Now check the SXI_CACHE, you will see return code 99 for your integration process.

3.If you have return code 99, click on the activate button.you will navigate to the next screen.In the second screen clik on the delete button.

4.Repeat step 1.

5.Check SXI_CACHE, now you shld be able to see return code 0.

6.select your integration process and click on the "spectacles" button (SWDD) you will be navigated to the Process Builder screen . Check the version of the workflow and graphical view. It will be the new one.

Let me know.

Regards,

Sridhar

Message was edited by: Sridhar Rajan Natarajan

[Former Member]

It shows me the current version in SXI_CACHE. Do we need to check some workflow settings for the same because as I said earlier the workflow started is showing yesterday's date and timestamp.

Regards

Rajeev

[former_member185751]

What is the return code you see in SXI_CACHE after you made the change to your integration process (as mentioned in Step1 of my previous post)?

Regards,

Sridhar

[Former Member]

Return code is 0.

Regards

Rajeev

[former_member185751]

Follow step6 and check whether you have latest version. Ensure that the graphical flow represents the latest integration process designed in your Repository.

If it has the latest version, then you may test your scenario fully.

Regards,

Sridhar

[Former Member]

Actually I don't have access to SWDD transaction.So I guess I will need BASIS help over here.

Anyways thanks for your help.

Regards

Rajeev

[Former Member]

Now I checked my SWDD also and I can see my newer workflow over there.

Can it happen due to co-relation.I have used Client id as a correlation (MANDT).

Regards

Rajeev

[former_member185751]

What is the latest test result?

Regards,

Sridhar

[Former Member]

The result is same.No change in that. Error.

Can you tell me one small thing? This may be the very very basic question for a programmer.But if we want to collect say 2 IDocs how should we define loop step?

Ideally in programming languages we used to write

while(i<5){ i++;}

Over here I could not found < or > symbols (there were =,!=,EX and ~ symbols) while defining the condition so I tried with != and then increment the loop (since 0 is not equal to 2 returns true).But it niether works for counter != 2 or counter = 0.

regards

rajeev

[former_member185751]

Ensure that you have set the correlation properly.

<i>"The loop continues to run while the end condition returns true (while loop)"</i>

So you shld be having Counter!=2.Follow the example given in "BpmPatternCollectPayload" pattern.

Does your collection scenario require payload dependentloop ?

You have said you are collecting the transformed message. so why are you trying to collect the IDocs?

What made you conclude that its not working?

Regards,

Sridhar

[Former Member]

As I said for testing I have configured for 2 IDocs.For that I had a loop. The loop contains IDoc Receiver step,Transform step to transform from IDoc to File and 2 container operations one for incrementing the counter and other for collecting the file. Then in the another block I has a transform step where I am using a multi-map to convert multiple lines to single line and then finally a Send step.

In the payload depending example given by SAP they had done exactly the same thing except transformation inside the loop.Over there they have ID coming from IDoc and in my case its MANDT.

In the graphical view it shows error in second transformation step. When I click on PE i.e. Process Error it shows the graphical view and shows error in transformation and in workflow logs as I said earlier its giving past date for Workflow started.

Regards

Rajeev

[former_member185751]

First step examine the multi-line container to check whether it has collected message and also examine the structure of the collected message. copy and paste the collected message here.

Second, Check the scope of all the container variables.

Third, Remove the block and put the multi-map step and send step just as shown in the BpmPatternCollectPayload i.e. immediately after the loop step.

Try this and let me know.

Regards,

Sridhar

[Former Member]

I did all that you mentioned.All the container variables has got scope Process.I am not getting the payload of collect message.

I guess tommorow I will create a new BPM with similar steps and check.Hope that will create a new workflow.I am having one successful BPM.I compared workflow logs of the 2

The successful one has got following messages

1]Workflow Started with current date and time

Background work item created

Background Processing Started

Work Item Processing Complete

Result Processing

etc etc

and the error one states

2] Workflow Started with 2 days previous date

Error message created for Admin

Exception occured etc etc

Thanks a lot for responding continously.I will surely let you know the result of new BPM.

Regards

Rajeev

[Former Member]

Finally my BPM worked.I literally copied my earlier BPM and created a newer one which is working fine.

Anyways thanks for ur help in testing tools like SWDD and multi mapping concepts.

Thanks And Regards

Rajeev Patkie

[former_member185751]

Hi Rajeev,

I too faced some cache refresh problem with the integration process. I finally opted to create a new BPM and it finally worked just like yours. My scenario was extending the BPM pattern based on the deadline.

I'm so glad that it finally worked for you.

Regards,

Sridhar