Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: RDBMS Solution Repository

  1. #1
    Join Date
    Jan 2008
    Posts
    4

    Default RDBMS Solution Repository

    I followed the instructions referenced from this thread http://forums.pentaho.org/showthread.php?t=57746 and when i restart the server and navigate to the Properties Editor in the admin section, I still see the " Permissions cannot be applied. This installation is configured to use the file-based solution repository. Permissions can only be set using the RDBMS-based solution repository." error message.

    Is there something additional that I need to do?

  2. #2
    Join Date
    Jan 2008
    Posts
    4

    Default

    After downloading the MySQL pre-configured installation, I've actually moved back several steps. The pentaho server no longer starts up correctly and instead throws a massive stack trace that looks something like what's in the attached log file.

    If I browse to the site I see "PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.plugin.olap.MondrianSystemListener".

    I checked, and there is a pentaho_user@% created in the database, but not a pentaho_user@localhost, which shouldn't matter for mysql.

    Any help would be greatly appreciated.

    Thanks,

    jeremiah
    Attached Files Attached Files

  3. #3
    Join Date
    Dec 2009
    Posts
    9

    Default

    I am getting the same error. " PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener" When I try to view 'pentaho'. This is on a manual deployment using mysql. Also, this is my first time with a manual deployment and mysql. Thanks in advance if anyone knows.

    Log:
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
    .java:760)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
    0)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)

    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
    va:626)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
    ava:553)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488
    )
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
    :311)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
    eSupport.java:120)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)

    at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
    )
    at org.apache.catalina.core.StandardService.start(StandardService.java:4
    48)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
    )
    at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
    java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
    Caused by: java.lang.ClassNotFoundException: com.mchange.v2.c3p0.DataSources
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
    der.java:1386)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
    der.java:1232)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:316)
    ... 54 more
    java.lang.NoClassDefFoundError: Could not initialize class org.pentaho.platform.
    repository.hibernate.HibernateUtil
    at org.pentaho.platform.repository.hibernate.HibernateUtil.systemExitPoi
    nt(HibernateUtil.java:702)
    at org.pentaho.platform.engine.core.system.StandaloneApplicationContext.
    invokeExitPoints(StandaloneApplicationContext.java:169)
    at org.pentaho.platform.engine.core.system.PentahoSystem.systemExitPoint
    (PentahoSystem.java:860)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
    tenersOfStartup(PentahoSystem.java:314)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
    tenersOfStartup(PentahoSystem.java:291)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
    tem.java:265)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
    tem.java:206)
    at org.pentaho.platform.web.http.context.SolutionContextListener.context
    Initialized(SolutionContextListener.java:136)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
    t.java:3795)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
    252)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
    .java:760)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
    0)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)

    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
    va:626)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
    ava:553)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488
    )
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
    :311)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
    eSupport.java:120)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)

    at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
    )
    at org.apache.catalina.core.StandardService.start(StandardService.java:4
    48)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
    )
    at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
    java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
    java.lang.NoClassDefFoundError: Could not initialize class org.pentaho.platform.
    repository.hibernate.HibernateUtil
    at org.pentaho.platform.repository.hibernate.HibernateUtil.systemExitPoi
    nt(HibernateUtil.java:709)
    at org.pentaho.platform.engine.core.system.StandaloneApplicationContext.
    invokeExitPoints(StandaloneApplicationContext.java:169)
    at org.pentaho.platform.engine.core.system.PentahoSystem.systemExitPoint
    (PentahoSystem.java:860)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
    tenersOfStartup(PentahoSystem.java:314)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
    tenersOfStartup(PentahoSystem.java:291)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
    tem.java:265)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
    tem.java:206)
    at org.pentaho.platform.web.http.context.SolutionContextListener.context
    Initialized(SolutionContextListener.java:136)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
    t.java:3795)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
    252)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
    .java:760)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
    0)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)

    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
    va:626)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
    ava:553)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488
    )
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
    :311)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
    eSupport.java:120)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)

    at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
    )
    at org.apache.catalina.core.StandardService.start(StandardService.java:4
    48)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
    )
    at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
    java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
    11:49:25,545 ERROR [Logger] Error: Pentaho
    11:49:25,545 ERROR [Logger] misc-org.pentaho.platform.engine.core.system.Pentaho
    System: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequenc
    e for org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener
    org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014
    - Error while trying to execute startup sequence for org.pentaho.platform.plugi
    n.action.mondrian.MondrianSystemListener
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
    tenersOfStartup(PentahoSystem.java:311)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
    tenersOfStartup(PentahoSystem.java:291)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
    tem.java:265)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
    tem.java:206)
    at org.pentaho.platform.web.http.context.SolutionContextListener.context
    Initialized(SolutionContextListener.java:136)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
    t.java:3795)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
    252)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
    .java:760)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
    0)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)

    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
    va:626)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
    ava:553)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488
    )
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
    :311)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
    eSupport.java:120)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)

    at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
    )
    at org.apache.catalina.core.StandardService.start(StandardService.java:4
    48)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
    )
    at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
    java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
    Caused by: java.lang.ExceptionInInitializerError
    at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(Hi
    bernateUtil.java:207)
    at org.pentaho.platform.repository.hibernate.HibernateUtil.<clinit>(Hibe
    rnateUtil.java:95)
    at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepos
    itory.internalGetRootFolder(DbBasedSolutionRepository.java:965)
    at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepos
    itory.init(DbBasedSolutionRepository.java:111)
    at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepos
    itory.<init>(DbBasedSolutionRepository.java:96)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
    orAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
    onstructorAccessorImpl.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 org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoO
    bjectFactory.instanceClass(AbstractSpringPentahoObjectFactory.java:78)
    at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoO
    bjectFactory.retreiveObject(AbstractSpringPentahoObjectFactory.java:117)
    at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoO
    bjectFactory.get(AbstractSpringPentahoObjectFactory.java:72)
    at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSyst
    em.java:508)
    at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSyst
    em.java:484)
    at org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener.lo
    adMondrianProperties(MondrianSystemListener.java:60)
    at org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener.st
    artup(MondrianSystemListener.java:46)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
    tenersOfStartup(PentahoSystem.java:306)
    ... 28 more
    Caused by: java.lang.NoClassDefFoundError: com/mchange/v2/c3p0/DataSources
    at org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0Connect
    ionProvider.java:154)
    at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvi
    der(ConnectionProviderFactory.java:124)
    at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvi
    der(ConnectionProviderFactory.java:56)
    at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFa
    ctory.java:414)
    at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
    62)
    at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073
    )
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
    a:1298)
    at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(Hi
    bernateUtil.java:177)
    ... 46 more
    Caused by: java.lang.ClassNotFoundException: com.mchange.v2.c3p0.DataSources
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
    der.java:1386)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
    der.java:1232)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:316)
    ... 54 more
    11:49:25,560 ERROR [Logger] Error end:
    Pentaho BI Platform server failed to properly initialize. The system will not be
    available for requests. (Pentaho Platform Engine Core 3.5.0.stable.39705) Base
    Url = http://xx.xx.xx.xx:8080/pentaho/, Solution Path = F:\Tomcat\webapps\penta
    ho-solutions
    Dec 2, 2009 11:49:25 AM org.apache.catalina.startup.HostConfig deployWAR
    INFO: Deploying web application archive pentaho-style.war
    Dec 2, 2009 11:49:25 AM org.apache.coyote.http11.Http11BaseProtocol start
    INFO: Starting Coyote HTTP/1.1 on http-8080
    Dec 2, 2009 11:49:25 AM org.apache.jk.common.ChannelSocket init
    INFO: JK: ajp13 listening on /0.0.0.0:8009
    Dec 2, 2009 11:49:25 AM org.apache.jk.server.JkMain start
    INFO: Jk running ID=0 time=0/0 config=null
    Dec 2, 2009 11:49:25 AM org.apache.catalina.storeconfig.StoreLoader load
    INFO: Find registry server-registry.xml at classpath resource
    Dec 2, 2009 11:49:25 AM org.apache.catalina.startup.Catalina start
    INFO: Server startup in 8765 ms

  4. #4

    Default

    In the midst of the logging it appears that the c3p0 jar is not found.

    Check if the file truly is not available and, if so, add it.

    Mark Dathorne

  5. #5
    Join Date
    Dec 2009
    Posts
    9

    Default

    Thanks for the reply Mark. It was that and some other issues I had. Ended up getting it running smoothly with IIS and MySQL though I might write a 3.5 install guide with IIS and MySQL when I hopefully have some time.

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.