unparsable date Error

[Anonymous]

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.

[Anonymous]

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."

[Anonymous]

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 🙂

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

@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 🙂