Skip to Content
0
Former Member
Jan 17, 2008 at 11:07 AM

Error in JDBC Receiver adapter

58 Views

Hi all,

I am facing following error in the Message monitoring while inserting data into oracle database through my jdbc receiver adapter. Not getting what might be the problem.

Error:

"Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 't_swapc_track' (structure 'statement'): java.sql.SQLException: ORA-01861: literal does not match format string."

here 't_swapc_track' is my oracle table name

My receiver structure m seing with data is :

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

- http://reliant.com/xi/SwapC">

- <statement>

- <t_swapc_track action="INSERT">

<table>t_swapc_track</table>

- <access>

<AGREEMENT>RRT000000001147970048</AGREEMENT>

<OFFER_CODE>50001935</OFFER_CODE>

<PROMO_CODE>TA2304</PROMO_CODE>

<SYSTEM>MMAS</SYSTEM>

<HIST_FLAG />

<DATE_PROC>2007-12-01</DATE_PROC>

<IDOC_NUM>0000000000000000</IDOC_NUM>

<HIST_NUM>0000000000093163</HIST_NUM>

</access>

- <access>

<AGREEMENT>RRM000000001148002609</AGREEMENT>

<OFFER_CODE>50001935</OFFER_CODE>

<PROMO_CODE>MA2175</PROMO_CODE>

<SYSTEM>MMAS</SYSTEM>

<HIST_FLAG />

<DATE_PROC>2007-12-03</DATE_PROC>

<IDOC_NUM>0000000000000000</IDOC_NUM>

<HIST_NUM>0000000000093163</HIST_NUM>

</access>

</t_swapc_track>

</statement>

</ns1:insertT_SWAPC_TRACK>

Please help me out in this problem.

Thanx in advance

Regards,

Hetal

Edited by: hetal shah on Jan 17, 2008 12:08 PM