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

5 REPLIES
Six 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

 

Six 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