I run the job associated in my pentaho data integration client in pentaho server and when i saw the log ressults of the job it says that the python librart ‘Pandas’ doesn’t exist on the server where the pentaho server runs…

Hello! I have a Pentaho PDI proyect uploaded in a Pentaho Server Suite so i can Schedule and run all of my PDI proyects…

Right now i have a proyect in PDI which flow start running a Shell object configurated with a Python Script where inside this script have the Pandas library and when i run the job on the Pentaho Server Suite give me the following log:

Job – Start of job execution
Job – Starting entry Shell 3
Shell 3 – Running on platform : Linux
Shell 3 – Executing command : /home/pentaho/pentaho-server/tomcat/temp/kettle_87037a5e-0e27-11ef-9789-f761d4300bd8shell
Job – Starting entry Shell
Shell – Running on platform : Linux
Shell – Executing command : /home/pentaho/pentaho-server/tomcat/temp/kettle_87857b9f-0e27-11ef-9789-f761d4300bd8shell
Shell – ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : (stderr) Traceback (most recent call last):
Shell – ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : (stderr) File “/home/pentaho/convertir_excel_a_csv.py”, line 1, in <module>
Shell – ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : (stderr) import pandas as pd
Shell – ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : (stderr) ModuleNotFoundError: No module named ‘pandas’
Job – Finished job entry Shell result= false

This is strange because in PDI when i run locally this proyect doesn’t give me the error but in Pentaho Server it does…

I try creating a virtual environment where i have the librarys installed but Pentaho Server didn’t run the virtual environment either…

I try to create a bash file where i have the python script or the call of the virtual environment and i don’t have success either…

I have installed the pandas library in the server and when i run it on the console level the scripts runs without a problem.