This exact question recently came up for me as well. Does anyone have any additional information on this subject?

First question, did replication fail for the 2 subscriptions with the missing records?

Interesting problem. I don't have any firsthand knowledge on this subject but I'll be watching this thread to see what help others can provide. Good question.

There is a way to set up a replicated archive using transactional replication in which you can actively trim or "prune" (as we like to call it in our shop)...

We had an issue with this today at work as well. Does anyone happen to know if there is any specific cause for this error? It just seems odd to...