Call Python Script in Talend Management Console

[rajesh90]

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

[Anonymous]

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

[vikramk]

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.

[premv258]

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

 

[Anonymous]

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.

[Talend_user123456787654]

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.

[Anonymous]

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

[Talend_user123456787654]

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?

[Anonymous]

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