View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006359SymmetricDSBugpublic2024-04-24 16:422024-04-24 17:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.6Fixed in Version3.15.6 
Summary0006359: Purge of stranded data fails on Sybase ASE
DescriptionOn Sybase ASE, when purge of stranded data, it encounters an error because of a SQL statement that ends with a semi-colon.

ERROR [client-Sybase] [PurgeService] [client-Sybase-job-11] Failed to execute purge, so aborting, StackTraceKey.init [SqlException:2795550080] org.jumpmind.db.sql.SqlException: Incorrect syntax near ';'.
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308)
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297)
    at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:377)
    at org.jumpmind.db.sql.JdbcSqlTransaction.queryForObject(JdbcSqlTransaction.java:202)
    at org.jumpmind.symmetric.service.impl.DataService.getCsvDataFor(DataService.java:2849)
    at org.jumpmind.symmetric.service.impl.DataService.reCaptureData(DataService.java:3573)
    at org.jumpmind.symmetric.service.impl.DataService.reCaptureData(DataService.java:3534)
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeByMinMax(PurgeService.java:639)
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeStranded(PurgeService.java:433)
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:144)
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:105)
    at org.jumpmind.symmetric.job.OutgoingPurgeJob.doJob(OutgoingPurgeJob.java:47)
    at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:202)
    at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:268)
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
    at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:96)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
    at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: java.sql.SQLException: Incorrect syntax near ';'.
    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.queryLoop(SybStatement.java:2409)
    at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2395)
    at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:553)
    at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:329)
    at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:329)
    at org.jumpmind.db.sql.JdbcSqlTransaction$1.execute(JdbcSqlTransaction.java:221)
    at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:375)
    ... 19 more
Tagsdialect: sybase

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 6ec512d5

2024-04-24 16:45:49

admin

Details Diff 		0006359: Purge of stranded data fails on Sybase ASE Affected Issues
0006359
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

Issue History

Date Modified Username Field Change
2024-04-24 16:42 elong New Issue
2024-04-24 16:42 elong Status new => assigned
2024-04-24 16:42 elong Assigned To => elong
2024-04-24 16:42 elong Tag Attached: dialect: sybase
2024-04-24 16:46 elong Status assigned => resolved
2024-04-24 16:46 elong Resolution open => fixed
2024-04-24 16:46 elong Fixed in Version => 3.15.6
2024-04-24 17:00 admin Changeset attached => SymmetricDS 3.15 6ec512d5
2024-05-03 17:35 admin Status resolved => closed