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

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
Highlighted
Four Stars

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

i hard coded this value in the tmap component,

didn't work

What’s New for Talend Spring ’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

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download