on 07-10-2006 8:38 AM
Hi,
original source table value.
UPDATE_DATE
-
2006-07-05 PM 11:00:00
Source DT
update_date date type
inbound on SXMB_MONI
<UPDATE_DATE>2006-07-05 11:00:00.0</UPDATE_DATE>
Target DT
update_date date type
Request Message Mapping on SXMB_MONI
<UPDATE_DATE>2006-07-05 11:00:00.0</UPDATE_DATE>
mapping was good, but adapter issue was happened
History:
- 2006-07-10 15:37:44 YAKST: Error: TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'ZXICODE' (structure 'stmt1'): java.sql.SQLException: ORA-01861: literal does not match format string
Even though i tested static mapping(currentdate) in Mapping Editor as below, mapping no problem, but i got same issue on Adapter Monitoring.
<?xml version="1.0" encoding="UTF-8" ?>
- <ns:AA_CODE_01_MT xmlns:ns="http://aaa.aaa.com/aaacode">
- <stmt1>
- <ZXI_AA_01 action="UPDATE_INSERT">
<table>ZXI_AA_01</table>
- <access>
<CODE>2011</CODE>
<CODE_NKO>LIST01</CODE_NKO>
<DEPT>DEPT</DEPT>
<EMPNO>16318</EMPNO>
<UPDATE_DATE>2006-07-10 PM 16:32:24</UPDATE_DATE>
<CREATE_EMPNO>16318</CREATE_EMPNO>
<CREATE_DATE>2006-07-10 PM 16:32:24</CREATE_DATE>
</access>
- <key>
<CODE>2011</CODE>
</key>
</ZXI_AA_01>
</stmt1>
</ns:AA_CODE_01_MT>
thanks
venjamin
Hi Venjamin,
This I think is due to the fact that the DATE format that you are using to insert into the Database, doesnot match with the format expected by your database table.
take a look at this blog to see how you can overcome this issue using the Attribute hasQuot
/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.