topic records not seen in database in Talend Studio

records not seen in database

Anonymous — Fri, 14 Jul 2017 10:59:48 GMT

Hi,

While transferring data from excel to database table, I found some column mismatch errors which I fixed in both excel and mapping. But atlast it is giving just one error 'ORA-01861: literal does not match format string' and there is column description.Also in the job it shows all the records transferred from Input via tmap to Output, but still because of error none of the records is to be seen in database. How to handle this?

Re: records not seen in database

TRF — Fri, 14 Jul 2017 14:24:16 GMT

Can you share the tMap configuration?

Re: records not seen in database

cterenzi — Fri, 14 Jul 2017 15:51:38 GMT

Are you trying to insert a date?

Re: records not seen in database

Anonymous — Fri, 14 Jul 2017 16:09:25 GMT

Yes I am trying to insert Date.

Re: records not seen in database

Anonymous — Fri, 14 Jul 2017 16:13:52 GMT

Ok here it is.

Re: records not seen in database

Anonymous — Tue, 18 Jul 2017 11:37:02 GMT

Hello!

Do you have any date field in any of your schemas? You should have a look at them, it seems that you're trying to load some date information as String and your table hold it as a date format.

Could you share your table metadata information?

Thank you