topic Re: Call Python Script in Talend Management Console in Talend Studio

Call Python Script in Talend Management Console

rajesh90 — Sat, 16 Nov 2024 01:05:58 GMT

Hello ,

While running Talend job in Talend Management console which is in turn calling a python script getting the below error,

Error :

tSystem_1 Cannot run program "python": CreateProcess error=2, The system cannot find the file specified java.io.IOException: Cannot run program "python": CreateProcess error=2, The system cannot find the file specified at java.lang.ProcessBuilder.start(ProcessBuilder.java:1048) at java.lang.Runtime.exec(Runtime.java:620)

The same job can be run in local using Talend Cloud Data Management Platform v7.2.

Please note that the python is installed in the server where the Talend Cloud management is installed as well.

Do I need to make any variable update or setting to make this work. Thanks in advance

Re: Call Python Script in Talend Management Console

Anonymous — Wed, 18 Nov 2020 05:18:03 GMT

Hello,

Does your tsystem component work as expected on Remote Engine server? We assume that the Remote Engine is probably running with a different (system) account, it seems that the Path variable is not correctly set.

Best regards

Sabrina

Re: Call Python Script in Talend Management Console

vikramk — Wed, 18 Nov 2020 05:48:17 GMT

Hi @Rajesh L R ,

Please check for the file path specified on remote engine, As it says system cant find the file at the given location.

Re: Call Python Script in Talend Management Console

premv258 — Thu, 05 Aug 2021 06:24:39 GMT

If you are able to execute on Talend open studio. You will have to make few changes to command before publishing it to TMC.

REMOVE: Remove below

"cmd"

"\c"

ADD: add below

"python"

Refer below screenshot for TMC

Re: Call Python Script in Talend Management Console

Anonymous — Fri, 06 Aug 2021 05:36:13 GMT

You may also have to provide the full path to python as it may not be able to find it in the $PATH depending on the user your remote engine is running under.

Re: Call Python Script in Talend Management Console

Talend_user123456787654 — Wed, 08 Dec 2021 17:17:44 GMT

Hello, Did you get a solution to the above issue. It happened to me as well. My Talend cloud studio in local system is able to execute python script through tsystem component. Also, my remote server has python installed which can be used to execute python scripts using CMD commands. But, when we are trying to execute through TMC, we are getting the same error as above developer got. Providing the full path of python.exe solves the issue but we do not want to provide the full path rather call the python script itself only. For Eg: python <script_path>

Please provide your insights on this. Thanks in advance.

Re: Call Python Script in Talend Management Console

Anonymous — Thu, 09 Dec 2021 03:18:29 GMT

Hello,

Was the job working fine when you start the Remote Engine manually via the start.bat script and run from TMC or Studio to RE? Or the issue was only showing up when RE was started as a Windows Service?

Here is a technical article about:

https://stackoverflow.com/questions/17349386/excel-automation-windows-service

Best regards

Sabrina

Re: Call Python Script in Talend Management Console

Talend_user123456787654 — Thu, 09 Dec 2021 03:24:17 GMT

The RE is started is started as a windows service and is running as services. Will starting the Remote engine manually via start.bat script help in resolution?

Re: Call Python Script in Talend Management Console

Anonymous — Thu, 09 Dec 2021 03:36:04 GMT

Hello,

When RE is started as a Windows Service it causes the job to break as there is a limitation from Windows side. It's not core functionality of the Talend product which is broken, but some specific issue with the environment on which it is being used.

Please try to start the Remote Engine manually via the start.bat script.

Best regards

Sabrina