Some Immediate/Scheduled/Delayed Replication Transactions Not Starting

If some replications do not start, and they are due to run based on the Not Before value, either the file is most likely claimed, or the replication thread has not yet run following passing the Not Before date/time, or another transaction is in the ‘pending’ (executing) state for that file during this replication iteration.

Also, keep in mind the values chosen for max_batch and max_pending. No more than the max_batch count of transaction records are initiated in one thread cycle, and no more than max_pending transactions run at once, so several iterations over a period of time may be necessary to clear the transactions in queue.

If the replication transaction(s) not starting have a filter method set, check that the filter method is returning a result. If it is not returning a result, or errors out or returns an error, the replication transactions using that filter method remains in the queue. You may use the ‘Check syntax’ button when editing the method, add statements to activate debugging, or temporarily remove the filter method from the replication rule to determine if the problem is due to the method.