cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01861 iteral does not match format string

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

bhavesh_kantilal
Active Contributor
0 Kudos

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

Answers (0)