AnsweredAssumed Answered

How to run a Job using Kettle.bat file?

Question asked by maneesh m on Feb 22, 2019
Latest reply on Mar 7, 2019 by maneesh m

Hi,

I am using PDI 8.1.

I have a job with a few transformations. I am able to run it using Spoon.

 

But I would like to run it using Kettle.bat on a windows machine.

 

I have a powershell script as follows.

C:\IDEs\pdi-ce-8.1.0.0-365\data-integration\kitchen.bat /file="C:\Development\ETLs\FDCOI SolarWinds DCO\SolarWinds_To_DC.kjb"

 

I am seeing the following error.

Get Data From SolarWinds And Write To Csv - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : Unable to run job SolarWinds_To_DCO. The Get Data From

SolarWinds And Write To Csv has an error. No repository defined!

Get Data From SolarWinds And Write To Csv - Error opening/validating the XML file '//Get_Data_From_SolarWinds_And_Write_To_Csv.ktr'!

Get Data From SolarWinds And Write To Csv - Unable to get VFS File object for filename '//Get_Data_From_SolarWinds_And_Write_To_Csv.ktr' : Could not find file with URI

"\\Get_Data_From_SolarWinds_And_Write_To_Csv.ktr" because it is a relative path, and no base URI was provided.

Get Data From SolarWinds And Write To Csv - Could not find file with URI "\\Get_Data_From_SolarWinds_And_Write_To_Csv.ktr" because it is a relative path, and no base URI was provided.

Get Data From SolarWinds And Write To Csv - Could not find file with URI "\\Get_Data_From_SolarWinds_And_Write_To_Csv.ktr" because it is a relative path, and no base URI was provided.

Get Data From SolarWinds And Write To Csv - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : org.pentaho.di.core.exception.KettleException:

 

I also tried adding this to the powershell but did not work.

/rep="C:\Users\8061\.kettle\repositories.xml"

 

Is there some parameter I need to pass to Kettle so that it understands the relative paths?

Outcomes