Error in JDBC Receiver adapter

[Former Member]

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" ?>

- <ns1:insertT_SWAPC_TRACK xmlns:ns1="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

[Former Member]

Hi Hetal,

Your target sturcture should be as mentioned below:

•Statement

-

---

•tablename

-

---

•action

-

---

•TABLE

-

---

•access

Regards,

Sarvesh

[prateek]

There is problem with the structure u have defined. Keep ur tablename in Upper case.

In the JDBC Receiver adapter you have the Advanced Properties . Add the following

logSQLStatement true

This ll help u to identify the error

If nothing works,

Instead of multiple <access> node, use multiple <statement>

Regards,

Prateek

[GabrielSagaya]

Please format your date specification

http://www.techonthenet.com/oracle/errors/ora01861.php

[Former Member]

Hi,

Check your data format along with the character length you specified in oracle table.

Regards,

Nithiyanandam

[Former Member]

Hi Nityanandam,

i tried that but no change.... same error

Any other suggestions?

Regards,

Hetal

[Former Member]

Hi,

Check only the field level because there are chances that a string in a file is mapped to the numeric in Oracle table. This might cause an error. Also In your case you are using some date first as well check how have you represented that date in oracle table.

Regards,

Nithiyanandam