View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003505 | SymmetricDS | Bug | public | 2018-03-26 09:25 | 2018-05-08 13:00 |
Reporter | woehrl01 | Assigned To | |||
Priority | normal | ||||
Status | new | Resolution | open | ||
Product Version | |||||
Target Version | Fixed in Version | ||||
Summary | 0003505: SYM_TABLE_RELOAD_REQUEST is updated via DateTime which sometimes fails due to precision mismatch | ||||
Description | The 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 Reproduce | Use Microsoft SQL Server Insert a table_reload_request with a create_time value of '2018-03-26 13:45:34.673' | ||||