US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: Pentaho 4.5 wit Postgres - qrtz_triggers does not exist

  1. #1
    Join Date
    May 2012
    Posts
    6

    Default Pentaho 4.5 wit Postgres - qrtz_triggers does not exist

    Dear all,

    I want to upgrade from the former bi-server to version 4.5, because I need some of the bug fixes. However, I cannot manage to get 4.5 running with my postgres DB.

    I've changed context.xml and pentaho.xml accordingly:
    <?xml version="1.0" encoding="UTF-8"?>
    <Context path="/pentaho" docbase="webapps/pentaho/">
    <Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="hibuser" password="password" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/hibernate" validationQuery="select 1"/>

    <Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="pentaho_user" password="password" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/quartz" validationQuery="select 1"/>
    </Context>



    However, on startup, the server complaints, that the relation qrtz_triggers does not exist. I even dropped the quartz database, and re-generated it with the create_quartz_postgresql.sql script, but that also didn't help. I'm very grateful for any hint, because I think the new version looks great, and I'd love to use it.

    Below, you find the whole output of the startup process. Please let me know, if I can provide you with more info. Thank you very much!

    31.05.2012 17:09:39 org.apache.catalina.core.AprLifecycleListener init
    INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.6.0_31\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\AMD APP\bin\x86_64;C:\Program Files (x86)\AMD APP\bin\x86;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\W
    indowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\PostgreSQL\9.1\bin;C:\pentaho\data-integration;C:\Program Files\TortoiseSVN\bin;.
    31.05.2012 17:09:40 org.apache.coyote.http11.Http11Protocol init
    INFO: Initializing Coyote HTTP/1.1 on http-8080
    31.05.2012 17:09:40 org.apache.catalina.startup.Catalina load
    INFO: Initialization processed in 530 ms
    31.05.2012 17:09:40 org.apache.catalina.core.StandardService start
    INFO: Starting service Catalina
    31.05.2012 17:09:40 org.apache.catalina.core.StandardEngine start
    INFO: Starting Servlet Engine: Apache Tomcat/6.0.29
    31.05.2012 17:09:40 org.apache.catalina.startup.HostConfig deployDescriptor
    INFO: Deploying configuration descriptor pentaho.xml
    31.05.2012 17:09:41 org.apache.catalina.startup.ContextConfig validateSecurityRoles
    INFO: WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint> without being defined in a <security-role>
    17:09:50,941 WARN [PackageManager] Unresolved dependency for package: org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaModule
    17:09:51,019 WARN [PackageSorter] A dependent module was not found in the list of known modules.
    17:09:55,675 ERROR [Logger] misc-org.pentaho.platform.scheduler.QuartzSystemListener: QuartzSystemListener.ERROR_0001 - Scheduler wurde beim Start nicht initialisiert.
    org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: FEHLER: Relation ╗qrtz_triggers½ existiert nicht
    Position: 41 [See nested exception: org.postgresql.util.PSQLException: FEHLER: Relation ╗qrtz_triggers½ existiert nicht
    Position: 41]]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493)
    at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68)
    at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010)
    at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152)
    at org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSystemListener.java:112)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:342)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208)
    at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
    at org.apache.catalina.core.StandardService.start(StandardService.java:519)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
    * Nested Exception (Underlying Cause) ---------------
    org.quartz.JobPersistenceException: Couldn't clean volatile data: FEHLER: Relation ╗qrtz_triggers½ existiert nicht
    Position: 41 [See nested exception: org.postgresql.util.PSQLException: FEHLER: Relation ╗qrtz_triggers½ existiert nicht
    Position: 41]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:642)
    at org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(JobStoreTX.java:116)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:491)
    at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68)
    at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010)
    at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152)
    at org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSystemListener.java:112)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:342)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208)
    at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
    at org.apache.catalina.core.StandardService.start(StandardService.java:519)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

    ...

    31.05.2012 17:09:57 org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory pentaho-style
    31.05.2012 17:09:57 org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory ROOT
    31.05.2012 17:09:57 org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory sw-style
    31.05.2012 17:09:57 org.apache.coyote.http11.Http11Protocol start
    INFO: Starting Coyote HTTP/1.1 on http-8080
    31.05.2012 17:09:57 org.apache.jk.common.ChannelSocket init
    INFO: JK: ajp13 listening on /0.0.0.0:8009
    31.05.2012 17:09:57 org.apache.jk.server.JkMain start
    INFO: Jk running ID=0 time=0/47 config=null
    31.05.2012 17:09:57 org.apache.catalina.startup.Catalina start
    INFO: Server startup in 17725 ms

  2. #2
    Join Date
    May 2012
    Posts
    6

    Default

    I've found a workaround for my problem: in systemListeners.xml I've removed the Quartz Listener, now I can start and use the BI Server 4.5.
    Maybe the bug is related to another issue I've found here http://forums.pentaho.com/showthread...an-I-report-it where postgresql.hibernate.cfg.xml is not found by the admin console.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •