org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'purge' on target class [class org.jasig.portal.events.handlers.db.ExpiredEventsPurger] failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [DELETE FROM stats_render_time srt WHERE srt.event_id IN (SELECT se.id FROM stats_event se WHERE se.act_date < ?)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'srt WHERE srt.event_id IN (SELECT se.id FROM stats_event se WHERE se.act_date < ' at line 1

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Apereo Issues by Steve Swinsburg, 1 year ago
stats_render_time srt WHERE srt.event_id IN (SELECT se.id FROM stats_event se WHERE se.act_date < ?)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to
via Apereo Issues by Steve Swinsburg, 1 year ago
stats_render_time srt WHERE srt.event_id IN (SELECT se.id FROM stats_event se WHERE se.act_date < ?)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to
via Stack Overflow by Nithin Bharathwaj
, 1 year ago
Invocation of method 'execute' on target class [class deshaw.munshi.reconcilers.position.price.PriceDriver] failed; nested exception is org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT into
via broadleafcommerce.org by Unknown author, 2 years ago
Invocation of method 'rebuildIndex' on target class [class org.broadleafcommerce.core.search.service.solr.SolrSearchServiceImpl] failed; nested exception is org.broadleafcommerce.common.exception.ServiceException: Could not delete documents
via openmicroscopy.org by Unknown author, 2 years ago
Invocation of method 'run' on target class [class ome.services.fulltext.FullTextThread] failed; nested exception is java.lang.IllegalStateException: The SessionCache Cache is not alive.
via Google Groups by yo yo, 10 months ago
Invocation of method 'doIt' on target class [class org.openmeetings.app.quartz.scheduler.MeetingReminderJob] failed; nested exception is java.lang.VerifyError: Expecting a stackmap frame at branch target 70 in method org.openmeetings.app.persistence.beans.user.UserContacts.<clinit>()V at offset 61
org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'purge' on target class [class org.jasig.portal.events.handlers.db.ExpiredEventsPurger] failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [DELETE FROM stats_render_time srt WHERE srt.event_id IN (SELECT se.id FROM stats_event se WHERE se.act_date < ?)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'srt WHERE srt.event_id IN (SELECT se.id FROM stats_event se WHERE se.act_date < ' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858)
at org.jasig.portal.events.handlers.db.ExpiredEventsPurger.purge(ExpiredEventsPurger.java:97)
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.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:260)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

Users with the same issue

Samebug visitor profile picture
Unknown user
2 times, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Once, 1 year ago
123 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.