Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Install issues - Linux with PostgreSQL

  1. #1
    Join Date
    Mar 2016
    Posts
    2

    Default Install issues - Linux with PostgreSQL

    I was following this tutorial found here:
    https://anonymousbi.wordpress.com/20...llation-guide/
    Trying to get the bi-server installed and running, but haven't had much luck. I substituted the PostgreSQL driver in place of the MySQL driver in all the places specified. I'm not entirely sure what information is necessary, so I'll do my best to provide useful information. This should explain my environment a bit:

    VersionLoggerListener.log Server version: Apache Tomcat/8.0.24
    VersionLoggerListener.log Server built: Jul 1 2015 20:19:55 UTC
    VersionLoggerListener.log Server number: 8.0.24.0
    VersionLoggerListener.log OS Name: Linux
    VersionLoggerListener.log OS Version: 3.16.0-38-generic
    VersionLoggerListener.log Architecture: amd64
    VersionLoggerListener.log Java Home: /usr/lib/jvm/java-7-openjdk-amd64/jre
    VersionLoggerListener.log JVM Version: 1.7.0_95-b00
    VersionLoggerListener.log JVM Vendor: Oracle Corporation
    VersionLoggerListener.log CATALINA_BASE: /usr/local/src/biserver-ce/tomcat
    VersionLoggerListener.log CATALINA_HOME: /usr/local/src/biserver-ce/tomcat
    VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/src/biserver-ce/tomcat/conf/logging.properties
    VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
    VersionLoggerListener.log Command line argument: -Xms2048m
    VersionLoggerListener.log Command line argument: -Xmx6144m
    VersionLoggerListener.log Command line argument: -XX:MaxPermSize=256m
    VersionLoggerListener.log Command line argument: -Dsun.rmi.dgc.client.gcInterval=3600000
    VersionLoggerListener.log Command line argument: -Dsun.rmi.dgc.server.gcInterval=3600000
    VersionLoggerListener.log Command line argument: -DDI_HOME=/usr/local/src/biserver-ce/pentaho-solutions/system/kettle
    VersionLoggerListener.log Command line argument: -Djava.endorsed.dirs=/usr/local/src/biserver-ce/tomcat/endorsed
    VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/src/biserver-ce/tomcat
    VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/src/biserver-ce/tomcat
    VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/src/biserver-ce/tomcat/temp

    On startup it hangs on this for a bit, but seems to continue on after a few seconds:
    WARNING [localhost-startStop-1] org.apache.catalina.startup.SetContextPropertiesRule.begin [SetContextPropertiesRule]{Context} Setting property 'docbase' to 'webapps/pentaho/' did not find a matching property.

    First major problem is this:
    ERROR [Logger] Error: Pentaho
    ERROR [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener
    org.pentaho.platform.api.engine.PentahoSystemException: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:363)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:326)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:222)
    at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:154)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1101)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1786)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener
    at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:445)
    at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:427)
    at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:406)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:427)
    at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:82)
    at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:358)
    at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:355)
    at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:406)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:355)
    ... 16 more
    ... 24 more
    15:47:58,379 ERROR [Logger] Error end:
    Pentaho BI Platform server failed to properly initialize. The system will not be available for requests. (Pentaho Open Source BA Server 6.0.1.0-386) Fully Qualified Server Url = http://localhost:8080/pentaho/, Solution Path = /usr/local/src/biserver-ce/pentaho-solutions

    I'm guessing that this has something to do with the database driver? I did install the package for the PostgreSQL Java library and copied the file /usr/share/java/postgresql-jdbc4-9.2.jar that was installed into the following two directories:
    data/lib
    tomcat/webapps/pentaho/WEBINF/lib
    Couldn't find any documentation on what was required to get the database drivers working or how to verify that it's all working, so I'm not sure if it requires more than that or not. It does however continue on, where it immediately fails again trying to connect to the plugin repository:

    ERROR [PluginRepositoryResourceAccess] Unable to get repository as system.
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'cachingUserDetailsService' defined in file [/usr/local/src/biserver-ce/pentaho-solutions/system/pentahoObjects.spring.xml]: Cannot resolve reference to bean 'UserDetailsService' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'UserDetailsService' defined in file [/usr/local/src/biserver-ce/pentaho-solutions/system/pentahoObjects.spring.xml]: Cannot resolve reference to bean 'activeUserDetailsService' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activeUserDetailsService': FactoryBean threw exception on object creation; nested exception is java.lang.IllegalStateException: Fatal Circular reference in Pentaho Bean ( org.springframework.security.userdetails.UserDetailsService : {providerName=jackrabbit})
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
    at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:651)
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:145)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1077)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:981)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
    at org.pentaho.platform.engine.core.system.objfac.spring.SpringPentahoObjectReference.getObject(SpringPentahoObjectReference.java:74)
    at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:267)
    at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:137)
    at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:757)
    at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:658)
    at org.pentaho.platform.engine.security.SecurityHelper.getUserDetailsService(SecurityHelper.java:429)
    at org.pentaho.platform.engine.security.SecurityHelper.createAuthentication(SecurityHelper.java:313)
    at org.pentaho.platform.engine.security.SecurityHelper.runAsSystem(SecurityHelper.java:392)
    at pt.webdetails.cpf.repository.pentaho.unified.PluginRepositoryResourceAccess.getSystemAccessRepository(PluginRepositoryResourceAccess.java:48)
    at pt.webdetails.cpf.repository.pentaho.unified.PluginRepositoryResourceAccess.getRepository(PluginRepositoryResourceAccess.java:65)
    at pt.webdetails.cpf.repository.pentaho.unified.UnifiedRepositoryAccess.getRepositoryFile(UnifiedRepositoryAccess.java:142)
    at pt.webdetails.cpf.repository.pentaho.unified.UnifiedRepositoryAccess.fileExists(UnifiedRepositoryAccess.java:62)
    at pt.webdetails.cdf.dd.extapi.FileHandler.createBasicDirIfNotExists(FileHandler.java:144)
    at pt.webdetails.cdf.dd.CdeEngine.ensureDirExists(CdeEngine.java:145)
    at pt.webdetails.cdf.dd.CdeEngine.ensureBasicDirs(CdeEngine.java:92)
    at pt.webdetails.cdf.dd.CdeEngine.initialize(CdeEngine.java:85)
    at pt.webdetails.cdf.dd.CdeEngine.getInstance(CdeEngine.java:54)
    at pt.webdetails.cdf.dd.CdeLifeCycleListener.ready(CdeLifeCycleListener.java:39)
    at org.pentaho.platform.web.http.context.PentahoSystemReadyListener.contextInitialized(PentahoSystemReadyListener.java:52)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1101)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1786)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'UserDetailsService' defined in file [/usr/local/src/biserver-ce/pentaho-solutions/system/pentahoObjects.spring.xml]: Cannot resolve reference to bean 'activeUserDetailsService' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activeUserDetailsService': FactoryBean threw exception on object creation; nested exception is java.lang.IllegalStateException: Fatal Circular reference in Pentaho Bean ( org.springframework.security.userdetails.UserDetailsService : {providerName=jackrabbit})
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:358)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
    at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:651)
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:145)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1077)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:981)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
    ... 43 more
    ... 57 more
    ... 62 more
    15:47:58,475 ERROR [CdeEngine] Error initializing CdeEngine: [ java.lang.NullPointerException ] - null
    15:47:58,479 ERROR [PluginRepositoryResourceAccess] Unable to get repository as system.

    I believe this cascades all the errors that follow. Ultimately it ends up choking on two main issues, which repeats quite a bit before the second error kills it:

    WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [pentaho] appears to have started a thread named [DefaultQuartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
    java.lang.Object.wait(Native Method)
    org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:540)

    SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [pentaho] created a ThreadLocal with key of type [java.lang.InheritableThreadLocal] (value [java.lang.InheritableThreadLocal@ef22e8f]) and a value of type [org.pentaho.platform.engine.security.PentahoSecurityContextHolderStrategy.PentahoSecurityContextImpl] (value [Authentication: org.springframework.security.providers.UsernamePasswordAuthenticationToken@72bc6602: Principal: 6e628285-6030-459d-ae04-f84572ef0b7d; Password: [PROTECTED]; Authenticated: false; Details: null; Not granted any authorities]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
    16-Mar-2016 15:47:59.042 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [pentaho] created a ThreadLocal with key of type [java.lang.InheritableThreadLocal] (value [java.lang.InheritableThreadLocal@3dceb5f3]) and a value of type [org.springframework.security.providers.UsernamePasswordAuthenticationToken] (value [org.springframework.security.providers.UsernamePasswordAuthenticationToken@72bc6602: Principal: 6e628285-6030-459d-ae04-f84572ef0b7d; Password: [PROTECTED]; Authenticated: false; Details: null; Not granted any authorities]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.

    I'm a little lost trying to track down the cause for this - not being entirely familiar with the architecture setup and configuration methods. I had this configuration using PostgreSQL running locally and spun up another server to try it using MySQL, but ultimately both have basically the same issues. Any help that anyone could provide would be greatly appreciated. Even just a nudge in the right direction would go a long way right now. 8-)

    -Davey

  2. #2
    Join Date
    May 2014
    Posts
    358

    Default

    Pentaho uses the database for three things: Jackrabbit (repository), Quartz (scheduler) and Hibernate (users & roles). Try deploying an unmodified version of the server (this will use a file repo for JCR and Hypersonic/H2 in-memory DB for Quartz and hibernate) and then switch only one data source at a time, then you might see what fails.

  3. #3
    Join Date
    Mar 2016
    Posts
    2

    Default

    That was a very simple and most excellent suggestion. Using the unaltered package is working just fine. Clearly there are some unaddressed issues with that tutorial, but having a better understanding now of at least some of the structure and components I believe you have the best solution, which is to try each one at a time moving it to use the DB of preference. If it were a snake, I'd be laying dead in the desert somewhere. 8-) Thanks so much for your valued insight.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.