Message: ORA-01861: literal does not match format string

Highlighted
Four Stars

Message: ORA-01861: literal does not match format string

Hi all, 

 

in talend, im doing the integration, and when i run the job, i am facing this issue, 
can anyone please help me with this?? 

 

this is the exact error that it is showing

 

================================================

Starting job tfileinput at 11:56 07/11/2017.

[statistics] connecting to socket on port 3863
[statistics] connected
SQLState: 22008
Error Code: 1861
Message: ORA-01861: literal does not match format string
SQLState: 22008
Error Code: 1861
Message: ORA-01861: literal does not match format string
[statistics] disconnected
Job tfileinput ended at 11:56 07/11/2017. [exit code=0]

=========================================================

 

 

 

Thanks and Regards

Rak**bleep**a

Highlighted
Eight Stars

Re: Message: ORA-01861: literal does not match format string

Are you trying to insert any date formatted data?
Highlighted
Four Stars

Re: Message: ORA-01861: literal does not match format string

yes..im using the tmap component in talend, im mapping the columns accordingly

the fields im using are 

LastUpdateDate

CreationDate and othersScreenshot (596).png

Highlighted
Four Stars

Re: Message: ORA-01861: literal does not match format string

Actually in SOAPUI response side, i am getting

<ns2:LastUpdateDate>2017-11-07T06:44:16.081Z</ns2:LastUpdateDate>

and  2017-11-07T06:44:16.081Z i'm trying to insert in database which is in 20-08-17 format,

 

 

so how to resolve this, can you please tell me

 

Highlighted
Eight Stars

Re: Message: ORA-01861: literal does not match format string

Please mention the date pattern for above field as "yyyy-MM-dd'T'HH:mm:ss.SSSZ" in oracle component schema
Four Stars

Re: Message: ORA-01861: literal does not match format string

i hard coded this value in the tmap component,

didn't work

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog