Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sender JDBC Mapping error

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>

Former Member
replied

Hi prasad,

nice to know that it worked

Regards,

Bhavesh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question