Sync Receiver JDBC Adapter

[Former Member]

Hi All,

I was trying to make a synchronous call to a receiver jdbc adapter with the help of

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3928. [original link is broken] [original link is broken] [original link is broken] [original link is broken]

I am getting the following error in jdbc adapter.

<i>com.sap.aii.af.ra.ms.api.DeliveryException: ERROR:Processing request: Error when executing statement for table/stored proc. 'MISDetails': java.sql.SQLException: FATAL ERROR document format: structure 'STATEMENT', key element 'FiscalYear' contains no values</i>

My Source message is

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

<ns:MT_FILE_OUT xmlns:ns="urn:ters">

<REQUEST>

<FISCALYEAR>2007</FISCALYEAR>

<YEARMONTH>1</YEARMONTH>

<OPERATION>EQ</OPERATION>

</REQUEST>

</ns:MT_FILE_OUT></i>

And JDBC request message is ..

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

<ns:MT_JDBC_REQ xmlns:ns="urn:ters">

<STATEMENT>

<TABLENAMEACTION="SELECT">

<TABLE>MISDetails</TABLE>

</TABLENAME>

<ACCESS>

<FiscalYear> </FiscalYear>

<YearMonth> </YearMonth><ProductCode> </ProductCode><TargetVolume> </TargetVolume>

</ACCESS>

<KEY>

<FiscalYear compareOperation="EQ">2007</FiscalYear>

</KEY>

</STATEMENT>

</ns:MT_JDBC_REQ></i>

Regards,

Sumit

[bhavesh_kantilal · Accepted solution]

Sumit, the problem is that </TABLENAME> is closed ealier than necessary.

This is how the JDBC datatype should be,

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

<ns:MT_JDBC_REQ xmlns:ns="urn:ters">

<STATEMENT>

<TABLENAME ACTION="SELECT">

<TABLE>MISDetails</TABLE>

<ACCESS>

<FiscalYear> </FiscalYear>

<YearMonth> </YearMonth>

<ProductCode> </ProductCode>

<TargetVolume> </TargetVolume>

</ACCESS>

<KEY>

<FiscalYear compareOperation="EQ">2007</FiscalYear>

</KEY>

<b></TABLENAME></b>

</STATEMENT>

</ns:MT_JDBC_REQ>

The TABLE, ACCESS and KEY come under the TABLENAME tag.

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

Thanks..such a simple thing ihv been missin..

Cheers,

Sumit

[sridharreddy_kondam]

Hi Sumith,

Check the mapping once agian whether u have mapped correctly or not for the jdbc request...

and also try giving all fields as constant and cheque once

in the maping for the request JDBC w.r.t source

Regards,

Sridhar