Pentaho 初始化异常 [英] Pentaho Initialization Exception
问题描述
当我尝试启动我的 Pentaho BI 服务器时，我收到了几个错误.我知道这无法启动 QuartZ 数据库，但我可以帮助解决以下问题吗?
When I am trying to start my Pentaho BI server, I received a couple of errors. I understand that this cannot start the QuartZ database, but could I have some help resolving the following issue?
Pentaho 用户控制台
检测到以下错误.
一个或多个系统侦听器失败.这些设置在 systemListeners.xml 中.
One or more system listeners failed. These are set in the systemListeners.xml.
PentahoSystem.ERROR_0014 - 尝试执行启动时出错org.pentaho.platform.scheduler.QuartzSystemListener 的序列
PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.scheduler.QuartzSystemListener
有关检测到的每个错误的更多详细信息，请参阅服务器控制台.
Please see the server console for more details on each error detected.
下面是日志文件
10:13:55,832 WARN [PackageManager] 包的未解析依赖项:org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaModule10:13:55,857 警告 [PackageSorter] 在已知模块列表中找不到相关模块.10:13:58,963 错误 [记录器] misc-org.pentaho.platform.scheduler.QuartzSystemListener: QuartzSystemListener.ERROR_0001 - > 调度器在启动时没有正确初始化org.quartz.SchedulerConfigException:作业恢复期间发生故障.[参见嵌套异常:org.quartz.JobPersistenceException:无法从数据源myDS"获取数据库连接:java.sql.SQLException:无法通过 JNDI url 'java:comp/env/jdbc/Quartz' org.apache 检索数据源.commons.dbcp.SQLNestedException:无法创建 PoolableConnectionFactory(用户 'pentaho_user'@'localhost' 的访问被拒绝(使用密码:YES))[参见嵌套异常:java.sql.SQLException:无法通过 JNDI url 'java: 检索数据源:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException:无法创建 PoolableConnectionFactory(用户 'pentaho_user'@'localhost' 访问被拒绝(使用密码:YES))]]在 org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493)在 org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68)在 org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010)在 org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152)在 org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSystemListener.java:112)在 org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:342)在 org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324)在 org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291)在 org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208)在 org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137)在 org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)在 org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)在 org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)在 org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)在 org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)在 org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)在 org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)在 org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)在 org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)在 org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)在 org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)在 org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)在 org.apache.catalina.core.StandardHost.start(StandardHost.java:785)在 org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)在 org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)在 org.apache.catalina.core.StandardService.start(StandardService.java:519)在 org.apache.catalina.core.StandardServer.start(StandardServer.java:710)在 org.apache.catalina.startup.Catalina.start(Catalina.java:581)在 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)在 sun.reflect.NativeMethodAccessorImpl.invoke(未知来源)在 sun.reflect.DelegatingMethodAccessorImpl.invoke(未知来源)在 java.lang.reflect.Method.invoke(Unknown Source)在 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)在 org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)* 嵌套异常(根本原因) ---------------org.quartz.JobPersistenceException:无法从数据源myDS"获取数据库连接:java.sql.SQLException:无法通过 JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp 检索数据源.SQLNestedException:无法创建 PoolableConnectionFactory(用户 'pentaho_user'@'localhost' 的访问被拒绝(使用密码:YES))[参见嵌套异常:java.sql.SQLException:无法通过 JNDI url 'java:comp/env/jdbc 检索数据源/Quartz' org.apache.commons.dbcp.SQLNestedException:无法创建 PoolableConnectionFactory(用户 'pentaho_user'@'localhost' 的访问被拒绝(使用密码:YES))]在 org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:575)在 org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(JobStoreTX.java:109)在 org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:491)在 org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68)在 org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010)在 org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152)在 org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSystemListener.java:112)在 org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:342)在 org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324)在 org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291)在 org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208)在 org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137)在 org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)在 org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)在 org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)在 org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)在 org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)在 org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)在 org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)在 org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)在 org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)在 org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)在 org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)在 org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)在 org.apache.catalina.core.StandardHost.start(StandardHost.java:785)在 org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)在 org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)在 org.apache.catalina.core.StandardService.start(StandardService.java:519)在 org.apache.catalina.core.StandardServer.start(StandardServer.java:710)在 org.apache.catalina.startup.Catalina.start(Catalina.java:581)在 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)在 sun.reflect.NativeMethodAccessorImpl.invoke(未知来源)在 sun.reflect.DelegatingMethodAccessorImpl.invoke(未知来源)在 java.lang.reflect.Method.invoke(Unknown Source)在 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)在 org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)* 嵌套异常(根本原因) ---------------java.sql.SQLException:无法通过 JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException 检索数据源:无法创建 PoolableConnectionFactory(用户 'pentaho_user'@'localhost' 的访问被拒绝(使用密码:是))在 org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)在 org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111)在 org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553)在 org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(JobStoreTX.java:109)在 org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:491)在 org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68)在 org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010)在 org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152)在 org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSystemListener.java:112)在 org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:342)在 org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324)在 org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291)在 org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208)在 org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137)在 org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)在 org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)在 org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)在 org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)在 org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)在 org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)在 org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)在 org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)在 org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)在 org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)在 org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)在 org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)在 org.apache.catalina.core.StandardHost.start(StandardHost.java:785)在 org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)在 org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)在 org.apache.catalina.core.StandardService.start(StandardService.java:519)在 org.apache.catalina.core.StandardServer.start(StandardServer.java:710)在 org.apache.catalina.startup.Catalina.start(Catalina.java:581)在 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)在 sun.reflect.NativeMethodAccessorImpl.invoke(未知来源)在 sun.reflect.DelegatingMethodAccessorImpl.invoke(未知来源)在 java.lang.reflect.Method.invoke(Unknown Source)在 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)在 org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)10:13:58,967 错误 [记录器] 错误:Pentaho10:13:58,967 错误 [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.ERROR_0014 - 尝试执行 org.pentaho.platform.scheduler.QuartzSystemListener 的启动序列时出错org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - 尝试执行 org.pentaho.platform.scheduler.QuartzSystemListener 的启动序列时出错在 org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:350)在 org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324)在 org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291)在 org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208)在 org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137)在 org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)在 org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)在 org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)在 org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)在 org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)在 org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)在 org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)在 org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)在 org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)在 org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)在 org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)在 org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)在 org.apache.catalina.core.StandardHost.start(StandardHost.java:785)在 org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)在 org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)在 org.apache.catalina.core.StandardService.start(StandardService.java:519)在 org.apache.catalina.core.StandardServer.start(StandardServer.java:710)在 org.apache.catalina.startup.Catalina.start(Catalina.java:581)在 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)在 sun.reflect.NativeMethodAccessorImpl.invoke(未知来源)在 sun.reflect.DelegatingMethodAccessorImpl.invoke(未知来源)在 java.lang.reflect.Method.invoke(Unknown Source)在 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)在 org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)引起:org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - 尝试执行 org.pentaho.platform.scheduler.QuartzSystemListener 的启动序列时出错在 org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:343)... 28 更多10:13:58,968 错误 [记录器] 错误结束:
10:13:55,832 WARN [PackageManager] Unresolved dependency for package: org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaModule 10:13:55,857 WARN [PackageSorter] A dependent module was not found in the list of known modules. 10:13:58,963 ERROR [Logger] misc-org.pentaho.platform.scheduler.QuartzSystemListener: QuartzSystemListener.ERROR_0001 - > Scheduler was not properly initialized at startup org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'pentaho_user'@'localhost' (using password: YES)) [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'pentaho_user'@'localhost' (using password: YES))]] at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493) at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSystemListener.java:112) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:342) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:785) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445) at org.apache.catalina.core.StandardService.start(StandardService.java:519) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:581) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) * Nested Exception (Underlying Cause) --------------- org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'pentaho_user'@'localhost' (using password: YES)) [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'pentaho_user'@'localhost' (using password: YES))] at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:575) at org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(JobStoreTX.java:109) at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:491) at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSystemListener.java:112) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:342) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:785) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445) at org.apache.catalina.core.StandardService.start(StandardService.java:519) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:581) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) * Nested Exception (Underlying Cause) --------------- java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'pentaho_user'@'localhost' (using password: YES)) at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166) at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111) at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553) at org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(JobStoreTX.java:109) at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:491) at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSystemListener.java:112) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:342) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:785) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445) at org.apache.catalina.core.StandardService.start(StandardService.java:519) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:581) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) 10:13:58,967 ERROR [Logger] Error: Pentaho 10:13:58,967 ERROR [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.scheduler.QuartzSystemListener org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.scheduler.QuartzSystemListener at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:350) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:785) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445) at org.apache.catalina.core.StandardService.start(StandardService.java:519) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:581) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.scheduler.QuartzSystemListener at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:343) ... 28 more 10:13:58,968 ERROR [Logger] Error end:
推荐答案
Pentaho 6.1 在作为服务运行的 Windows 上存在同样的问题.当不作为服务运行时，它起作用了.
Same problem here with Pentaho 6.1 on windows running as service. When runnning not as service it worked.
解决办法:这是自 5.2 以来的错误.http://jira.pentaho.com/browse/BISERVER-12183
Solution: It's a bug since 5.2. http://jira.pentaho.com/browse/BISERVER-12183
解决方案是使用 tomcat8w.exe//ES//正确设置启动 - 工作路径.而不是 biserver-ce\tomcat 它应该是 biserver-ce\tomcat\bin.
Solution is to set the Startup - Working Path with tomcat8w.exe //ES// correctly. Instead of biserver-ce\tomcat it should be biserver-ce\tomcat\bin.
由于路径错误，pentaho 创建了一个新的空 HSQLDB，它没有用户pentaho_user".此外， pentaho.log 驻留在错误的目录中.在 biserver-ce\log 中而不是在 biserver-ce\tomcat\log 中.这也可以通过更改工作路径来解决.
Due to the wrong path, pentaho creates a new empty HSQLDB which doesn't have the user "pentaho_user". Additionally the pentaho.log resides in the wrong directory. In biserver-ce\log instead of in biserver-ce\tomcat\log. This is fixed by changing th Working Path, too.
这篇关于Pentaho 初始化异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
