I created the following docker compose:
version: "3"
services:
# Pentaho BI
pentaho:
container_name: pentaho
image: ca0abinary/docker-pentaho
depends_on:
- pentaho-pg
ports:
- "8080:8080"
environment:
- PGHOST=pentaho-pg
- PGUSER=pentaho
- PGPASSWORD=password
volumes:
- pentaho-hsqldb-data:/opt/pentaho/server/pentaho-server/data/hsqldb
- pentaho-jackrabbit-data:/opt/pentaho/server/pentaho-server/pentaho-solutions/system/jackrabbit/repository
networks:
- integracion
# PostgreSQL Database for Pentaho BI
pentaho-pg:
container_name: pentaho-pg
image: postgres:9.4
ports:
- "4432:5432"
environment:
- POSTGRES_USER=pentaho
- POSTGRES_PASSWORD=password
- PGDATA=/var/lib/postgresql/data/pgdata
volumes:
- pentaho-pg-data:/var/lib/postgresql/data/pgdata
networks:
- integracion
volumes:
pentaho-hsqldb-data: null
pentaho-jackrabbit-data: null
pentaho-pg-data: null
networks:
integracion:
driver: bridge
ipam:
driver: default
config:
- subnet: 172.19.0.0/16
then execute docker-compose up
and te output is:
pentaho | 21:38:11,794 ERROR [Logger] Error: Pentaho
pentaho | 21:38:11,795 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
pentaho | 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
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:369)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:331)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:227)
pentaho | at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:162)
pentaho | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4853)
pentaho | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
pentaho | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
pentaho | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
pentaho | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
pentaho | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
pentaho | at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1092)
pentaho | at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1834)
pentaho | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
pentaho | at java.util.concurrent.FutureTask.run(FutureTask.java:266)
pentaho | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
pentaho | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
pentaho | at java.lang.Thread.run(Thread.java:745)
pentaho | 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
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:451)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:433)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:412)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:433)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:83)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:364)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:361)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:412)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:361)
pentaho | ... 16 more
pentaho | Caused by: java.lang.NullPointerException
pentaho | at org.pentaho.platform.repository.JcrBackedDatasourceMgmtService.init(JcrBackedDatasourceMgmtService.java:67)
pentaho | at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.retreiveObject(AbstractSpringPentahoObjectFactory.java:266)
pentaho | at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:82)
pentaho | at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:273)
pentaho | at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:137)
pentaho | at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener.getListOfDatabaseConnections(NonPooledDatasourceSystemListener.java:137)
pentaho | at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener.startup(NonPooledDatasourceSystemListener.java:53)
pentaho | at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:442)
pentaho | ... 24 more
I get this error when I set MySQL as repository:
PentahoSystem.ERROR_0014: Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener
I work with Pentaho BI Server pentaho-server-ce-7.1.0.0-12. As mentioned in some forums, the error disappeared when I have commented the line:
<bean id="dynamicallyPooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener" />
However, I can’t access with any account — even admin on the localhost — when I use that.
What can I do to solve this?
Giacomo1968
51.7k18 gold badges162 silver badges205 bronze badges
asked Dec 23, 2020 at 19:59
1
I had the same issue. I discovered that some Tomcat components were not owned by the user (pentaho) under which I am running the server.
First, I stopped the server.
Re-established ownership of my pentaho install folder and all subfolders.
sudo chown -R pentaho:pentaho *
I removed all contents under the following folder.
~/pentaho/pentaho/server/pentaho-server/tomcat/work/Catalina/localhost
The Tomcat server will rebuild these folders and content when restarted.
Restarted the Pentaho server.
Giacomo1968
51.7k18 gold badges162 silver badges205 bronze badges
answered Feb 16, 2021 at 13:47
This error can appear when jcr_user password was changed. Please follow pentaho installation documentation based on your server version to check it.
answered Apr 21, 2022 at 9:50
1
HI Friends,
I am back after a long break. In-fact a long long break.
Hope you are all fine.
While starting pentaho for the first time, if you get following error on your browser sceen,
###########################
Pentaho Initialization Exception
| The following errors were detected |
| One or more system listeners failed. These are set in the systemListeners.xml. |
| org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 – Error while trying to execute startup sequence for org.pentaho.platform.repository2.unified.BackingRepositoryLifecycleManagerSystemListener |
Please see the server console for more details on each error detected.
##################################################
Just try the below solutions,
- The Server will not run without the system database. If your logs show you a Quartz-Error, or a Hibernate error, then your HSQL database is not running. In the download, you’ll find a “data” directory. Start the “start-hypersonic.bat” before you start the main Pentaho server.
- Pentaho does not run with Java 8. There seem to be some incompatible changes in the JDK and I have not been able to actually start it up correctly. You have to use JDK 1.7 to be successful. ALso make sure that your JAVA_HOME or PENTAHO_JAVA_HOME points to the correct JDK.
- The Pentaho bat files try to locate a Java installation automatically, and without explicitly setting these environment variables, any JDK may be picked up at random. Usually that is the last JDK that has been installed or updated. So to be safe, lock down the JDK by setting these variables (via Control Panel-> System -> Advanced System Settings -> Environment Variables)
You have to check your log files for the exact error messages.
Have a nice day.
This entry was posted on June 6, 2015 at 11:53 am and is filed under Linux. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.