Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Utility Automated with the help of java API for Kettle jobs

  1. #1
    Join Date
    Apr 2014
    Posts
    4

    Question Utility Automated with the help of java API for Kettle jobs

    Hi,

    I have a problem after we have automated our kettle jobs to run using Java API.

    The Kettle jobs are running successfully in eclipse but when i run the batch file using cmd it doesnot run. it throws the below error. can some one help me understand if i am missing something here to make them run using cmd

    Please note that the transformations are working fine using cmd prompt.

    This is a high priority task that needs to be done for our project and your insights would be greatly appreciated.

    Please find below the error description that we get while trying to run the jobs using cmd prompt.

    Please let us know if there is anything extra that needs to be done in order for the kettle jobs to be run using command line prompt.

    INFO 11-03 18:17:18,171 - Using "C:\Users\KATSA05\AppData\Local\Temp\vfs_cache" as temporary files store.
    Job Path: C:\UniversalETLService\universal_etl\etl_repo\DASHBOARD_DATA_LOAD\Dashboard_Data_Loading.kjb
    ERROR 11-03 18:17:18,685 - null.0 - Unable to read Job Entry copy info from XML node : org.pentaho.di.core.exception.KettleStepLoaderException:
    No valid step/plugin specified (jobPlugin=null) for TRANS

    ERROR 11-03 18:17:18,686 - null.0 - org.pentaho.di.core.exception.KettleStepLoaderException:
    No valid step/plugin specified (jobPlugin=null) for TRANS

    at org.pentaho.di.job.entry.JobEntryCopy.<init>(JobEntryCopy.java:110)
    at org.pentaho.di.job.JobMeta.loadXML(JobMeta.java:922)
    at org.pentaho.di.job.JobMeta.<init>(JobMeta.java:726)
    at org.pentaho.di.job.JobMeta.<init>(JobMeta.java:693)
    at com.ca.businessreporting.etl.Utils.executeJob(Utils.java:564)
    at com.ca.businessreporting.etl.UniversalETLService.executeJobs(UniversalETLService.java:428)
    at com.ca.businessreporting.etl.UniversalETLService.init(UniversalETLService.java:559)
    at com.ca.businessreporting.etl.UniversalETLService.main(UniversalETLService.java:579)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.simontuffs.onejar.Boot.run(Boot.java:342)
    at com.simontuffs.onejar.Boot.main(Boot.java:168)

    org.pentaho.di.core.exception.KettleXMLException:
    Unable to load the job from XML file [C:\UniversalETLService\universal_etl\etl_repo\DASHBOARD_DATA_LOAD\Dashboard_Data_Loading.kjb]

    Unable to load job info from XML node

    Unable to read Job Entry copy info from XML node : org.pentaho.di.core.exception.KettleStepLoaderException:
    No valid step/plugin specified (jobPlugin=null) for TRANS
    No valid step/plugin specified (jobPlugin=null) for TRANS

    at org.pentaho.di.job.JobMeta.<init>(JobMeta.java:734)
    at org.pentaho.di.job.JobMeta.<init>(JobMeta.java:693)
    at com.ca.businessreporting.etl.Utils.executeJob(Utils.java:564)
    at com.ca.businessreporting.etl.UniversalETLService.executeJobs(UniversalETLService.java:428)
    at com.ca.businessreporting.etl.UniversalETLService.init(UniversalETLService.java:559)
    at com.ca.businessreporting.etl.UniversalETLService.main(UniversalETLService.java:579)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.simontuffs.onejar.Boot.run(Boot.java:342)
    at com.simontuffs.onejar.Boot.main(Boot.java:168)
    Caused by: org.pentaho.di.core.exception.KettleXMLException:
    Unable to load job info from XML node

    Unable to read Job Entry copy info from XML node : org.pentaho.di.core.exception.KettleStepLoaderException:
    No valid step/plugin specified (jobPlugin=null) for TRANS

    No valid step/plugin specified (jobPlugin=null) for TRANS

    at org.pentaho.di.job.JobMeta.loadXML(JobMeta.java:968)
    at org.pentaho.di.job.JobMeta.<init>(JobMeta.java:726)
    ... 11 more
    Caused by: org.pentaho.di.core.exception.KettleXMLException:
    Unable to read Job Entry copy info from XML node : org.pentaho.di.core.exception.KettleStepLoaderException:
    No valid step/plugin specified (jobPlugin=null) for TRANS

    No valid step/plugin specified (jobPlugin=null) for TRANS

    at org.pentaho.di.job.entry.JobEntryCopy.<init>(JobEntryCopy.java:134)
    at org.pentaho.di.job.JobMeta.loadXML(JobMeta.java:922)
    ... 12 more
    Caused by: org.pentaho.di.core.exception.KettleStepLoaderException:
    No valid step/plugin specified (jobPlugin=null) for TRANS

    at org.pentaho.di.job.entry.JobEntryCopy.<init>(JobEntryCopy.java:110)
    ... 13 more



    Thanks,
    Vineela.

  2. #2
    Join Date
    Sep 2013
    Posts
    235

    Default

    Check your class-path, check how do you launch kettle jobs. Compare class-path that you have for eclipse and class-path that you have for your custom 'cmd' run.
    This error caused by missed Job entry plugin.
    Which one plugin is missed - It is some how related with magic word 'TRANS'.

    This is a link to master code base where is actually this exception is thrown.
    https://github.com/pentaho/pentaho-k...Copy.java#L133

    I don't know exact version of PDI api you are using. Hope it will help.

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Also make sure to run KettleEnvironment.init() to load all plugins.

    http://wiki.pentaho.com/display/EAI/...transformation

  4. #4
    Join Date
    Apr 2014
    Posts
    4

    Smile

    Thank you so much for your reply. Sorry for the delayed response.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.