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

Eight Stars

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

Are you trying to insert any date formatted data?
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

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

 

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 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog