Duplicate messages in CHANGES ONLY query and compare mode

If you receive duplicate messages in CHANGES ONLY query and compare mode, the most likely cause is that the query interval you have set is too short for the scope of your query. To diagnose, increase your query interval significantly and see if the duplicates no longer occur.

If you absolutely require a short query interval you can rewrite your query to include fewer results (e.g. restricting only to user objects) and/or split your query across multiple receive locations that handle different subsets of results (e.g. cn filtered A-K on one receive location and L-Z on another).

FAQs
Can I use the ActiveADAPTER Send Adapter with dynamic send ports?

Yes. The Send Adapter is fully compatible with dynamic ports.

A sample orchestration showing the use of ActiveADAPTER with dynamic send ports is included in the ActiveADAPTER\Samples folder.

See the entire answer

What versions of Microsoft BizTalk Server does ActiveADAPTER support?

Microsoft BizTalk Server 2013 R2 to 2020.

We also have legacy versions back to 2006 R2.

See the entire answer

What transactional strategy does the ActiveADAPTER Send Adapter use?

The Send Adapter commits changes per message and per object. This means commits cannot span messages. Within a message, changes to an object are all committed together. To ensure changes are all or nothing, therefore, the strategy you need to use is one message per object.

See the entire answer