topic Jobs are not executing through Talend Management console in Talend Studio

Jobs are not executing through Talend Management console

sushantk19 — Sat, 16 Nov 2024 01:55:33 GMT

Hi,

I published a couple of jobs from Talend Studio to Talend Management console( TMC) tool. i tried scheduling and running one job and ran the other one manually. Both are failing due to below error. This is first time I am running the job though TMC. Can you please let me know what could be the issue:

Exception in component tDBInput_1 (job_DM_000_Calendar) java.io.FileNotFoundException: C:/Users/XXX/Downloads/TOS_DI-20190620_1446-V7.2.1/TOS_DI-20190620_1446-V7.2.1/workspace/Talend.log (No such file or directory) at org.talend.ipaas.rt.flow.controller.impl.JobControllerImpl.doRun(JobControllerImpl.java:98)

ask 5f08836e127f9e350e72f81a/2.3 failed unexpectedly.org.talend.ipaas.rt.flow.controller.impl.FlowExecutionException: Step cf22a442-5917-4f84-b82e-e72426248b75 failed with code -1 and error Job stopped with errors or unable to run. Exception in component tDBOutput_1 (job_Staging_000_Currency) java.sql.SQLException: [Amazon](100021) Error setting default driver property values. at org.talend.ipaas.rt.flow.controller.impl.JobControllerImpl.doRun(JobControllerImpl.java:98) ~[?:?]

Re: Jobs are not executing through Talend Management console

David_Beaty — Mon, 13 Jul 2020 07:39:22 GMT

Hi,

Can you share the job design having the problem, especially around the tDBOutput_1 component, and its properties.

Re: Jobs are not executing through Talend Management console

JohnRMK — Mon, 13 Jul 2020 09:13:47 GMT

Hello,

It's completely normal to have this error.

You are trying to access a resource (file C: /Users/XXX/Downloads/TOS_DI-20190620_1446-V7.2.1/TOS_DI-20190620_1446-V7.2.1/workspace/Talend.log) while your job is running in the cloud somewhere in the usa!

So to remove this error you must install a remote engine in the machine where your files are stored and choose the execution in this engine there and not in the cloud.

Re: Jobs are not executing through Talend Management console

sushantk19 — Mon, 13 Jul 2020 11:47:02 GMT

please find the job design attached.

please note-This job works perfectly fine when we run it manually.

Re: Jobs are not executing through Talend Management console

sushantk19 — Mon, 13 Jul 2020 11:47:18 GMT

another screenshot