View Issue Details

IDProjectCategoryView StatusLast Update
0003505SymmetricDSBugpublic2022-08-17 18:54
Reporterwoehrl01 Assigned To 
Prioritynormal 
Status feedbackResolutionopen 
Summary0003505: SYM_TABLE_RELOAD_REQUEST is updated via DateTime which sometimes fails due to precision mismatch
DescriptionThe updateProcessedTableReloadRequest sql in DataServiceSqlMap uses a datetime to update the row entry.

On MSSQL this always fails if the precision is less than 0.00x milliseconds.

An entry with '2018-03-26 13:45:34.680' is updated, an entry with '2018-03-26 13:45:34.673' failes, which leads to reprocessing this entry over and over again.
Steps To ReproduceUse Microsoft SQL Server

Insert a table_reload_request with a create_time value of '2018-03-26 13:45:34.673'
Tagsdata conversion

Activities

woehrl01

2018-05-08 11:25

reporter   ~0001182

see https://github.com/JumpMind/symmetric-ds/pull/89

emiller

2022-08-17 18:54

developer   ~0002169

I followed your steps to reproduce this issue using SymmetricDS 3.14.0 and SQL Server 2019 and the load completed without fail. It's possible that this issue has already been resolved since SymmetricDS 3.9.

Can you upgrade to the latest version of SymmetricDS and see if you still encounter this issue? If you still experience it, are there any additional details you can provide to help me reproduce the issue?

Related Changesets

SymmetricDS: 3.9 30983763

2018-05-08 12:32:31

mmichalek

Details Diff
0003505: Throw error if it can't update a table_reload_request Affected Issues
0003505
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

Issue History

Date Modified Username Field Change
2018-03-26 13:25 woehrl01 New Issue
2018-05-08 11:25 woehrl01 Note Added: 0001182
2018-05-08 17:00 mmichalek Changeset attached => SymmetricDS 3.9 30983763
2019-04-24 17:41 elong Tag Attached: runtime
2020-09-03 12:56 admin Tag Detached: runtime
2022-08-02 19:36 elong Tag Attached: data conversion
2022-08-17 18:54 emiller Note Added: 0002169
2022-08-17 18:54 emiller Status new => feedback