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
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

Do you supply the schemas I will need?

Absolutely. A link to them is installed to the Programs menu in the ActiveADAPTER\Schemas 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