Replicate Store changes task error: peform_row_lookup(...) failed to look up change data for table
I have a Replicate task running with "store changes" enabled. In the task, I have configured a table specific filter, to only include rows where language = 'EN' (See below).
Source is MS SQL server and the specific table has two columns for key:
I have enabled the task and it has been running for a few hours, but I am now getting an error, as shown below
My guess is that Replicate has to lookup another column in the table because of a long string, but has an issue with a row that contains empty value in key column 'Language'. Because I have the filter, it probably doesn't have an effect on the target, but it is quite annoying to keep receiving the error.
If my assumption is correct, is there anything I can do here ?