Message in event log “Any out-of-sync statuses for "OWNER"."TABLE_NAME" would not be cleared due to a subset of the table was processed [sp_declt] [module deq]” (4298702)

Message in event log “Any out-of-sync statuses for "OWNER"."TABLE_NAME" would not be cleared due to a subset of the table was processed [sp_declt] [module deq]”

The following message shows up in event log on source/target when a repair is run with a “where” clause:

Any out-of-sync statuses for "OWNER"."TABLE_NAME" would not be cleared due to a subset of the table was processed  [sp_declt] [module deq]

Only a subset of the table is being repaired  

This message is for information and is conveying to us that the table may or may not have been completely resynchronized. Here is the logic behind this. When you find out of sync on a table and run repair with a “where” clause to fix them, SharePlex fixes those rows but the fact is, the rows are a subset of the complete table. Hence SharePlex cannot conclude that the table is in sync. So it does not remove the out of sync entry for this table from the statusdb (the status database that keeps track of the out of sync on a table, among others). If the complete table was repaired, then such message would not show up in event log and SharePlex will remove the out of sync entry from the statusdb file. 

Please refer to our Knowledgebase article # 64398 for details on how to manually remove out of sync entry from statusdb file. For details on the statusdb, please refer to SharePlex Reference Guide.