Pentaho

 View Only

  • 1.  Error loading job from custom schedular

    Posted 12-05-2023 07:20

    Hello Team,

    We are unable to call the job/ repository from the custom java based schedular,

    basically, that schedular is calling the Pentaho jobs, but after 3s the jobs are failing.

    This is the error log which i am getting,

    2023/11/21 05:02:22 - Kitchen - Logging is at level : Basic
    2023/11/21 05:02:22 - Kitchen - Start of run.
    2023/11/21 05:02:22 - RepositoriesMeta - Reading repositories XML file: /home/oracle/.kettle/repositories.xml
    Processing stopped because of an error: 
    An error occured loading the directory tree from the repository
     
    Error loading a repository directory
     
    ERROR executing query
     at org.pentaho.commons.launcher.Launcher.main (Launcher.java:92)
     at java.lang.reflect.Method.invoke (Method.java:498)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)
     at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62)
     at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2)
     at org.pentaho.di.kitchen.Kitchen.main (Kitchen.java:290)
     at org.pentaho.di.kitchen.KitchenCommandExecutor.execute (KitchenCommandExecutor.java:135)
     at org.pentaho.di.kitchen.KitchenCommandExecutor.loadJobFromRepository (KitchenCommandExecutor.java:299)
     at org.pentaho.di.base.AbstractBaseCommandExecutor.loadRepositoryDirectory (AbstractBaseCommandExecutor.java:179)
     at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadRepositoryDirectoryTree (KettleDatabaseRepository.java:608)
     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectoryTree (KettleDatabaseRepositoryDirectoryDelegate.java:101)
     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectory (KettleDatabaseRepositoryDirectoryDelegate.java:129)
     at org.pentaho.di.repository.kdr.KettleDatabaseRepository.getSubDirectoryIDs (KettleDatabaseRepository.java:684)
     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.getSubDirectoryIDs (KettleDatabaseRepositoryDirectoryDelegate.java:290)
     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getIDs (KettleDatabaseRepositoryConnectionDelegate.java:1624)
     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.callRead (KettleDatabaseRepositoryConnectionDelegate.java:2025)
     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate$6.call (KettleDatabaseRepositoryConnectionDelegate.java:1624)
     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate$6.call (KettleDatabaseRepositoryConnectionDelegate.java:1626)
     at org.pentaho.di.core.database.Database.openQuery (Database.java:1833)
     at org.pentaho.di.core.database.Database.getRowInfo (Database.java:2608)
     at org.pentaho.di.core.database.Database.getValueFromSQLType (Database.java:2645)
     at java.util.ArrayList$Itr.next (ArrayList.java:861)
     at java.util.ArrayList$Itr.checkForComodification (ArrayList.java:911)
     
     
     
    ERROR: Kitchen can't continue because the job couldn't be loaded.
     
    -20050: ORA-20050: ORA-20061: 
    nullORA-06512: at "DBADMIN.APP_PENTAHO", line 335
    ORA-06512: at "DBADMIN.APP_PENTAHO", line 375


    ------------------------------
    Others
    esspl
    ------------------------------


  • 2.  RE: Error loading job from custom schedular

    Posted 12-13-2023 05:40

    adding detailed log -

    \

    2023/12/13 10:17:22 - Kitchen - Logging is at level : Detailed
    2023/12/13 10:17:22 - Kitchen - Start of run.
    2023/12/13 10:17:22 - RepositoriesMeta - No repositories file found in the local directory: /oracle/ora19c/oracle/product/19.3.0/db_home1/dbs/repositories.xml
    2023/12/13 10:17:22 - RepositoriesMeta - Reading repositories XML file: /home/oracle/.kettle/repositories.xml
    Processing stopped because of an error:
    An error occured loading the directory tree from the repository

    Error loading a repository directory

    Error loading a repository directory

    ERROR executing query
    at org.pentaho.commons.launcher.Launcher.main (Launcher.java:92)
    at java.lang.reflect.Method.invoke (Method.java:498)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)
    at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62)
    at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2)
    at org.pentaho.di.kitchen.Kitchen.main (Kitchen.java:290)
    at org.pentaho.di.kitchen.KitchenCommandExecutor.execute (KitchenCommandExecutor.java:135)
    at org.pentaho.di.kitchen.KitchenCommandExecutor.loadJobFromRepository (KitchenCommandExecutor.java:299)
    at org.pentaho.di.base.AbstractBaseCommandExecutor.loadRepositoryDirectory (AbstractBaseCommandExecutor.java:179)
    at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadRepositoryDirectoryTree (KettleDatabaseRepository.java:608)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectoryTree (KettleDatabaseRepositoryDirectoryDelegate.java:101)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectory (KettleDatabaseRepositoryDirectoryDelegate.java:132)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectory (KettleDatabaseRepositoryDirectoryDelegate.java:119)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.getDirectory (KettleDatabaseRepositoryDirectoryDelegate.java:48)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getOneRow (KettleDatabaseRepositoryConnectionDelegate.java:1871)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.callRead (KettleDatabaseRepositoryConnectionDelegate.java:2025)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate$8.call (KettleDatabaseRepositoryConnectionDelegate.java:1871)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate$8.call (KettleDatabaseRepositoryConnectionDelegate.java:1874)
    at org.pentaho.di.core.database.Database.openQuery (Database.java:1833)
    at org.pentaho.di.core.database.Database.getRowInfo (Database.java:2608)
    at org.pentaho.di.core.database.Database.getValueFromSQLType (Database.java:2645)
    at java.util.ArrayList$Itr.next (ArrayList.java:861)
    at java.util.ArrayList$Itr.checkForComodification (ArrayList.java:911)




    ERROR: Kitchen can't continue because the job couldn't be loaded.

    -20050: ORA-20050: ORA-20061:
    nullORA-06512: at "DBADMIN.APP_PENTAHO", line 335
    ORA-06512: at "DBADMIN.APP_PENTAHO", line 375



    ------------------------------
    Others
    esspl
    ------------------------------

    Original Message


  • 3.  RE: Error loading job from custom schedular

    Posted 12-13-2023 08:32

    Hi,

    IMHO this is concurrent modification of static field valueMetaPluginClasses in class Database. This is a bug. Error depends on HW configuration. I got this on 1 or 2 installations.



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------

    Original Message


  • 4.  RE: Error loading job from custom schedular

    Posted 12-14-2023 04:02

    Hi,

    Thank you for replying Petr Prochazka,

    So, What is the solution for this bug?

    And, Which HW configuration you are referring to?

    Can you please help us with these two questions.



    ------------------------------
    Others
    esspl
    ------------------------------

    Original Message


  • 5.  RE: Error loading job from custom schedular

    Posted 12-22-2023 07:32

    I have own bug fix in my branch, see this commit. So you can cherry pick this commit a build your own kettle-core.jar file.

    We have about 10 installations. The most of installation are virtual servers, some are dedicated servers. And 1 installation on Hyper-V had problem. IMHO it's depend on used real CPU and virtualisation platform.



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------

    Original Message


Related Content