on 01-17-2008 11:07 AM
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
Hi Hetal,
Your target sturcture should be as mentioned below:
Statement
-
tablename
-
action
-
TABLE
-
access
Regards,
Sarvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please format your date specification
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check your data format along with the character length you specified in oracle table.
Regards,
Nithiyanandam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.