Pentaho

 View Only

 Errors when running job via API

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Viktoriia Kakhniy's profile image
Viktoriia Kakhniy posted 01-21-2020 11:41

Problem description:

I have a problem with running job via API. I have one main job (.kjb file) and some transformations (.ktr files) and sub-jobs, that are called from main one. When running main job, transformation, that is called from it cannot be found.

Steps:

  1. POST

/pentaho/kettle/startJob

response

2. Check job logs on /pentaho/kettle/status

Actual Result:

See jobLogs.txt

Expected Result:

Job should run successfully

 

Notes:

The same problem when running job via /kettle/runJob


#PentahoDataIntegrationPDI
#Kettle
#Pentaho
Sergio Ribeiro's profile image
Sergio Ribeiro

Hello @Viktoriia Kakhniy​,

 

A few questions:

  • If you try to run that job on Spoon, does it work correctly?
  • In your "Set Properties" step, how are you referring to the "T_Set_Properties" transformation?
  • Does the transformation exist on the referred path ("/public/appointments")?
  • Are job(s) and transformation(s) in the same folder?

 

Regards,

 

Sérgio Ribeiro

Porto - Portugal

Viktoriia Kakhniy's profile image
Viktoriia Kakhniy

Hi @Sergio Ribeiro​ 

 

Thank you for quick response.😊

We have managed to fix a problem after changes in repository configurations.

Sergio Ribeiro's profile image
Sergio Ribeiro

Good to know @Viktoriia Kakhniy​,

 

Is it possible for you to share what was done to fix it?

Someone else may encounter a similar error in the future and may try your solution.

 

Regards,

 

Sérgio Ribeiro

Porto - Portugal

 

 

Viktoriia Kakhniy's profile image
Viktoriia Kakhniy

Before changes

configurations

After changes

localhost -> concrete URL

Sergio Ribeiro's profile image
Sergio Ribeiro

Thank you @Viktoriia Kakhniy​.