Pentaho

 View Only

 Help to set up first scheduled process job

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
LEONARDO BUSOLO's profile image
LEONARDO BUSOLO posted 03-08-2021 17:07

Good afternoon folks, I need some help to build a transformation process where it is working perfectly when executed directly from the PDI, later I created a job (job_veiculos.kjb) referencing this ETL that also works perfectly, now I am trying to generate a .bat to run automatically, however there is an error attached.

 


#PentahoDataIntegrationPDI
#Kettle
#Pentaho
Ana Gonzalez's profile image
Ana Gonzalez

I don't see any error in your log file

LEONARDO BUSOLO's profile image
LEONARDO BUSOLO

It happens that the routine is not executing the data processing, when starting job_veiculos execution and the cleanUpdate transformation starts, it is not carried out and ended with a result = false immediately, after that there is another update transformation that is not even executed.

Ana Gonzalez's profile image
Ana Gonzalez

Maybe increasing the log lever when running the job will provide more information, I don't see anything wrong there.

LEONARDO BUSOLO's profile image
LEONARDO BUSOLO

First of all thanks for the help, I set the log to / level: Detailed follows the generated log apparently has something with the directory

LEONARDO BUSOLO's profile image
LEONARDO BUSOLO

I did it, thank you very much. problem was in the non-declaration of $ {Internal.Entry.Current.Directory}