I dont know the cause of this like many SQL unaswered issues , but good part figured the solution 🙂

Nothing tricky , found the xact_seqno from sp_browsereplcmds

1. Checked both the publisher and subscriber has the Ms_upd_XXXX data .

2. Removed the entry from ms_rep_commands table .

3. No sure if that helped much .

4. Removed the article from the Publication .

5 . Added back , ran snapshot for the single article .

Old method but issue was something new for me .