Please Answer this question
Suppose 50 items got added in queue and once processed they are deleted or failed. Now if the dispatcher process is Re-executed how can we avoid duplicate records?
Please Answer this question
Suppose 50 items got added in queue and once processed they are deleted or failed. Now if the dispatcher process is Re-executed how can we avoid duplicate records?
@Praveen_Reddy … Once the Item 50 item have been process they will be marked as “Success” Or “Failed”
If there is no Exception or Issue it will be Marked as “Success”
If there is some business exception or Application Exception then it will marked as “Failed”
Also, To avoid adding Duplicate value can we sorted-out many. Let me give one. While create queue you can mark the below option to avoid adding duplicate value into queue,
Check the Above Option while Creating Queue and add Reference to the item while adding it into Queue.
If you got solution from this post. Kindly mark it as Solution
Happy Learning !!
A solution I like to use (Solution from @Jayavignesh_G will also work, but you need to place the “Add Queue Item” activity inside a TryCatch, since if the item is duplicated, it throws a System Exception) is the following:
Before creating the queue item, Use a “Get Queue Items” activity, with the Filter “Reference” set to the Reference you will create:
If this outputs 1 or more items, then you know you’re about to create a duplicate, and you can skip it.
This solution allows the following:
Example:
Hope this helps!
Best Regards,
Ignasi Peiris