Pentaho

 View Only
  • 1.  Problem after migrating to pentaho-server 9.3.0.0-428 - database type with plugin id [] couldn't be found!

    Posted 06-02-2022 10:38
    I hope this message find you all well.

    After migrating from pentaho-server-8.0.0.0.28 to pentaho-server-9.3.0.0-428_99 (using import-export tool) when i try to run transformations from the Pentaho User Console (PUC), even those transformations without database integration, i get the following exception:

    11:21:11,712 INFO [di] 2022/06/02 11:21:11 - RepositoriesMeta - Reading repositories XML file: FromInputStream
    2022/06/02 11:21:11 - RepositoriesMeta - Reading repositories XML file: FromInputStream
    11:29:12,083 ERROR [di] 2022/06/02 11:29:12 - PurRepository - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Unable to load shared objects
    2022/06/02 11:29:12 - PurRepository - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Unable to load shared objects
    11:29:12,086 ERROR [di] 2022/06/02 11:29:12 - PurRepository - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : java.lang.RuntimeException: Database type [] not found!
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:662)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.dataNodeToElement(DatabaseDelegate.java:156)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.dataNodeToElement(DatabaseDelegate.java:149)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.assemble(DatabaseDelegate.java:221)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.assemble(DatabaseDelegate.java:39)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.readSharedObjects(PurRepository.java:1444)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.loadAndCacheSharedObjects(PurRepository.java:1970)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.readTransSharedObjects(PurRepository.java:2043)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.buildTransMeta(PurRepository.java:2509)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.loadTransformation(PurRepository.java:2486)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.EngineMetaLoader.load(EngineMetaLoader.java:85)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.EngineMetaLoader.loadTransMeta(EngineMetaLoader.java:50)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.PdiAction.createTransMeta(PdiAction.java:307)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.PdiAction.execute(PdiAction.java:257)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.callImpl(ActionRunner.java:176)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:80)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:56)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:177)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:166)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeActionImpl(DefaultActionInvoker.java:166)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeAction(DefaultActionInvoker.java:110)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:178)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:79)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:61)
    2022/06/02 11:29:12 - PurRepository - at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    2022/06/02 11:29:12 - PurRepository - at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
    2022/06/02 11:29:12 - PurRepository - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    2022/06/02 11:29:12 - PurRepository - database type with plugin id [] couldn't be found!
    2022/06/02 11:29:12 - PurRepository -
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.findDatabaseInterface(DatabaseMeta.java:592)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.getDatabaseInterface(DatabaseMeta.java:566)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:660)
    2022/06/02 11:29:12 - PurRepository - ... 25 more
    2022/06/02 11:29:12 - PurRepository - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : java.lang.RuntimeException: Database type [] not found!
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:662)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.dataNodeToElement(DatabaseDelegate.java:156)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.dataNodeToElement(DatabaseDelegate.java:149)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.assemble(DatabaseDelegate.java:221)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.assemble(DatabaseDelegate.java:39)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.readSharedObjects(PurRepository.java:1444)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.loadAndCacheSharedObjects(PurRepository.java:1970)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.readTransSharedObjects(PurRepository.java:2043)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.buildTransMeta(PurRepository.java:2509)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.loadTransformation(PurRepository.java:2486)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.EngineMetaLoader.load(EngineMetaLoader.java:85)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.EngineMetaLoader.loadTransMeta(EngineMetaLoader.java:50)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.PdiAction.createTransMeta(PdiAction.java:307)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.PdiAction.execute(PdiAction.java:257)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.callImpl(ActionRunner.java:176)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:80)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:56)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:177)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:166)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeActionImpl(DefaultActionInvoker.java:166)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeAction(DefaultActionInvoker.java:110)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:178)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:79)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:61)
    2022/06/02 11:29:12 - PurRepository - at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    2022/06/02 11:29:12 - PurRepository - at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
    2022/06/02 11:29:12 - PurRepository - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    2022/06/02 11:29:12 - PurRepository - database type with plugin id [] couldn't be found!
    2022/06/02 11:29:12 - PurRepository -
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.findDatabaseInterface(DatabaseMeta.java:592)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.getDatabaseInterface(DatabaseMeta.java:566)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:660)
    2022/06/02 11:29:12 - PurRepository - ... 25 more
    11:29:12,119 ERROR [di] 2022/06/02 11:29:12 - PurRepository - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Unable to load shared objects
    2022/06/02 11:29:12 - PurRepository - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Unable to load shared objects
    11:29:12,126 ERROR [di] 2022/06/02 11:29:12 - PurRepository - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : java.lang.RuntimeException: Database type [] not found!
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:662)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.dataNodeToElement(DatabaseDelegate.java:156)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.dataNodeToElement(DatabaseDelegate.java:149)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.assemble(DatabaseDelegate.java:221)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.assemble(DatabaseDelegate.java:39)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.readSharedObjects(PurRepository.java:1444)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.loadAndCacheSharedObjects(PurRepository.java:1970)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.readTransSharedObjects(PurRepository.java:2043)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.buildTransMeta(PurRepository.java:2509)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.loadTransformation(PurRepository.java:2486)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.EngineMetaLoader.load(EngineMetaLoader.java:85)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.EngineMetaLoader.loadTransMeta(EngineMetaLoader.java:50)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.PdiAction.createTransMeta(PdiAction.java:307)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.PdiAction.execute(PdiAction.java:257)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.callImpl(ActionRunner.java:176)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:80)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:56)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:177)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:166)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeActionImpl(DefaultActionInvoker.java:166)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeAction(DefaultActionInvoker.java:110)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:178)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:79)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:61)
    2022/06/02 11:29:12 - PurRepository - at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    2022/06/02 11:29:12 - PurRepository - at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
    2022/06/02 11:29:12 - PurRepository - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    2022/06/02 11:29:12 - PurRepository - database type with plugin id [] couldn't be found!
    2022/06/02 11:29:12 - PurRepository -
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.findDatabaseInterface(DatabaseMeta.java:592)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.getDatabaseInterface(DatabaseMeta.java:566)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:660)
    2022/06/02 11:29:12 - PurRepository - ... 25 more
    2022/06/02 11:29:12 - PurRepository - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : java.lang.RuntimeException: Database type [] not found!
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:662)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.dataNodeToElement(DatabaseDelegate.java:156)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.dataNodeToElement(DatabaseDelegate.java:149)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.assemble(DatabaseDelegate.java:221)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.DatabaseDelegate.assemble(DatabaseDelegate.java:39)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.readSharedObjects(PurRepository.java:1444)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.loadAndCacheSharedObjects(PurRepository.java:1970)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.readTransSharedObjects(PurRepository.java:2043)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.buildTransMeta(PurRepository.java:2509)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.repository.pur.PurRepository.loadTransformation(PurRepository.java:2486)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.EngineMetaLoader.load(EngineMetaLoader.java:85)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.EngineMetaLoader.loadTransMeta(EngineMetaLoader.java:50)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.PdiAction.createTransMeta(PdiAction.java:307)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.plugin.kettle.PdiAction.execute(PdiAction.java:257)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.callImpl(ActionRunner.java:176)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:80)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:56)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:177)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:166)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeActionImpl(DefaultActionInvoker.java:166)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeAction(DefaultActionInvoker.java:110)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:178)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:79)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:61)
    2022/06/02 11:29:12 - PurRepository - at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    2022/06/02 11:29:12 - PurRepository - at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
    2022/06/02 11:29:12 - PurRepository - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    2022/06/02 11:29:12 - PurRepository - database type with plugin id [] couldn't be found!
    2022/06/02 11:29:12 - PurRepository -
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.findDatabaseInterface(DatabaseMeta.java:592)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.getDatabaseInterface(DatabaseMeta.java:566)
    2022/06/02 11:29:12 - PurRepository - at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:660)


    Any hints as to where should i be looking to find the cause of this error? It seems to me that this error is related to the Kettle Core, as it arises even with a simple transformation without database integration.

    Any help would be much appreciated.


  • 2.  RE: Problem after migrating to pentaho-server 9.3.0.0-428 - database type with plugin id [] couldn't be found!

    Posted 06-02-2022 19:00
    Hi Erick

    If you're on Enterprise Edition you can raise a support ticket with Pentaho Support.  If you are on CE you probably shouldn't use import-export.

    The problem looks to be related to kettle trying to connect to the repository but the database type to use has gone missing.   Did  you change database types for the repository?

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



  • 3.  RE: Problem after migrating to pentaho-server 9.3.0.0-428 - database type with plugin id [] couldn't be found!

    Posted 06-02-2022 22:07
    Hi Andrew, i really appreciate your reply.

    I'm currently using the Pentaho CE server.

    After thoroughly  investigation i noticed two datasources (in the manage datasource menu option in PUC) that didn't have any database type set. It's weird that those datasources don't show in the PDI. And also these entries are not exported when i click export repository in PDI. After deleting these two datasources, the error message disappears. One of these two datasources was named "PROXY CACHE".

    If you don't mind me asking, why do you say i shouldn't be using the import-export tool? Apart from the problem above, everything else seems to be working fine.

    ------------------------------
    Erick Barreto
    IT Support Manager
    SIS
    ------------------------------



  • 4.  RE: Problem after migrating to pentaho-server 9.3.0.0-428 - database type with plugin id [] couldn't be found!

    Posted 06-03-2022 01:00
    Never mind, I was confusing it with  the upgrade utility.   Import-export should be fine. Glad I was able to help

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