Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Duplicates sometimes created within a Fetch block

Charles Spring

Recommended Posts

My map both reads and writes from Salesforce. It is a process that starts with an Outbound message called by an Opportunity. In the map, it first creates a Sales Order(which is a custom object in the Accounting Seed package). Then there is a Fetch call that gets all the Opportunity Line Items (Opportunity Products) and creates Sales Order Lines. It works fine individually and in small batches, even with very large number of Line Items. But when I have done a batch change to 30 or more Opportunities, causing them all to call the Outbound message at the same time, most work fine, but each time, several of the Opportunities end up with each line item creating 2 Sales Order Lines. So the Sales Order ends up with twice as many lines as the Opportunity.

I have added a Lookup to find if the Sales Order Line already exists and skip over the Create block, if it does exist. That check prevents duplicates if re-running later due to an error part way through processing, but that check is not preventing these duplicates that are created are part of the initial run of the map.

The Create Sales Order Line block was set to "Process this Operation in batches", but even when I turned that off, the same behavior continued.

The Execution History shows success. Most of the duplicate Sales Order Lines are created the same minute as each other, but there was one case where the duplicate batch was created 2 minutes later.

Any suggestions

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...