topic Re: unparsable date Error in Talend Studio

unparsable date Error

Anonymous — Sat, 16 Nov 2024 05:41:11 GMT

I'm trying to load a tab delimited data file to Snowflake using talend job. Here are the objects i used

fFilelist ==>tFileInputDelimited ==> tDBOutput (Snowflake).

Here is the error i get. The date format in the file is DD/MM/YY hh:mm:ss

Couldn't parse value for column 'UPDATE_DATE' in 'row1', value is '24/01/19 02:31:13'. Details: java.lang.RuntimeException: Unparseable date: "24/01/19 02:31:13"

Please help.

Re: unparsable date Error

Anonymous — Sun, 02 Jun 2019 16:09:14 GMT

I was able to fix the issue with date. Now i'm getting the below error. The db, table and schema names are provided in the Snowflake Connection object. Can someone provide inputs on this?

"No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command."

Re: unparsable date Error

Anonymous — Sun, 02 Jun 2019 17:30:12 GMT

Hi,

Could you please verify whether the warehouse name details you have given is correct for the flow?

The current issue is because the value you have given in this attribute is not an active Snowflake warehouse.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: unparsable date Error

Anonymous — Sun, 02 Jun 2019 18:55:21 GMT

Thanks for the quick reply. in tDBOutput i chose the tDBConnection from Connection Component drop box. The warehouse name given in tDBConnection is correct and i'm able to login into Snowflake, run queries in that specific warehouse.

Re: unparsable date Error

Anonymous — Sun, 02 Jun 2019 19:08:50 GMT

you are right. I thought I gave the warehouse name in the tDBConnection... But for some reason the warehouse name is blank. Got it worked. Thank you.

Re: unparsable date Error

Anonymous — Sun, 02 Jun 2019 19:47:21 GMT

@appu

Thanks for sharing the good news. Could you please mark the topic as resolved by marking the post which helped you to identify the root cause and helped in issue resolution?

It is the best way to thank the contributor for sharing his/her time and it will help other Talend community members during their future reference.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂