topic Re: Message: ORA-01861: literal does not match format string in Talend Studio

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

Anonymous — Tue, 07 Nov 2017 06:57:47 GMT

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

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

Anonymous — Tue, 07 Nov 2017 08:11:46 GMT

Are you trying to insert any date formatted data?

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

Anonymous — Tue, 07 Nov 2017 08:50:07 GMT

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

the fields im using are

LastUpdateDate

CreationDate and others

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

Anonymous — Tue, 07 Nov 2017 11:02:55 GMT

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

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

Anonymous — Tue, 07 Nov 2017 11:55:09 GMT

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

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

Anonymous — Tue, 14 Nov 2017 14:12:34 GMT

i hard coded this value in the tmap component,

didn't work