PDA

View Full Version : Problem in initializing quartz



sat_1729
01-10-2006, 11:25 PM
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


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

wseyler
01-12-2006, 08:08 AM
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

sat_1729
01-13-2006, 05:27 AM
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


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

adeshazor
01-17-2006, 08:52 AM
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

jjforever
01-18-2006, 10:15 AM
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

mbatchelor
01-18-2006, 10:59 AM
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

mbatchelor
01-18-2006, 11:10 AM
Oh yeah,

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

Thanks,

Marc

jjforever
01-18-2006, 11:27 AM
when execute

http://localhost/pentaho/ViewAction?&solution=samples&path=rules&action=CurrentPositionTitles.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

jjforever
01-18-2006, 11:29 AM
add my server.xml

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

jjforever
01-18-2006, 11:38 AM
sorry, add my server.xml http://forums.pentaho.org/archived_att/files/myserver.xml

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

mbatchelor
01-18-2006, 12:18 PM
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

jjforever
01-18-2006, 12:59 PM
thanks, now already work well

artur.nascimento
12-18-2006, 08:40 AM
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.

mbatchelor
12-18-2006, 10:18 AM
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.


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]

artur.nascimento
12-18-2006, 12:05 PM
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.