delete the service from ESB Conductor ,it got the error

_AnonymousUser — Sat, 16 Nov 2024 10:18:10 GMT

Delete Failed: org.quartz.SchedulerConfigException: Failure occured during job recovery. ] -- For more information see your log file

Re: delete the service from ESB Conductor ,it got the error

Anonymous — Tue, 25 Oct 2016 04:14:04 GMT

Hi,
Is there any more error message in your TAC log?
Could you please indicate on which build version you got this issue?
Best regards
Sabrina

Re: delete the service from ESB Conductor ,it got the error

_AnonymousUser — Tue, 25 Oct 2016 05:51:34 GMT

Hi,
Is there any more error message in your TAC log?
Could you please indicate on which build version you got this issue?
Best regards
Sabrina

Hi,xdshi
talend version 5.6.1 on linux
Caused by: org.quartz.JobPersistenceException: Couldn't clean volatile data: Table 'talend562.qrtz_triggers' doesn't exist
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:786)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.execute(JobStoreSupport.java:747)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:3708)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3704)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:743)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:601)
... 41 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'talend562.qrtz_triggers' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2324)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectVolatileTriggers(StdJDBCDelegate.java:3491)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:764)
... 47 more

Re: delete the service from ESB Conductor ,it got the error

Anonymous — Tue, 25 Oct 2016 08:11:51 GMT

Hi,
Have you already checked your DB to see if the table " talend562.qrtz_triggers " exists?
Could you please report a ticket on talend support portal so that we can give you a remote assistance on your issue through support cycle with priority?
Best regards
Sabrina

topic Re: delete the service from ESB Conductor ,it got the error in Talend Studio

delete the service from ESB Conductor ,it got the error

Re: delete the service from ESB Conductor ,it got the error

Re: delete the service from ESB Conductor ,it got the error

Re: delete the service from ESB Conductor ,it got the error