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
------------------------------
Original Message:
Sent: 06-02-2022 19:00
From: Andrew Cave
Subject: Problem after migrating to pentaho-server 9.3.0.0-428 - database type with plugin id [] couldn't be found!
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
Original Message:
Sent: 06-02-2022 10:37
From: Erick Barreto
Subject: Problem after migrating to pentaho-server 9.3.0.0-428 - database type with plugin id [] couldn't be found!
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.