topic Re: Job won't run in Talend Studio

Job won't run

Anonymous — Sat, 16 Nov 2024 06:19:53 GMT

I have a job which takes a csv file from my local drive and imports it into Snowflake. I was testing it earlier today and it ran ok earlier. I have tried to run it several times since then but now it won't work. I don't get an error message. It just gets the first row from the csv file and then doesn't process any further. I've already rebooted my pc and tried again. Same results.

Re: Job won't run

navds — Thu, 14 Mar 2019 18:43:27 GMT

You should focus on the db server connectivity: do you have any other mean to check that the parameters are okay ? network problem ? etc

Re: Job won't run

Anonymous — Thu, 14 Mar 2019 18:52:54 GMT

As I said the file is a local file on my C drive. It reads the first row and then holds there. Doesn't process any further. I have a different job which takes data from SQL Server to the same snowflake db and that works fine.

Re: Job won't run

navds — Thu, 14 Mar 2019 18:57:34 GMT

Looking at the screenshot, one thing I am sure of is the problem is not on the input. To proceed by elimination, you could replace the tFileOutputDelimited at the reject flow by a tLogRow. Left the tDB* components

Re: Job won't run

Anonymous — Thu, 14 Mar 2019 19:13:47 GMT

I tried that and nothing changed. See attachment.

csv job process3.PNG

Re: Job won't run

Anonymous — Thu, 14 Mar 2019 19:13:48 GMT

I tried that and nothing changed. See attachment.

csv job process3.PNG
csv job process3.PNG

Re: Job won't run

Anonymous — Thu, 14 Mar 2019 19:16:11 GMT

I tried that. No change.

csv job process3.PNG

Re: Job won't run

nivedhitha — Fri, 15 Mar 2019 03:15:17 GMT

@gfred ,

Try adding tSchemaComplianceCheck component before the DBOutput component and map the rejects to tLogRow to see if its because of inappropriate schema the data is not inserted into target.

Re: Job won't run

Anonymous — Tue, 19 Mar 2019 13:41:09 GMT

It's working now. Apparently there was some issues with snowflake that were causing the issue.