Error in JDBC Receiver adapter
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