Pentaho

 View Only
  • 1.  Unable to run job from jenkins,

    Posted 17 days ago

    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 17 days ago

    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
    ------------------------------



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

    Posted 15 days ago
    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
    ------------------------------



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

    Posted 15 days ago
    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
    ------------------------------



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

    Posted yesterday

    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
    ------------------------------