Pentaho

This content was either too long or contained formatting that did not work with our migration. A PDF document is attached that contains the original representation

 

Hi, the company in which I work has decided to try Pentaho and has given the job to me but, I don't know anything about it !!!So, this is my scenario:CentOS 7Pentaho 8.3 Archive installationMySQL 5.7.26 I followed the guide on the site step by step:https://help.pentaho.com/Documentation/8.3/Setup/Archive_installation <https://help.pentaho.com/Documentation/8.3/Setup/Archive_installation>I modified all the configuration files as the guide says but when I start the application, it doesn't start the right way.if I connect to the url, http:// <http:><url_pentaho>.it:8080 the error I see on the page is this:Pentaho Initialization ExceptionThe following errors were detected[it_49] One or more system listeners failed. These are set in the systemListeners.xml. org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Errore nel tentativo di eseguire la sequenza di startup per org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListenerPlease see the server console for more details on each error detected.In the log file catalina.out, I see more than one error but the first, is this:23-Jul-2019 10:06:06.540 INFORMAZIONI [FelixStartLevel] org.apache.cxf.management.jmx.InstrumentationManagerImpl.registerMBeanWithServer registering MBean org.apache.cxf:bus.id=pentaho-metaverse-web-cxf316840962,type=Bus.Service.Endpoint,service="{http://service.metaverse.pentaho.org/ <http://service.metaverse.pentaho.org/>}MetaverseService",port="MetaverseService",instance.id=1773154902: org.apache.cxf.endpoint.ManagedEndpoint@a402c6b23-Jul-2019 10:06:06.541 INFORMAZIONI [FelixStartLevel] org.apache.cxf.management.jmx.InstrumentationManagerImpl.registerMBeanWithServer registering MBean org.apache.cxf:bus.id=pentaho-metaverse-web-cxf316840962,type=Bus.Service.Endpoint,service="{http://service.metaverse.pentaho.org/ <http://service.metaverse.pentaho.org/>}MetaverseService",port="MetaverseService",instance.id=1773154902: javax.management.modelmbean.RequiredModelMBean@569c75d110:06:15,212 ERROR [Logger] Error: Pentaho10:06:15,213 ERROR [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Errore nel tentativo di eseguire la sequenza di startup per org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListenerorg.pentaho.platform.api.engine.PentahoSystemException: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Errore nel tentativo di eseguire la sequenza di startup per org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:398) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:360) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:243) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:164) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)Caused by: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Errore nel tentativo di eseguire la sequenza di startup per org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:480) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:462) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:441) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:462) at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:87) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:393) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:390) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:441) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:390) ... 16 moreCaused by: java.lang.NullPointerException at org.pentaho.platform.repository.JcrBackedDatasourceMgmtService.init(JcrBackedDatasourceMgmtService.java:69) at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.retreiveObject(AbstractSpringPentahoObjectFactory.java:268) at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:84) at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:275) at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:139) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener.getListOfDatabaseConnections(NonPooledDatasourceSystemListener.java:140) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener.startup(NonPooledDatasourceSystemListener.java:56) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:471) ... 24 more10:06:15,215 ERROR [Logger] Error end:10:06:15,215 INFO [PeriodicStatusLogger] Warning, one or more errors occurred during the initialization process.[it_68] Pentaho BI Platform server failed to properly initialize. The system will not be available for requests.10:06:25,320 ERROR [CompositeUserRoleListService] User/Role List could not be obtained.java.lang.IllegalStateException: Target of Bean was never resolved: org.springframework.security.core.userdetails.UserDetailsService at org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder$1.invoke(BeanBuilder.java:159) at com.sun.proxy.$Proxy86.loadUserByUsername(Unknown Source) at org.pentaho.platform.plugin.services.security.userrole.ChainedUserDetailsService.loadUserByUsername(ChainedUserDetailsService.java:50) at org.pentaho.platform.plugin.services.security.userrole.PentahoCachingUserDetailsService.loadUserByUsername(PentahoCachingUserDetailsService.java:77) at org.pentaho.platform.security.userroledao.service.UserRoleDaoUserRoleListService.getRolesForUser(UserRoleDaoUserRoleListService.java:146) at org.pentaho.platform.plugin.services.security.userrole.ExtraRolesUserRoleListServiceDecorator.getRolesForUser(ExtraRolesUserRoleListServiceDecorator.java:116) at org.pentaho.platform.plugin.services.security.userrole.CompositeUserRoleListService$7.perform(CompositeUserRoleListService.java:124) at org.pentaho.platform.plugin.services.security.userrole.CompositeUserRoleListService.collectResultsForOperation(CompositeUserRoleListService.java:133) at org.pentaho.platform.plugin.services.security.userrole.CompositeUserRoleListService.getRolesForUser(CompositeUserRoleListService.java:122) at org.pentaho.platform.engine.security.SecurityHelper.createAuthentication(SecurityHelper.java:355) at org.pentaho.platform.engine.security.SecurityHelper.runAsSystem(SecurityHelper.java:418) at pt.webdetails.cpf.CpfProperties.loadAsSystem(CpfProperties.java:46) at pt.webdetails.cpf.AbstractCpfProperties.loadSettings(AbstractCpfProperties.java:58) at pt.webdetails.cpf.AbstractCpfProperties.<init>(AbstractCpfProperties.java:35) at pt.webdetails.cpf.CpfProperties.<init>(CpfProperties.java:32) at pt.webdetails.cpf.CpfProperties.getInstance(CpfProperties.java:37) at pt.webdetails.cpf.SimpleLifeCycleListener.ready(SimpleLifeCycleListener.java:44) at org.pentaho.platform.web.http.context.PentahoSystemReadyListener.contextInitialized(PentahoSystemReadyListener.java:56) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadP...
#Pentaho
#Kettle