Pentaho

 View Only

 Sending XML job to Carte

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Data Conversion's profile image
Data Conversion posted 04-17-2018 08:12

Hi,

I am following the documentation supplied here to try and send the Job XML to Carte. I am calling the registerJob endpoint but the documentation describes the body as a job_configuration, which is a job_execution_configuration and the job wrapped in the job_configuration node. I can't find any documentation anywhere as how to generate this xml. Can someone please tell the steps in doing this or point me in the right direction.

Thanks,

Phil


#Pentaho
#PentahoDataIntegrationPDI
#Kettle
Data Conversion's profile image
Data Conversion

From an old post on the old forum:

<job_configuration>

<job>

<!--- Your job XML -->

</job>

<job_execution_configuration>

<log_level>BASIC</log_level>

<safe_mode>N</safe_mode>

<!---- Other execution details like parameters, arguments, ... -->

</job_execution_configuration>

</job_configuration>

Edward Nickel's profile image
Edward Nickel

If I do it like that (that means inside <job> tags is content of KJB file) then I get Job 'null' was added to the list with id and NullPointerException is shown in Carte without Configuration details.

When I add content of KJB file instead of <job> tags then I get Job 'myJob' was added to the list with id but NullPointerException is still shown in Carte even though there are Configuration details.

Viktoriia Kakhniy's profile image
Viktoriia Kakhniy

Hi @Edward Nickel​ did you manage to solve this problem?

Viktoriia Kakhniy's profile image
Viktoriia Kakhniy

@Data Conversion​  I've tried to register job with both /kettle/addJob and /kettle/registerJob and got java.lang.NullPointerException in both cases.

After that my job was in Waiting status and I got next errors when trying to run it

2020/01/27 09:09:22 - J00_Main_Load_Patients_Data_test - Start of job execution2020/01/27 09:09:22 - J00_Main_Load_Patients_Data_test - Starting entry [T0_generate_transformation_GUID]2020/01/27 09:09:22 - T0_generate_transformation_GUID - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : Unable to run job J00_Main_Load_Patients_Data_test. The T0_generate_transformation_GUID has an error. The transformation path ${Internal.Entry.Current.Directory}/T0_generate_transformation_GUID.ktr is invalid, and will not run successfully.2020/01/27 09:09:22 - T0_generate_transformation_GUID - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : org.pentaho.di.core.exception.KettleXMLException: 2020/01/27 09:09:22 - T0_generate_transformation_GUID - The transformation path ${Internal.Entry.Current.Directory}/T0_generate_transformation_GUID.ktr is invalid, and will not run successfully.2020/01/27 09:09:22 - T0_generate_transformation_GUID - 2020/01/27 09:09:22 - T0_generate_transformation_GUID - at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2788)2020/01/27 09:09:22 - T0_generate_transformation_GUID - at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1311)2020/01/27 09:09:22 - T0_generate_transformation_GUID - at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:709)2020/01/27 09:09:22 - T0_generate_transformation_GUID - at org.pentaho.di.job.Job.execute(Job.java:686)2020/01/27 09:09:22 - T0_generate_transformation_GUID - at org.pentaho.di.job.Job.execute(Job.java:827)2020/01/27 09:09:22 - T0_generate_transformation_GUID - at org.pentaho.di.job.Job.execute(Job.java:498)2020/01/27 09:09:22 - T0_generate_transformation_GUID - at org.pentaho.di.job.Job.run(Job.java:384)2020/01/27 09:09:22 - J00_Main_Load_Patients_Data_test - Finished job entry [T0_generate_transformation_GUID] (result=[false])2020/01/27 09:09:22 - J00_Main_Load_Patients_Data_test - Job execution finished