Mapping problem in message response RFC --> xi --> JDBC

[Former Member]

Hi all,

I'm using the follow scenario:

RFC <-> xi <-> JDBC

It's a synchronous interface.

In JDBC the message do a SELECT in database and returns selected rows in message response.

The message response transfers selected rows to RFC.response in the mapping.

It seems working right but no data are transfered to RFC.

In SXMB_MONI I can see the selected rows from database.

There is no error in JDBC and RFC adapter. Bellow is the message response in the SXMB_MONI:

<ns1:MT_jbdc_select_response xmlns:ns1="http://braskem.com.br/xi/sapxi03">

<t7_productionorder_response>

<row>

<PRODUCT>Nafta Media</PRODUCT>

</row>

<row>

<PRODUCT>Nafta Media</PRODUCT>

</row>

</t7_productionorder_response>

</ns1:MT_jbdc_select_response>

I think that there is an error in message mapping between RFC.response <-- message_response, because I'm just mapping the fields <row> and <product>, because if I make a link beteween <t7_productionorder_response> and return table of RFC, a Short DUMP happens.

Bellow the structure of MESSAGE RESPONSE:

<t7_productionorder_response>

<row>

<PRODUCT/>

</row>

</t7_productionorder_response>

Bellow the structure of RFC RESPONSE:

<RFC.response>

<t_return>

<item>

<product/>

</item>

</return>

</RFC.response>

When I make a link in the mapping between

<t7_productionorder_response> -> <t_return>

a short DUMP happens in RFC call in R/3.

Anyone could help me about this problem ?

Thanks in advance

Regis Ferrato

[Former Member · Accepted solution]

Hi Regis,

I hope t_return has fixed occurrence 1:1.So i hope it doesnot require a mapping.But item field is 0:unbounded.so item requires mapping.Hope u have done it.

So try mapping

<jdbc_response>----<RFC.Response>

<row>----

---

<Item>

<PRODUCT>-----<product>

try this.

Regards,

Sudharshan

[Former Member]

Hi,

<i>because if I make a link beteween <t7_productionorder_response> and return table of RFC, a Short DUMP happens.</i>

After doing this mapping, did you test it in the IR mapping editor? was it successful?

Do specify the occurence of all the headers so we can help you better.

Regards,

Smitha.

[moorthy]

Hi,

Just take the response from the SXMB_MONI and put in the Response Mapping Editor in the Repository and test the Mapping. And also check, what is the error? Probably there is a mismacth in the nodes. You may required to look into the Display Queue so that you can get the exact error.

Hope this helps,

Regards,

Moorthy

[former_member189324]

Hi regis,

Looks like your response mapping is not working. Check the schema definitions of the Target structure in the Response mapping.

Also test the response mapping locally in the mapping porgram based upon the RFC response you are getting back from SAP System.

Thanks

Prasad