0

I'm facing an issue with a Pentaho Server job that executes a Python script (Automacao_latromi_relatoriobi_inbound_V4.py). The job fails with a "No such file or directory" error when attempting to access an Excel file located on a network drive. This problem occurs only when the job is executed on the Pentaho Server; the script runs successfully on my local machine and directly within PDI Spoon.

I've tried various ways to specify the directory paths to ensure they're correct and accessible, but the problem persists exclusively in the Pentaho Server environment.

Error Log:

2024-02-22 11:33:34,339 INFO [org.pentaho.di] 2024/02/22 11:33:34 - Automacao_latromi_relatoriobi_inbound_V4.py - (stdout) importando dados 2024-02-22 11:33:34,339 ERROR [org.pentaho.di] 2024/02/22 11:33:34 - Automacao_latromi_relatoriobi_inbound_V4.py - ERROR : (stderr) File "D:\KN_BI_MASTER\Pentaho_pipelines_e_scripts\1. Latromi\1. Check in Inbound\1. Scripts\Automacao_latromi_relatoriobi_inbound_V4.py", line 150, in 2024-02-22 11:33:34,339 INFO [org.pentaho.di] 2024/02/22 11:33:34 - Automacao_latromi_relatoriobi_inbound_V4.py - (stdout) Falha na tentativa 1: [Errno 2] No such file or directory: 'H:\POWER_BI.sao\Bases_Shein\Latromi/Relatório Janelas e Apontamentos - YMS Shein.xlsx'

Path Variations Tried:

r'H:\POWER_BI.sao\Bases_Shein\Latromi\Relatório Janelas e Apontamentos - YMS Shein.xlsx' 'H:\POWER_BI.sao\Bases_Shein\Latromi\Relatório Janelas e Apontamentos - YMS Shein.xlsx' 'H:/POWER_BI.sao/Bases_Shein/Latromi/Relatório Janelas e Apontamentos - YMS Shein.xlsx' 'H://POWER_BI.sao//Bases_Shein//Latromi//Relatório Janelas e Apontamentos - YMS Shein.xlsx' r'H://POWER_BI.sao//Bases_Shein//Latromi//Relatório Janelas e Apontamentos - YMS Shein.xlsx' Despite these variations, the error persists when the job is run on the Pentaho Server.

Troubleshooting Steps Taken:

Confirmed the network path and file accessibility; the file is accessible from my machine, and the path is correct. Successfully ran the script on my local machine and through PDI Spoon. Checked network permissions; the Pentaho Server should have access to the network drive. I suspect the issue might relate to how Pentaho Server handles network paths or permissions, but I'm unsure how to proceed to resolve this. Has anyone encountered a similar issue or can provide guidance on troubleshooting this further in the Pentaho Server environment?

Any insights or suggestions would be greatly appreciated.

Thank you.

Improve this question
3
  • Normally the designation from H:/ to a specific server location is maintained on your local machine. Unless this is maintained exactly the same on the server running pentaho this will indeed be your problem. Seeing how most pentaho servers are running on linux i'm pretty sure it is. Instead of using a drive designation use the correct (full) server address Commented Feb 26, 2024 at 11:45
  • You are referring to the UNC path, i already tried to use it but i also received the same error message Commented Mar 1, 2024 at 18:28
  • Might be a dumb question but, It runs in your machine which is mapped to H: ... Server is in another machine correct ? What driver is this folder mapped to in the server ? C: ? D: ? It has to be relative to the server to run correctly. Commented Apr 9, 2024 at 13:32
Related questions
2
Where do I upload p12 file received from Google Analytics to Pentaho Server?
2
Error on opening any Kettle Transformation file in Pentaho Data Integration
0
Pentaho job is not executing by running batch file
Load 4 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.