Sender JDBC Mapping error

[Former Member]

Can some one help me with the following error please?

I just want to read store column from Oracle database table SA_BO_SALES_TEST and create a Flat File. I have JDBC-XI-FILE scenario. I use the same Data Type for Sender(JDBC) and receiver(FILE) Message Type.

the data type is

DT_STSSales_SA_BO_SALES

resultset

row

STORE

The message type is

MT_STSSales_SA_BO_SALES

resultset

row

STORE

The message mapping is between the same message type(MT_STSSales_SA_BO_SALES) for source interface and destination interface.

The sender JDBC Adapter has

Query SQL Statement -

SELECT STORE FROM SA_BO_SALES_TEST WHERE PROCESS_DATE IS NULL

Update SQL Statement -

UPDATE SA_BO_SALES_TEST SET PROCESS_DATE='01-JAN-2006' WHERE PROCESS_DATE IS NULL

Document Name -

resultset

When i execute this scenario, The payload from any pipeline steps is

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

- <resultset>

- <row>

<STORE>1021</STORE>

</row>

- <row>

<STORE>1021</STORE>

</row>

- <row>

<STORE>1021</STORE>

</row>

</resultset>

and it updates the Oracle table with PROCESS_DATE='01-JAN-2006' . But

One of the pipe line step "Request Message Mapping" is failed with the error.

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

- <!-- Request Message Mapping

-->

- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="">

<SAP:Category>Application</SAP:Category>

<SAP:Code area="MAPPING">EXCEPTION_DURING_EXECUTE</SAP:Code>

<SAP:P1>com/sap/xi/tf/_MM_STSSales_IDOC_BAPI_POSTR_CREATE~</SAP:P1>

<SAP:P2>com.sap.aii.utilxi.misc.api.BaseRuntimeException</SAP:P2>

<SAP:P3>RuntimeException in Message-Mapping transformatio~</SAP:P3>

<SAP:P4 />

<SAP:AdditionalText />

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack>During the application mapping com/sap/xi/tf/_MM_STSSales_IDOC_BAPI_POSTR_CREATE~ a com.sap.aii.utilxi.misc.api.BaseRuntimeException was thrown: RuntimeException in Message-Mapping transformatio~</SAP:Stack>

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

[moorthy · Accepted solution]

Hi,

Are u able to get inbound message in the SXMB_MONI. If so take that input and execute the Mapping in the Repository with Test Tab. I think there will be some mapping runtime exception. Just check it.

Hope this helps,

Regards,

Moorthy

[Former Member · Accepted solution]

Moorthy,

Yes, I can see the inbound message in the SXMB_MONI.

I have tried that. everty thing is fine.

SOURCE XML -

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

<ns0:MT_STSSales_SA_BO_SALES xmlns:ns0="http://zalecorp.com/sts_posdm_sales_10">

- <resultset>

- <row>

<STORE>1021</STORE>

</row>

- <row>

<STORE>1021</STORE>

</row>

- <row>

<STORE>1021</STORE>

</row>

</resultset>

</ns0:MT_STSSales_SA_BO_SALES>

converted into the following XML wihtout any errors

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

<ns0:MT_STSSales_SA_BO_SALES xmlns:ns0="http://zalecorp.com/sts_posdm_sales_10"><resultset><row><STORE>1021</STORE></row><row><STORE>1021</STORE></row><row><STORE>1021</STORE></row></resultset></ns0:MT_STSSales_SA_BO_SALES>

[bhavesh_kantilal · Accepted solution]

Hi Prasad,

<i>converted into the following XML wihtout any errors</i>

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

<ns0:MT_STSSales_SA_BO_SALES xmlns:ns0="http://zalecorp.com/sts_posdm_sales_10"><resultset><row><STORE>1021</STORE></row><row><STORE>1021</STORE></row><row><STORE>1021</STORE></row></resultset></ns0:MT_STSSales_SA_BO_SALES></i>

If you have given the name for your Datatype as "<ns0:MT_STSSales_SA_BO_SALES xmlns:ns0="http://zalecorp.com/sts_posdm_sales_10">", then the RESULTSET tag is not to be used.

You will have to enter this Value <b>MT_STSSales_SA_BO_SALES</b> in the SENDER JDBC ADAPTER > DOCUMENT NAME and <b>http://zalecorp.com/sts_posdm_sales_10</b> in SENDER JDBC ADAPTER> DOCUMENT NAMESPACE and then <b>Remove the Result Set tag.</b>

just take a look at the Document Name part of the JDBC adapter in this link,

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Regards,

Bhavesh

[Former Member · Accepted solution]

Bhavesh ,

I have changed the Document Name to MT_STSSales_SA_BO_SALES instead of resultset and entered the namespace. it works fine. And also i have noticed that all the fields under <ROW> in Data Type must be in upper case.

thanks you so much for all your help

[bhavesh_kantilal · Accepted solution]

Hi prasad,

nice to know that it worked

Regards,

Bhavesh

[former_member187339]

Hi,

Two suggestions:

1) Check the occurence of row and STORE.

2) Remove the namespace from the XML Namespace field when you create MT.

Then try again.

Regards

Suraj

[moorthy]

If mapping is working in the IR with same input from the SXMB_MONI, then I think you need to check

• Try to restart the Message by clicking on Retstart Button

• SXI_CACHE ->Message Mapping

*the RFC destination for the Java Engine and Integration engine. Go to SM59 in the XI -> go to->TCP/IP Connections->AI_RUNTIME_JCOSERVER .. Test the connection of this.

Once again try to give with different data in the input and check the Mapping.

One more thing, if there is no transformation required, then it is not required to have mapping. You can create two message Interfaces(Outbound for JDBC and Inbound for File of same message type).

Hope this helps,

Moorthy

[Former Member]

Prasad,

You have told that it is a simple JDBC-XI-File scenario. But the error says:

<SAP:P1>com/sap/xi/tf/_MM_STSSales_IDOC_BAPI_POSTR_CREATE~</SAP:P1>

<SAP:P2>com.sap.aii.utilxi.misc.api.BaseRuntimeException</SAP:P2>

<SAP:P3>RuntimeException in Message-Mapping transformatio~</SAP:P3>

Have you used any IDoc or BAPI here. It says there is a problem in Message Mapping. So kindly go throught the mapping once.

---Mohan

[Former Member]

Mohan,

I just used the name like IDOC_BAPI. But it is simple JBDC_XI_FIle scenario only. my mapping is dam simple.i use the same data type for source and destination message type.