View Issue Details

IDProjectCategoryView StatusLast Update
0003505SymmetricDSBugpublic2020-09-03 12:56
Reporterwoehrl01 Assigned To 
Status newResolutionopen 
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'
TagsNo tags attached.


Related Changesets

SymmetricDS: 3.9 30983763

2018-05-08 12:32:31


Details Diff
0003505: Throw error if it can't update a table_reload_request Affected Issues
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/ 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