Pentaho

View Only

SQLError 7 and PENTAHO_ERROR 14

Sebastian Wierzbicki posted 10-22-2018 12:05

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

Hello!@I am setting up pentaho 8.1 CE version thorugh manual installation and i've met with the problem that i dont know how to solve, pentaho.log. I also attach all the files i've made modifications in.If anyone could check what i configured wrong that would be great.2018-10-22 13:47:24,774 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.2018-10-22 13:47:26,065 INFO [org.pentaho.platform.osgi.OSGIBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled2018-10-22 13:47:26,409 INFO [org.pentaho.platform.osgi.KarafInstance] ********************************************************************************** Karaf Instance Number: 1 at /home/pentaho/server/pentaho-server/tomcat/ ****** temp/karaf5887786072082003774/caches/default/data-1 ****** Karaf Port:8802 ****** OSGI Service Port:9051 ****** JMX RMI Registry Port:11099 ****** RMI Server Port:44445 **********************************************************************************2018-10-22 13:47:27,976 ERROR [org.pentaho.platform.plugin.action.kettle.KettleSystemListener] DI_HOME System Property not properly set. The default location of /home/pentaho/server/pentaho-server/pentaho-solutions/system/kettle will be used.2018-10-22 13:47:28,508 DEBUG [org.pentaho.di.core.vfs.ConcurrentFileSystemManager] Using "/home/pentaho/server/pentaho-server/tomcat/temp/vfs_cache" as temporary files store.2018-10-22 13:47:28,643 DEBUG [org.pentaho.di.core.vfs.ConcurrentFileSystemManager] Skipping provider "org.apache.commons.vfs2.provider.webdav.WebdavFileProvider" because required class "org.apache.jackrabbit.webdav.client.methods.DavMethod" is not available.2018-10-22 13:47:54,780 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.2018-10-22 13:48:24,782 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.2018-10-22 13:48:52,548 ERROR [org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener] EmbeddedQuartzSystemListener.ERROR_0007_SQLERRORorg.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.postgresql.jdbcDriver'at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)at org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener.verifyQuartzIsConfigured(EmbeddedQuartzSystemListener.java:162)at org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener.startup(EmbeddedQuartzSystemListener.java:104)at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:450)at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:441)at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:420)at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:441)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:372)at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:369)at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:420)at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:369)at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:339)at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:235)at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:165)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.deployWAR(HostConfig.java:985)at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)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: java.lang.ClassNotFoundException: org.postgresql.jdbcDriverat org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1309)at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1137)at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)... 29 more2018-10-22 13:48:52,552 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho2018-10-22 13:48:52,552 ERROR [org.pentaho.platform.util.logging.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.scheduler2.quartz.EmbeddedQuartzSystemListenerorg.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.scheduler2.quartz.EmbeddedQuartzSystemListenerat org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:377)at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:339)at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:235)at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:165)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.deployWAR(HostConfig.java:985)at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)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 - Error while trying to execute startup sequence for org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListenerat org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:459)at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:441)at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:420)at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:441)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:372)at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:369)at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:420)at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:369)... 16 moreCaused by: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListenerat org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:451)... 24 more2018-10-22 13:48:52,553 ERROR [org.pentaho.platform.util.logging.Logger] Error end:2018-10-22 13:48:52,553 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Warning, one or more errors occurred during the initialization process.2018-10-22 13:48:53,996 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Warning, one or more errors occurred during the initialization process.2018-10-22 13:48:57,209 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Warning, o...
#Pentaho

Attachments View in library

SQLError 7 and PENTAHO_ERROR 14 1 KB

SQLError 7 and PENTAHO_ERROR 14 3 KB

SQLError 7 and PENTAHO_ERROR 14 688 B

SQLError 7 and PENTAHO_ERROR 14 23 KB

SQLError 7 and PENTAHO_ERROR 14 8 KB

SQLError 7 and PENTAHO_ERROR 14 621 B

Ana Gonzalez posted 10-23-2018 09:21

It seems like you have configured the Pentaho installation to use a PostgreSQL database instead of the default database, but you haven't upload the PostgreSQL JDBC driver (it doesn't come with the Pentaho installation, you have to download it from the PostgreSQL oficial site and put it in the JDBC drivers directory: <pentaho-install-directory>/server/biserver-ee/tomcat/lib.

Regards

Sebastian Wierzbicki posted 10-23-2018 18:35

Hello Ana,

i am using JAVA 8 and downloaded the PostgreSQL JDBC Download 42.2.5. before and I included it in the tomcat/lib and also in WEB-INF/lib. But the problem appeared anyway and this is not the solution, other ideas?