Problem in Report Scheduling

[supunthri]

 

Hi All,

Im using JasperServer 3.5.1 Pro with MySQL 5.1 Community Edition and Tomcat 6. I have some reports scheduled at different times. but some schedules are not working, in other words, when i go to the schedule page, it says,

last run time : 22/09/2009 

Next Run Time : 23/09/2009

which means the schedule has executed but i cannot see any snapshot saved in the repository nor can i see the mail sent as i configured. I also checked under "Messages' but no error message has been posted. 

But this is random, if Schedule A works And B dsnt today, tomorow A doesnt work, but B does.

I have noticed when i restart Tomcat it solves the problem for some extend, but i have no idea how to find a solid solution for this.

My Tomcat runs as a windows service and i have configured 

Minimum Memory Pool : 512

Max Mem Pool : 1024

Thread Stack Size : blank

 

Anybody has any idea about this?

 

Thanx a lot in advance

Cheers!

[mamo]

It seems the same problem I described a few days ago (see this topic).

The JS and tomcat versions are the same.

Maybe it's  a bug in our JS version. Unfortunately, I've no idea on what to check...

[supunthri]

 Yes, its the same issue i'm facing, im getting loads of complaints from the report users and im no where how to solve this. And this keeps me busy with re running all the schedules which were not run automatically which drives me crazy. 

 

Hope i would get a reply for this soon :-s

Cheers!

[kfurness]

Has anyone learned anything useful on this issue yet?  We are experiencing the same problem using JasperServer with Tomcat and PostgreSQL.  JasperServer erroneously shows that the report has run, but the file is not there and the email was never sent.  It seems completely random, not related to a particular report, day, or time.  I ran one report hourly for 36 hours as a test; it ran all but one time (a time that normally reports have been successful). 

[lucianc]

Any exception stacktraces in the logs at the time the job was meant to run?

Regards,

Lucian

[kfurness]

Hi Lucian,

Yes, you're on it... Do you have any advice based on the error message below?  It appears that JasperServer is having intermittent trouble in connecting to it's own Mysql database.  But I don't think we have configuration problems since the reports work as often as they fail.  Any thoughts are much appreciated!

-Kellen

 

Code:

05:30:00,325 ERROR JDBCTransaction,JasperServerScheduler_Worker-1:67 - JDBC begin failedcom.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:** BEGIN NESTED EXCEPTION **java.io.EOFExceptionSTACKTRACE:java.io.EOFException        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:497)        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)        at $Proxy3.loadUserByUsername(Unknown Source)        at com.jaspersoft.jasperserver.api.engine.common.service.impl.AcegiSecurityContextProvider.setAuthenticatedUser(AcegiSecurityContextProvider.java:87)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:179)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)** END NESTED EXCEPTION **Last packet sent to the server was 30 ms ago.        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:497)        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)        at $Proxy3.loadUserByUsername(Unknown Source)        at com.jaspersoft.jasperserver.api.engine.common.service.impl.AcegiSecurityContextProvider.setAuthenticatedUser(AcegiSecurityContextProvider.java:87)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:179)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)05:30:00,385  WARN JDBCExceptionReporter,JasperServerScheduler_Worker-1:77 - SQL Error: 0, SQLState: null05:30:00,385 ERROR JDBCExceptionReporter,JasperServerScheduler_Worker-1:78 - Already closed.05:30:00,385  WARN JDBCExceptionReporter,JasperServerScheduler_Worker-1:77 - SQL Error: 0, SQLState: null05:30:00,385 ERROR JDBCExceptionReporter,JasperServerScheduler_Worker-1:78 - Already closed.05:30:00,385 ERROR JobRunShell,JasperServerScheduler_Worker-1:204 - Job ReportJobs.job_30 threw an unhandled Exception:org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin failed:Caused by:org.hibernate.TransactionException: JDBC begin failed:        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:68)        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:497)        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)        at $Proxy3.loadUserByUsername(Unknown Source)        at com.jaspersoft.jasperserver.api.engine.common.service.impl.AcegiSecurityContextProvider.setAuthenticatedUser(AcegiSecurityContextProvider.java:87)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:179)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:** BEGIN NESTED EXCEPTION **java.io.EOFExceptionSTACKTRACE:java.io.EOFException        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:497)        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)        at $Proxy3.loadUserByUsername(Unknown Source)        at com.jaspersoft.jasperserver.api.engine.common.service.impl.AcegiSecurityContextProvider.setAuthenticatedUser(AcegiSecurityContextProvider.java:87)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:179)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)** END NESTED EXCEPTION **Last packet sent to the server was 30 ms ago.        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)        ... 12 more05:30:00,395 ERROR ErrorLogger,JasperServerScheduler_Worker-1:2015 - Job (ReportJobs.job_30 threw an exception.org.quartz.SchedulerException: Job threw an unhandled exception. [see nested exception: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin failed: ]        at org.quartz.core.JobRunShell.run(JobRunShell.java:206)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)* Nested Exception (Underlying Cause) ---------------org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin failed:Caused by:org.hibernate.TransactionException: JDBC begin failed:        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:68)        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:497)        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)        at $Proxy3.loadUserByUsername(Unknown Source)        at com.jaspersoft.jasperserver.api.engine.common.service.impl.AcegiSecurityContextProvider.setAuthenticatedUser(AcegiSecurityContextProvider.java:87)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:179)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:** BEGIN NESTED EXCEPTION **java.io.EOFExceptionSTACKTRACE:java.io.EOFException        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:497)        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)        at $Proxy3.loadUserByUsername(Unknown Source)        at com.jaspersoft.jasperserver.api.engine.common.service.impl.AcegiSecurityContextProvider.setAuthenticatedUser(AcegiSecurityContextProvider.java:87)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:179)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)** END NESTED EXCEPTION **Last packet sent to the server was 30 ms ago.        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)        ... 12 more05:30:00,415 ERROR ErrorLogger,JasperServerScheduler_Worker-1:2015 - An error occured while marking executed job complete. job= 'ReportJobs.job_30'org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:** BEGIN NESTED EXCEPTION **java.io.EOFExceptionSTACKTRACE:java.io.EOFException        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)        at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1389)        at org.quartz.impl.jdbcjobstore.JobStoreCMT.triggeredJobComplete(JobStoreCMT.java:1265)        at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1490)        at org.quartz.core.JobRunShell.run(JobRunShell.java:262)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)** END NESTED EXCEPTION **Last packet sent to the server was 0 ms ago. [see nested exception: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:** BEGIN NESTED EXCEPTION **java.io.EOFExceptionSTACKTRACE:java.io.EOFException        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)        at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1389)        at org.quartz.impl.jdbcjobstore.JobStoreCMT.triggeredJobComplete(JobStoreCMT.java:1265)        at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1490)        at org.quartz.core.JobRunShell.run(JobRunShell.java:262)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)** END NESTED EXCEPTION **Last packet sent to the server was 0 ms ago.]        at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1396)        at org.quartz.impl.jdbcjobstore.JobStoreCMT.triggeredJobComplete(JobStoreCMT.java:1265)        at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1490)        at org.quartz.core.JobRunShell.run(JobRunShell.java:262)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)* Nested Exception (Underlying Cause) ---------------com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:** BEGIN NESTED EXCEPTION **java.io.EOFExceptionSTACKTRACE:java.io.EOFException        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)        at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1389)        at org.quartz.impl.jdbcjobstore.JobStoreCMT.triggeredJobComplete(JobStoreCMT.java:1265)        at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1490)        at org.quartz.core.JobRunShell.run(JobRunShell.java:262)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)** END NESTED EXCEPTION **Last packet sent to the server was 0 ms ago.        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)        at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1389)        at org.quartz.impl.jdbcjobstore.JobStoreCMT.triggeredJobComplete(JobStoreCMT.java:1265)        at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1490)        at org.quartz.core.JobRunShell.run(JobRunShell.java:262)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)[8am timestamp started here]

[lucianc]

This might happen due to stale connections in the pool.

Try to add a validation query for the container data source (this problem has been also been discussed at http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=55529)

Regards,

Lucian