java.lang.RuntimeException: Database type not found!

Pentaho BI Platform Tracking | Mike Johnson | 2 years ago
  1. 0

    Repro: Start biserver In the Dashboards folder of the solution browser, select Sales Analysis and open it. View the stack trace in the console window... 11:33:19,452 ERROR [SQLDialectFactory] SQLDialectFactory.ERROR_0001 - Error loading dialect. java.util.ServiceConfigurationError: org.pentaho.pms.mql.dialect.SQLDialectInterface: Provider org.pentaho.pms.mql.dialect.HiveDialect could not be instantiated: java.lang.RuntimeException: Database t ype not found! at java.util.ServiceLoader.fail(ServiceLoader.java:207) at java.util.ServiceLoader.access$100(ServiceLoader.java:164) at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:353) at java.util.ServiceLoader$1.next(ServiceLoader.java:421) at org.pentaho.pms.mql.dialect.SQLDialectFactory.loadDialectPlugins(SQLDialectFactory.java:76) at org.pentaho.pms.mql.dialect.SQLDialectFactory.<init>(SQLDialectFactory.java:49) at org.pentaho.pms.mql.dialect.SQLDialectFactory.<clinit>(SQLDialectFactory.java:37) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.<init>(SqlOpenFormula.java:142) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:420) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:369) at org.pentaho.platform.plugin.services.connections.metadata.sql.SqlMetadataQueryExec.executeQuery(SqlMetadataQueryExec.java:80) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:231) at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1293) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:202) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:189) at $Proxy25.execute(Unknown Source) at org.pentaho.platform.plugin.action.chartbeans.DefaultChartBeansGenerator.runActionSequence(DefaultChartBeansGenerator.java:230) at org.pentaho.platform.plugin.action.chartbeans.DefaultChartBeansGenerator.createAndRunActionSequence(DefaultChartBeansGenerator.java:189) at org.pentaho.platform.plugin.action.chartbeans.DefaultChartBeansGenerator.internalCreateChart(DefaultChartBeansGenerator.java:157) at org.pentaho.platform.plugin.action.chartbeans.DefaultChartBeansGenerator.createChartAsHtml(DefaultChartBeansGenerator.java:458) at org.pentaho.platform.plugin.action.chartbeans.ChartBeansGeneratorUtil.createChartAsHtml(ChartBeansGeneratorUtil.java:43) at org.pentaho.dashboards.content.DashboardRenderer.b(SourceFile:547) at org.pentaho.dashboards.content.DashboardRenderer.createContent(SourceFile:377) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: java.lang.RuntimeException: Database type not found! at org.pentaho.di.core.database.DatabaseMeta.setValues(DatabaseMeta.java:540) at org.pentaho.di.core.database.DatabaseMeta.<init>(DatabaseMeta.java:392) at org.pentaho.pms.mql.dialect.DefaultSQLDialect.<init>(DefaultSQLDialect.java:64) at org.pentaho.pms.mql.dialect.HiveDialect.<init>(SourceFile:63) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at java.lang.Class.newInstance0(Class.java:355) at java.lang.Class.newInstance(Class.java:308) at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:345) ... 103 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: database type with plugin id [HIVE] couldn't be found! at org.pentaho.di.core.database.DatabaseMeta.findDatabaseInterface(DatabaseMeta.java:485) at org.pentaho.di.core.database.DatabaseMeta.getDatabaseInterface(DatabaseMeta.java:461) at org.pentaho.di.core.database.DatabaseMeta.setValues(DatabaseMeta.java:536) ... 113 more 11:33:20,030 ERROR [SystemSettings] ::: SYSTEMSETTINGS.ERROR_0002 - File C:\Pentaho\Testing\3.7NIGHTLY\biserver-ee\pentaho-solutions\system\ee-chart-plugin\settings.xml does not exist 11:33:20,030 ERROR [SystemSettings] ::: SYSTEMSETTINGS.ERROR_0002 - File C:\Pentaho\Testing\3.7NIGHTLY\biserver-ee\pentaho-solutions\system\ee-chart-plugin\settings.xml does not exist 11:33:20,111 ERROR [SystemSettings] ::: SYSTEMSETTINGS.ERROR_0002 - File C:\Pentaho\Testing\3.7NIGHTLY\biserver-ee\pentaho-solutions\system\ee-chart-plugin\settings.xml does not exist 11:33:20,112 ERROR [SystemSettings] ::: SYSTEMSETTINGS.ERROR_0002 - File C:\Pentaho\Testing\3.7NIGHTLY\biserver-ee\pentaho-solutions\system\ee-chart-plugin\settings.xml does not exist

    Pentaho BI Platform Tracking | 6 years ago | Rob Fellows
    java.util.ServiceConfigurationError: org.pentaho.pms.mql.dialect.SQLDialectInterface: Provider org.pentaho.pms.mql.dialect.HiveDialect could not be instantiated: java.lang.RuntimeException: Database t ype not found!
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    Repro: Start biserver In the Dashboards folder of the solution browser, select Sales Analysis and open it. View the stack trace in the console window... 11:33:19,452 ERROR [SQLDialectFactory] SQLDialectFactory.ERROR_0001 - Error loading dialect. java.util.ServiceConfigurationError: org.pentaho.pms.mql.dialect.SQLDialectInterface: Provider org.pentaho.pms.mql.dialect.HiveDialect could not be instantiated: java.lang.RuntimeException: Database t ype not found! at java.util.ServiceLoader.fail(ServiceLoader.java:207) at java.util.ServiceLoader.access$100(ServiceLoader.java:164) at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:353) at java.util.ServiceLoader$1.next(ServiceLoader.java:421) at org.pentaho.pms.mql.dialect.SQLDialectFactory.loadDialectPlugins(SQLDialectFactory.java:76) at org.pentaho.pms.mql.dialect.SQLDialectFactory.<init>(SQLDialectFactory.java:49) at org.pentaho.pms.mql.dialect.SQLDialectFactory.<clinit>(SQLDialectFactory.java:37) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.<init>(SqlOpenFormula.java:142) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:420) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:369) at org.pentaho.platform.plugin.services.connections.metadata.sql.SqlMetadataQueryExec.executeQuery(SqlMetadataQueryExec.java:80) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:231) at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1293) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:202) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:189) at $Proxy25.execute(Unknown Source) at org.pentaho.platform.plugin.action.chartbeans.DefaultChartBeansGenerator.runActionSequence(DefaultChartBeansGenerator.java:230) at org.pentaho.platform.plugin.action.chartbeans.DefaultChartBeansGenerator.createAndRunActionSequence(DefaultChartBeansGenerator.java:189) at org.pentaho.platform.plugin.action.chartbeans.DefaultChartBeansGenerator.internalCreateChart(DefaultChartBeansGenerator.java:157) at org.pentaho.platform.plugin.action.chartbeans.DefaultChartBeansGenerator.createChartAsHtml(DefaultChartBeansGenerator.java:458) at org.pentaho.platform.plugin.action.chartbeans.ChartBeansGeneratorUtil.createChartAsHtml(ChartBeansGeneratorUtil.java:43) at org.pentaho.dashboards.content.DashboardRenderer.b(SourceFile:547) at org.pentaho.dashboards.content.DashboardRenderer.createContent(SourceFile:377) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: java.lang.RuntimeException: Database type not found! at org.pentaho.di.core.database.DatabaseMeta.setValues(DatabaseMeta.java:540) at org.pentaho.di.core.database.DatabaseMeta.<init>(DatabaseMeta.java:392) at org.pentaho.pms.mql.dialect.DefaultSQLDialect.<init>(DefaultSQLDialect.java:64) at org.pentaho.pms.mql.dialect.HiveDialect.<init>(SourceFile:63) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at java.lang.Class.newInstance0(Class.java:355) at java.lang.Class.newInstance(Class.java:308) at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:345) ... 103 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: database type with plugin id [HIVE] couldn't be found! at org.pentaho.di.core.database.DatabaseMeta.findDatabaseInterface(DatabaseMeta.java:485) at org.pentaho.di.core.database.DatabaseMeta.getDatabaseInterface(DatabaseMeta.java:461) at org.pentaho.di.core.database.DatabaseMeta.setValues(DatabaseMeta.java:536) ... 113 more 11:33:20,030 ERROR [SystemSettings] ::: SYSTEMSETTINGS.ERROR_0002 - File C:\Pentaho\Testing\3.7NIGHTLY\biserver-ee\pentaho-solutions\system\ee-chart-plugin\settings.xml does not exist 11:33:20,030 ERROR [SystemSettings] ::: SYSTEMSETTINGS.ERROR_0002 - File C:\Pentaho\Testing\3.7NIGHTLY\biserver-ee\pentaho-solutions\system\ee-chart-plugin\settings.xml does not exist 11:33:20,111 ERROR [SystemSettings] ::: SYSTEMSETTINGS.ERROR_0002 - File C:\Pentaho\Testing\3.7NIGHTLY\biserver-ee\pentaho-solutions\system\ee-chart-plugin\settings.xml does not exist 11:33:20,112 ERROR [SystemSettings] ::: SYSTEMSETTINGS.ERROR_0002 - File C:\Pentaho\Testing\3.7NIGHTLY\biserver-ee\pentaho-solutions\system\ee-chart-plugin\settings.xml does not exist

    Pentaho BI Platform Tracking | 6 years ago | Rob Fellows
    java.util.ServiceConfigurationError: org.pentaho.pms.mql.dialect.SQLDialectInterface: Provider org.pentaho.pms.mql.dialect.HiveDialect could not be instantiated: java.lang.RuntimeException: Database t ype not found!
  4. 0

    The final step (integration test) of TC1088 fails with java.lang.RuntimeException: Database type [HIVE] not found! Hadoop license is installed. Can browse Hive tables in Metadata editor's database connection dialog (and other client tools). Hive jars are present in tomcat/webapps/pentaho/WEB-INF/lib/hive. Stack trace: 2011-08-18 11:42:34,436 ERROR [org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent] error java.lang.RuntimeException: Database type [HIVE] not found! at org.pentaho.di.core.database.DatabaseMeta.setDatabaseType(DatabaseMeta.java:568) at org.pentaho.metadata.util.ThinModelConverter.convertToLegacy(ThinModelConverter.java:100) at org.pentaho.platform.plugin.services.connections.metadata.sql.SqlMetadataQueryExec.executeQuery(SqlMetadataQueryExec.java:65) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:231) at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1293) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:202) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:189) at $Proxy11.execute(Unknown Source) at org.pentaho.platform.web.servlet.AdhocWebService.executeActionSequence(AdhocWebService.java:556) at org.pentaho.platform.web.servlet.AdhocWebService.createJFreeReportAsStream(AdhocWebService.java:485) at org.pentaho.platform.web.servlet.AdhocWebService.generatePreview(AdhocWebService.java:409) at org.pentaho.platform.web.servlet.AdhocWebService.dispatch(AdhocWebService.java:297) at org.pentaho.platform.web.servlet.AdhocWebService.doGet(AdhocWebService.java:263) at org.pentaho.platform.web.servlet.AdhocWebService.doPost(AdhocWebService.java:337) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:680)

    Pentaho BI Platform Tracking | 5 years ago | Mark Hall
    java.lang.RuntimeException: Database type [HIVE] not found!

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.RuntimeException

      Database type not found!

      at org.pentaho.di.core.database.DatabaseMeta.setValues()
    2. org.pentaho.di
      DatabaseMeta.setDefault
      1. org.pentaho.di.core.database.DatabaseMeta.setValues(DatabaseMeta.java:569)
      2. org.pentaho.di.core.database.DatabaseMeta.setDefault(DatabaseMeta.java:446)
      2 frames