topic Re: Using the tSystem component in Talend Studio

Using the tSystem component

Anonymous — Sat, 16 Nov 2024 06:20:16 GMT

Hi,

I m running my python script by using tSystem by help of python \"D:\\Talent-Two\\pdf.py this command

but after running job their was error :

Exception in component tSystem_1 (Conversion_of_files)
java.io.IOException: Cannot run program "python": CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessBuilder.start(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at talent_sample_one.conversion_of_files_0_1.Conversion_of_files.tSystem_1Process(Conversion_of_files.java:341)
at talent_sample_one.conversion_of_files_0_1.Conversion_of_files.runJobInTOS(Conversion_of_files.java:695)
at talent_sample_one.conversion_of_files_0_1.Conversion_of_files.main(Conversion_of_files.java:544)
Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessImpl.create(Native Method)

Re: Using the tSystem component

vapukov — Thu, 14 Mar 2019 13:07:08 GMT

first you need to check - is python available in your PATH variable

could you run python from windows command line console?

then you have 2 choices:

use full path for python
add path to python in global system path

keep also in mind in windows when you have folders with spaces in PATH, it could be not work in some cases (not sure is it affected there or not), but you could put path to python to first place

Re: Using the tSystem component

Anonymous — Fri, 15 Mar 2019 11:56:52 GMT

I have set path for python through environment variable..

their is another way to set path?

can u tell me?

Re: Using the tSystem component

vapukov — Fri, 15 Mar 2019 12:38:07 GMT

first - you could check, what PATH available for tSystem, with simple job:

you also could define path in tSystem self:

3rd - if you under windows do not use "cmd /c " for start shell, it also could return error similar for yours

Re: Using the tSystem component

Anonymous — Mon, 18 Mar 2019 05:16:31 GMT

i m using windows and i have wriiten python script path in single command as

"python \"D:\\Convert2.py" see in image file that i have send .

is it write?

or there is another way for defining path for script file..?

error.png

Re: Using the tSystem component

vapukov — Mon, 18 Mar 2019 05:40:43 GMT

You need add path to python!

“C:\\python36\\pyton c:\\somewhere\\somefile.py”

Re: Using the tSystem component

jagadish_dasari — Tue, 15 Sep 2020 08:05:53 GMT

Hi,

Try the below steps and see:

1. SET PYTHON IN ENVINRONMENT VARIABLE PATH:

Example: <existing path settings>;C:\PYTHON\PYTHON_385\python.exe

2. VERIFY IN A NEW CMD PROMPT (windows): use the command 'echo %PATH%'

Example: C:\PYTHON\PYTHON_385\python.exe - Is the executable file

Microsoft Windows [Version 6.3.9600]

C:\Users\jdasari>echo %PATH%

C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\W

t SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server

r\130\Tools\Binn\ManagementStudio\;C:\PYTHON\PYTHON_385

3. RE-START THE TALEND:

Talend Studio or server sources the PATH at the start-up only.

For these changes to reflect restart is mandatory.

4. tSystem PYTHON SCRIPT CALL:

"cmd /c python D:\\Python_Global\\Development_Reports_15SEP2020.py"

Hope this works fine!

Thanks,

Jagadish.