Pentaho

 View Only

  • 1.  Unable to run job from jenkins,

    Posted 01-21-2023 02:36

    When I have executed Pentaho Job/Transformation from PDI then it's working fine , Even When I executer from windows command line still it's executer . But when I have run same command from Jenkins scheduling then it thrown an error as ---

     Command which I have executed :

    E://data-integration/Kitchen.bat /rep:"<repository_name>" /dir:"<directory path>" /job:"AMR_Data"

    Nov 23, 2022 11:55:07 AM org.apache.karaf.main.Main$KarafLockCallback lockAquired
INFO: Lock acquired. Setting startlevel to 100
2022/11/23 11:55:08 - Kitchen - Start of run.
java.lang.NullPointerException
	at org.pentaho.di.core.plugins.PluginRegistry.getPluginId(PluginRegistry.java:689)
	at org.pentaho.di.core.plugins.PluginRegistry.getPlugin(PluginRegistry.java:715)
	at org.pentaho.di.core.plugins.PluginRegistry.loadClass(PluginRegistry.java:370)
	at org.pentaho.di.base.AbstractBaseCommandExecutor.establishRepositoryConnection(AbstractBaseCommandExecutor.java:195)
	at org.pentaho.di.kitchen.KitchenCommandExecutor.execute(KitchenCommandExecutor.java:115)
	at org.pentaho.di.kitchen.Kitchen.main(Kitchen.java:286)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
Build step 'Execute Windows batch command' marked build as failure
Finished: FAILURE

     Additional information:

    Environment variables which I have SET:



    ------------------------------
    Nikhil Shete
    IT Support Manager
    sansys
    ------------------------------


  • 2.  RE: Unable to run job from jenkins,

    Posted 01-21-2023 06:09

    One point I have observed that , I think jenkins not able to get .kettle directory path where

    repositories.xml
    kettle.properties

    shared.xml file are there.



    ------------------------------
    Nikhil Shete
    IT Support Manager
    sansys
    ------------------------------

    Original Message


  • 3.  RE: Unable to run job from jenkins,

    Posted 01-22-2023 17:43
    If the Jenkins is not running under your username then it won't be able to find your plugins directory.    In addition the KETTLE_HOME may not be set.   Try copying the necessary files out to a folder that Jenkins can reach and also set the KETTLE_HOME var to this directory in the Kitchen.bat file

    ------------------------------
    Andrew Cave
    Systems Engineer
    BizCubed Pty Ltd
    Australia
    ------------------------------

    Original Message


  • 4.  RE: Unable to run job from jenkins,

    Posted 01-23-2023 09:03
    Hi,

    I think you are facing an user permissions problem. Most probably you are running Spoon with your user and Jenkins is being run as a different user. eg: Administrator, NT AUTHORITY\SYSTEM, etc

    check that jenkins user can read the different files: jobs, transformations, .kettle (folder)

    Hope it helps

    Best regards

    ------------------------------
    Juan Sierra Pons
    Systems Engineer
    Juan Sierra Pons
    ------------------------------

    Original Message


  • 5.  RE: Unable to run job from jenkins,

    Posted 02-06-2023 13:50

    I have reinstalled jenkins & while installation, I have put same credentials of user details with which we have installed pentaho .

    Still It showing same error.



    ------------------------------
    Nikhil Shete
    IT Support Manager
    sansys
    ------------------------------

    Original Message


Related Content