View Issue Details

IDProjectCategoryView StatusLast Update
0002250SymmetricDSBugpublic2015-04-08 12:12
Reporterchenson Assigned Tochenson  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.7.11 
Target Version3.7.12Fixed in Version3.7.12 
Summary0002250: Bad purge query on sybase
Description2015-04-02 11:10:02,369 INFO [server] [PurgeService] [server-job-2] Purging extract requests that are older than Sat Mar 28 10:10:02 CET 2015
2015-04-02 11:10:02,380 INFO [server] [PurgeService] [server-job-2] The outgoing purge process has completed
2015-04-02 11:10:02,382 ERROR [server] [PurgeService] [server-job-2]
org.jumpmind.db.sql.SqlException: Invalid column name 'end_batch_id'.

        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288)
        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279)
        at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:434)
        at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:299)
        at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:212)
        at org.jumpmind.symmetric.service.impl.PurgeService.purgeExtractRequests(PurgeService.java:171)
        at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:97)
        at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:73)
        at org.jumpmind.symmetric.job.OutgoingPurgeJob.doJob(OutgoingPurgeJob.java:39)
        at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:180)
        at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:224)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
        at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Invalid column name 'end_batch_id'.

        at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780)
        at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665)
        at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:295)
        at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:272)
        at com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2594)
        at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:2581)
        at com.sybase.jdbc4.jdbc.SybPreparedStatement.execute(SybPreparedStatement.java:1363)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:322)
        at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:299)
        at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:432)
        ... 17 more
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: master a8b07c52

2015-04-02 07:57:00

chenson

Details Diff
0002250: Bad purge query on sybase Affected Issues
0002250
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java Diff File

SymmetricDS: master 6761606f

2015-04-03 07:47:02

chenson

Details Diff
0002250: Bad purge query on sybase Affected Issues
0002250
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java Diff File

Issue History

Date Modified Username Field Change
2015-04-02 11:55 chenson New Issue
2015-04-02 11:55 chenson Status new => assigned
2015-04-02 11:55 chenson Assigned To => chenson
2015-04-02 12:00 chenson Changeset attached => SymmetricDS trunk r9427
2015-04-03 12:00 chenson Changeset attached => SymmetricDS trunk r9428
2015-04-08 12:12 chenson Status assigned => closed
2015-04-08 12:12 chenson Fixed in Version => 3.7.12
2015-07-31 01:49 chenson Changeset attached => SymmetricDS master 6761606f
2015-07-31 01:49 chenson Changeset attached => SymmetricDS master a8b07c52