View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006145SymmetricDSBugpublic2023-12-04 21:062023-12-05 14:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.2Fixed in Version3.15.2 
Summary0006145: Purge fails with incorrect syntax near 'd' on SQL Server
DescriptionPurge fails with incorrect syntax near 'd' on SQL Server. Alias of table on delete is not allowed using ANSI syntax, but the table name can be used instead.

Failed to execute purge, but will try again, StackTraceKey.init [SqlException:1020700532] org.jumpmind.db.sql.SqlException: Incorrect syntax near 'd'.
    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.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
    at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:357)
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeByMinMax(PurgeService.java:650)
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeDataRows(PurgeService.java:407)
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:140)
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:97)
    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:833)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'd'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1676)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:615)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:537)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7785)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3793)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:515)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
    at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:386)
    at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:357)
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:499)
    ... 16 more
Tagspurge

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 d18f80c2

2023-12-05 13:18:01

admin

Details Diff 		0006145: Purge fails with incorrect syntax near 'd' on SQL Server Affected Issues
0006145
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java Diff File

Issue History

Date Modified Username Field Change
2023-12-04 21:06 elong New Issue
2023-12-04 21:06 elong Status new => assigned
2023-12-04 21:06 elong Assigned To => elong
2023-12-04 21:06 elong Tag Attached: purge
2023-12-04 21:07 elong Project SymmetricDS Pro => SymmetricDS
2023-12-05 13:18 elong Status assigned => resolved
2023-12-05 13:18 elong Resolution open => fixed
2023-12-05 13:18 elong Fixed in Version => 3.15.2
2023-12-05 14:00 admin Changeset attached => SymmetricDS 3.15 d18f80c2
2023-12-16 02:02 admin Status resolved => closed