Hello,

I found a bug in TimeXtender Discovery Hub: When using both the features "Use hard deletes" and "Keep field values up-to-date", certain lines are not deleted, although they disappear in the source table.

The following code gets generated to handle the delete process:

DELETE V 
FROM [dbo].[f_data] V 
WHERE 
  NOT EXISTS ( 
    SELECT TOP 1 1 
    FROM [dbo].[f_data_PK] P 
    WHERE 
    P.[id] = V.[id] 
  ) 
  AND NOT EXISTS ( 
    SELECT TOP 1 1 
    FROM [dbo].[f_data_R] R 
    WHERE 
    R.[id] = V.[id] 
  )

This works correctly without the "Keep field-values up-to-date" feature. All rows that are not in the _PK table and that are not in the _R table get deleted. But there are rows that get updated by the "Keep field-values up-to-date" and land in the _R table, although they are not in the source table. This is why they  don't get deleted.