Hello,
I am looking to run this as well, are you saying that sp_mergemetadataretentioncleanup needs to be run on the subscriber first and then the publisher to avoid any issues?
You mentioned you shortened the retention period first, is this a must do? Does it not clean up much (or anything ) if this is not done first?
Regards,
D.