I'm database developer. For one of the MS SQL project we testing SQL Service Broker replication. Basically we need to replicate table changes from multiple initiators to one target.
We implemented environment according to the article:
When we setup 1 initiator - it works fine, messages are sent and processed . But when we configure second initiator, it sends only the first message, which is preserved in sys.transmission_queue () and all new messages just sit in sys.transmission_queue without processing. No transmission errors is in sys.transmission_queue on 2-nd initiator. It seems that acknowledgment about message delivery and processing on target can't reach 2-nd initiator.
1-st initiator uses service like tcp://192.168.2.130:4022/vpiCore/Audit/DataSender
2-nd initiator uses service tcp://192.168.2.116:4022/vpiCore/Audit/DataSender
Route on target is configured as TRANSPORT
Could you help us to resolve the problem, any feedback is highly appreciated, especially GOOD EXAMPLE or link