Reg RFC to JDBC "Parsing an empty source. Root element expected!"

[Former Member]

Hi techies,

This in regard of RFC to JDBC.

in integration test iam getting the error.

"com.sap.aii.utilxi.misc.api.BaseRuntimeException thrown during application mapping com/sap/xi/tf/_mm_mapping_: Parsing an empty source. Root element expected!"

My Mapping and interface mapping tests are working fine, while testing the configuration Iam getting this error.

My interface Mapping test result is as mentioned below

Sender Interface (RFC Sender)

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

<ns0:ZTEST_PI_ZHRT002 xmlns:ns0="urn:sap-com:document:sap:rfc:functions">

<ZHRT002>

<item>

<MANDT/>

<PERNR>1234</PERNR>

<PERID>kiran</PERID>

<SHOPN>test</SHOPN>

</item>

</ZHRT002>

</ns0:ZTEST_PI_ZHRT002>

Reciver Interface after test

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

<ns1:mt_receiver xmlns:ns1="urn:sap-com:RFC2JDBC"><Statement><dbTableName action="INSERT"><table>ZHRT002</table><access><PERNR>1234</PERNR><PERID>kiran</PERID><SHOPN>test</SHOPN><access></dbTableName></Statement></ns1:mt_receiver>

My message Mapping is as mentioned below

ZTEST_PI_ZHRT002 is my BAPI which is mapped to mt_receiver.

ZHRT002 it my table which is mapped to Statement of reciver

item of sender is floating ( not mapped to any reciver node)

subsequently feilds are mapped.

Reciver action is atribute (required) calling INSERT

table is "ZHRT002" (constant) (1...1)

This is my scenario.

Thanks in advance,

Regards,

Kiran

[Former Member]

Hi Bhaskar,

Thanks alot for your reply.

Now I have Mapped item feild of sender to access feild of reciver and both action and table are constants with value "INSERT" and "<dbtablename>".

Even Iam not getting the mesage status in SXMB_MONI.

Still having there is no data transfer.

Thanks In advance.

Regards,

Kiran

[baskar_gopalakrishnan2]

>>Even Iam not getting the mesage status in SXMB_MONI.

Still you have mapping issue.

Check JBDC adapter and see any error exist in adapter engine. Also provide more details about your target message structure.

Also go through this link.. This might be helpful.

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

[abhay_rajhans2]

Hi Kiran,

You can refer to below mentioned link. Which will help to build the JDBC scenario. Here go through how to define receiver JDBC.

http://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

[baskar_gopalakrishnan2]

This is RFC to JDBC. Is it Synchronous or Asynchronous?

Some tips:

Create JDBC target data structure something similar to this

<StatementName>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName>

Map Table name and action using Constant.

>>item of sender is floating ( not mapped to any reciver node)

What is that? you have to map source item node fields to target access fields.

Please go through the below sap link . This might be very helpful.

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

[naveen_chichili]

HI Kiran,

Please Map a constant[INSERT] for action element and Table name for the table field so that the structure can insert correctly into DB.

Cheers!!!

Naveen