Request message mapping giving blank xml message

[Former Member]

I was trying a scenario JDBC-> XI -> RFC for tranporting the db table data from sqlserver to sap r/3.

At the time of designing the mapping is working correctly.

But in the pipeline step "Request message mapping" it is generating the inbound message but with any values from outbound source message.

source message (xml ) structure

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

<ns0:CUST_REQ_MT xmlns:ns0="urn:sqlserver:vendor">

<row>

<NAME></NAME>

<ADDRESS></ADDRESS>

<AGE></AGE>

<LOGIN></LOGIN>

<PASSWORD></PASSWORD>

</row>

</ns0:CUST_REQ_MT>

and target message structure is

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

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

<UPDATE>

<item>

<NAME></NAME>

<ADDRESS></ADDRESS>

<AGE></AGE>

<LOGIN></LOGIN>

<PASSWORD></PASSWORD>

</item>

</UPDATE>

</ns0:ZBAPI_UPDATE_JDBC>

I have used the Graphical mapping tool for mapping these two MT's.

the payload in the request message mapping step is as follows:

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

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

- <UPDATE>

<item />

</UPDATE>

</ns0:ZBAPI_UPDATE_JDBC>

here you can see a blank tag <item/>.

How can i resolve this issue. I can not see any error anywhere.

Regards,

Gopesh

[Former Member]

HI Gopesh,

the Datatype should have the replicate the column name of the DB table.. and the structure should be

<row>

<colname1></colname1>

<colname2></colname2>

<colname3></colname3>

<colname4></colname4>

.

.

.

</row>

sree

[Former Member]

Hi,

It is not the issue of the datatype for outbound message for jdbc sender.

I have done the Graphical mapping and mapped the sourse message type to target message type (which is a rfc xml format request message type).

But when all the IR and ID objects activated and it comes to Runtime (integration server) then it is unable to execute the mapping in the xi pipeline step "Request Message Mapping" and generating a blank xml element as i have described earlier in my message.

What should i do or where should i check for the possible reasons and what could be the solution for this issue.

Regards

Gopesh

[Steven_UM]

Hi Goseph,

Did you try putting the Integration Server trace level to 3 and logging to 1 ? That will give you a very detailed message detail which might help in the resolution.

Did you check the cache as well to ensure that everything has been activated properly ?

Regards,

Steven

[Former Member]

Hi,

I found the solution for this problem that what ever objects we create in SAP XI 3.0 all are case sensitive.

So i have made some changes in the message types it now it is working fine at my end.

Thanks for your replies.

Regards

Gopesh

[Former Member]

Hi,

The format for a sender jdbc adapter is:

<resultset>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

</resultset>

Regards

Priyanka