Hitachi Vantara Pentaho Community Forums
Results 1 to 15 of 15

Thread: Problem in initializing quartz

  1. #1
    Join Date
    Sep 2005
    Posts
    22

    Default Problem in initializing quartz

    hi

    I am trying to deploy pantao-1.0.0.0 in tomcat

    I am concentrating basically on

    * Reports [ BIRT ]
    * Mail Component
    * Scheduler
    After deploying my appliation is working fine with the first two services of pentaho . But while gofor scheduler i am getting a problem in initializing the Quartz System

    I am having the pentaho-data as the sibling of the tomcat
    and starting its service seperately .
    I am getting the following error on the console on startUp

    Code:
    org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null']]
            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.scheduler.QuartzSystemListener.startup(Unknown Source)
            at org.pentaho.system.PentahoSystem.init(Unknown Source)
            at org.pentaho.system.SolutionContextListener.contextInitialized(Unknown Source)
            at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3773)
            at org.apache.catalina.core.StandardContext.start(StandardContext.java:4270)
            at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
            at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:850)
            at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:638)
            at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:320)
            at org.apache.catalina.core.StandardHost.install(StandardHost.java:875)
            at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:727)
            at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:477)
            at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1008)
            at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:394)
            at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1134)
            at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)
            at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
            at org.apache.catalina.core.StandardService.start(StandardService.java:519)
            at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
            at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
            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:585)
            at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
            at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
    * Nested Exception (Underlying Cause) ---------------
    org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null']
            at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:570)
            at org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(JobStoreTX.java:107)
            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.scheduler.QuartzSystemListener.startup(Unknown Source)
            at org.pentaho.system.PentahoSystem.init(Unknown Source)
            at org.pentaho.system.SolutionContextListener.contextInitialized(Unknown Source)
            at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3773)
            at org.apache.catalina.core.StandardContext.start(StandardContext.java:4270)
            at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
            at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:850)
            at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:638)
            at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:320)
            at org.apache.catalina.core.StandardHost.install(StandardHost.java:875)
            at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:727)
            at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:477)
            at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1008)
            at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:394)
            at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1134)
            at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)
            at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
            at org.apache.catalina.core.StandardService.start(StandardService.java:519)
            at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
            at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
            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:585)
            at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
            at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
    * Nested Exception (Underlying Cause) ---------------
    java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
            at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)
            at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111)
            at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553)
            at org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(JobStoreTX.java:107)
            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.scheduler.QuartzSystemListener.startup(Unknown Source)
            at org.pentaho.system.PentahoSystem.init(Unknown Source)
            at org.pentaho.system.SolutionContextListener.contextInitialized(Unknown Source)
            at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3773)
            at org.apache.catalina.core.StandardContext.start(StandardContext.java:4270)
            at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
            at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:850)
            at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:638)
            at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:320)
            at org.apache.catalina.core.StandardHost.install(StandardHost.java:875)
            at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:727)
            at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:477)
            at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1008)
            at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:394)
            at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1134)
            at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)
            at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
            at org.apache.catalina.core.StandardService.start(StandardService.java:519)
            at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
            at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
            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:585)
            at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
            at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
    12:46:11,608 ERROR [Logger] misc-org.pentaho.system.PentahoSystem: Error while trying to execute startup sequence for {0}org.pentaho.scheduler.QuartzSystemListener
    Pentaho BI Platform server is ready. (1.0.0.0-156)
    And while running the appliation i am getting the problem that [ unable to get the instance of the scheduler ]

    regards,
    siva

    Post edited by: sat_1729, at: 01/11/2006 03:30

  2. #2
    Join Date
    Jun 2005
    Posts
    115

    Default Re:Problem in initializing quartz

    Hi Siva,

    It appears as if the quartz datasource did not restart. Can you verify that it is running. If you're using the Preconfigured Install then you should see a console window and be able to verify that hypersonic has started the quartz database.

    Let me know how it goes.

    Bill

  3. #3
    Join Date
    Sep 2005
    Posts
    22

    Default Re:Problem in initializing quartz

    hi

    I am not using pre-configured installation now.
    I am trying to deploy it in the tomcat server

    then
    I have started the database seperatetly and
    its runnng fine , u can see

    Code:
    user15@ubuntu-test:~/workbench/research/pentaho-data$ ./start_hypersonic.sh
    [Server@1a758cb]: [Thread[main,5,main]]: checkRunning(false) entered
    [Server@1a758cb]: [Thread[main,5,main]]: checkRunning(false) exited
    [Server@1a758cb]: Startup sequence initiated from main() method
    [Server@1a758cb]: Loaded properties from [/home/user15/workbench/research/pentaho-data/server.properties]
    [Server@1a758cb]: Initiating startup sequence...
    [Server@1a758cb]: Server socket opened successfully in 10 ms.
    [Server@1a758cb]: Database [index=0, id=0, db=file:«»sampledata/sampledata, alias=sampledata] opened sucessfully in 1725 ms.
    [Server@1a758cb]: Database [index=1, id=1, db=file:«»shark/shark, alias=shark] opened sucessfully in 223 ms.
    [Server@1a758cb]: Database [index=2, id=2, db=file:hibernate/hibernate, alias=hibernate] opened sucessfully in 975 ms.
    [Server@1a758cb]: Database [index=3, id=3, db=file:quartz/quartz, alias=quartz] opened sucessfully in 168 ms.
    [Server@1a758cb]: Startup sequence completed in 3237 ms.
    [Server@1a758cb]: 2006-01-13 14:54:58.737 HSQLDB server 1.8.0 is online
    [Server@1a758cb]: To close normally, connect and execute SHUTDOWN SQL
    [Server@1a758cb]: From command line, use [Ctrl]+[C] to abort abruptly
    Is there any issues in 'where the pentaho-data folder resides ???'

    Let me know is there any issues with what i am having now .

    regards,
    siva

  4. #4
    Join Date
    Nov 2005
    Posts
    178

    Default Re:Problem in initializing quartz

    Siva,

    The orignal stack trace would indicate there is an issue with the definition of the JNDI resource for Quartz. Can you ensure the server.xml of Tomcat 5 has been properly updated as described in the Advanced install guide? Also, what version of Tomcat are you using?

    Anthony

  5. #5
    Join Date
    Jan 2006
    Posts
    5

    Default Re:Problem in initializing quartz

    hi

    my problem is similar

    i have tomcat 5.0.28

    attach server.xml and web.xml

    structure web is

    c:/tomcat/webapps/pentaho/
    c:/tomcat/webapps/pentaho-style/

    copy in c:

    pentaho-data
    pentaho-solutions

    thanks for answers

    http://forums.pentaho.org/archived_att/files/web.xml http://forums.pentaho.org/archived_att/files/web.xml

  6. #6
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Problem in initializing quartz

    Hi,

    It looks like you posted the web.xml twice instead of posting your server.xml. Please post the server.xml when you get a chance.

    Thanks,

    Marc

  7. #7
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Problem in initializing quartz

    Oh yeah,

    In addition to your server.xml, could you also please post the servers' error log?

    Thanks,

    Marc

  8. #8
    Join Date
    Jan 2006
    Posts
    5

    Default Re:Problem in initializing quartz

    when execute

    http://localhost/pentaho/ViewAction?...Titles.xaction

    i obtain

    [es_72] Error: [es_103] ConnectFactory.ERROR_0001 - [es_1] Database connection could not be established to: SampleData (org.pentaho.component.SQLLookupRule)
    [es_69] Debug: [es_21] Starting execute of samples/rules/CurrentPositionTitles.xaction (org.pentaho.solution.SolutionEngine)
    [es_69] Debug: [es_30] Getting runtime context and data (org.pentaho.solution.SolutionEngine)
    [es_69] Debug: [es_33] Loading action sequence definition file (org.pentaho.solution.SolutionEngine)
    [es_69] Debug: [es_34] audit: instanceId=1740a5f2-8843-11da-b136-1524c871d679, objectId=org.pentaho.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.runtime.RuntimeContext)
    [es_69] Debug: [es_1] validateComponent validating component org.pentaho.component.SQLLookupRule (org.pentaho.runtime.RuntimeContext)
    [es_69] Debug: [es_75] Validating component for action CurrentPositionTitles.xaction (org.pentaho.component.SQLLookupRule)
    [es_69] Debug: [es_42] Executing action sequence (org.pentaho.runtime.RuntimeContext)
    [es_69] Debug: [es_24] Executing action definition: Iteration {0}0 (org.pentaho.runtime.RuntimeContext)
    [es_69] Debug: [es_34] audit: instanceId=1740a5f2-8843-11da-b136-1524c871d679, objectId=org.pentaho.component.SQLLookupRule, messageType=component_execution_started (org.pentaho.runtime.RuntimeContext)
    [es_69] Debug: [es_3] execute pre-audit (org.pentaho.runtime.RuntimeContext)
    [es_69] Debug: [es_21] Setting component log level to DEBUG (org.pentaho.runtime.RuntimeContext)
    [es_69] Debug: [es_11] Initializing component (org.pentaho.runtime.RuntimeContext)
    [es_69] Debug: [es_4] executeComponent starting audited execute (org.pentaho.runtime.RuntimeContext)
    [es_69] Debug: [es_94] execute validation=true (org.pentaho.component.SQLLookupRule)
    [es_72] Error: [es_103] ConnectFactory.ERROR_0001 - [es_1] Database connection could not be established to: SampleData (org.pentaho.component.SQLLookupRule)
    [es_69] Debug: [es_136] Running query - select distinct PositionTitle from quadrant_actuals where department='Product Development' order by PositionTitle (org.pentaho.component.SQLLookupRule)
    [es_72] Error: [es_103] SQLBaseComponent.ERROR_0006 - [es_122] Could not execute CurrentPositionTitles.xaction (org.pentaho.component.SQLLookupRule)
    [es_69] Debug: [es_15] executeComponent finished audited execute (org.pentaho.runtime.RuntimeContext)
    [es_72] Error: [es_103] RuntimeContext.ERROR_0012 - [es_33] ActionDefinition for org.pentaho.component.SQLLookupRule did not execute successfully (org.pentaho.runtime.RuntimeContext)
    [es_72] Error: [es_103] SolutionEngine.ERROR_0007 - [es_27] Action sequence execution failed (org.pentaho.solution.SolutionEngine)

    Post edited by: jjforever, at: 01/18/2006 15:30

  9. #9
    Join Date
    Jan 2006
    Posts
    5

    Default Re:Problem in initializing quartz

    add my server.xml

    Post edited by: jjforever, at: 01/18/2006 15:36

  10. #10
    Join Date
    Jan 2006
    Posts
    5

    Default Re:Problem in initializing quartz

    sorry, add my server.xml http://forums.pentaho.org/archived_a...s/myserver.xml

    Post edited by: jjforever, at: 01/18/2006 15:39

  11. #11
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Problem in initializing quartz

    Now the problem is clear. The problem is in your server.xml. The DefaultContext may only appear inside the <Host> tag. The solution is to remove your whole <DefaultContext> tag, go to the bottom, and paste it in just above the close of the Host tag (just above </Host>).

    Edit: Remove code tags to aid readability.

    Post edited by: mbatchelor, at: 01/18/2006 16:20

  12. #12
    Join Date
    Jan 2006
    Posts
    5

    Default Re:Problem in initializing quartz

    thanks, now already work well

  13. #13

    Default Tomcat Deployments

    I tryed to use the tomcat with pentaho. I read the advanced configuration to build a war file because I don't want to use the examples that is in the pre-configurate install... I build the war file, edit the server.xml, copy my lib on the directory: /tomcat 5.0/common/lib ... So, when I start the tomcat, the Pentaho's Home page apears, but when I try to use execute a xaction file this error happens:


    type Exception report

    message

    description The server encountered an internal error () that prevented it from fulfilling this request.

    exception

    javax.servlet.ServletException: Servlet execution threw an exception
    org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)

    root cause

    java.lang.ExceptionInInitializerError
    org.pentaho.repository.HibernateUtil.initialize(HibernateUtil.java:153)
    org.pentaho.repository.HibernateUtil.<clinit>(HibernateUtil.java:81)
    org.pentaho.repository.runtime.RuntimeRepository.setSession(RuntimeRepository.java:74)
    org.pentaho.core.system.PentahoSystem.getRuntimeRepository(PentahoSystem.java:942)
    org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:178)
    org.pentaho.core.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:140)
    org.pentaho.ui.servlet.ViewAction.doGet(ViewAction.java:153)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)

    note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

    I attached the log.

    Please, can everyone help me?

    Thank's.

    Artur.
    Attached Files Attached Files

  14. #14
    Join Date
    Nov 1999
    Posts
    579

    Default

    Based on the message in the stdout.log, Quartz is not bound to your context. This is often because the server.xml hasn't been set up correctly with the JNDI datasource for Quartz. Posting your server.xml would help diagnosing, but also double-checking that you've defined the datasources in the server.xml properly would probably help.

    Code:
    org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'Quartz' javax.naming.NameNotFoundException: Name Quartz is not bound in this Context [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'Quartz' javax.naming.NameNotFoundException: Name Quartz is not bound in this Context]

  15. #15

    Default Tomcat Deployments ( continue ...)

    Thank's mbatchelor for help me. I don't known where can I put this code in the server.xml:

    ...
    <DefaultContext>
    <Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource"/>
    ....
    </DefaultContext>
    ...

    Really, I want to do my connection with Informix, so I delete all examples and olny want to put my xaction files in the pentaho. So, when I delete all examples (folders: samples, test... on the pentaho-solutions) something calls the Quartz example, so an error happens. I started the hipersonic database and modify the server.xml but this happens now:

    "Datasource java:comp/env/jdbc/dwdprf is not configured properly"

    I think that the JNDI isn't correct. I put the ifxjdbc.jar and the hsqldb.jar files in the common/lib but the Tomcat don't find the drivers and the JNDI configurations.

    I attached the log and the server.xml files.

    Thank's,

    Artur.
    Attached Files Attached Files

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.