I have 2-Queues, Queue-1 contains 2 file paths, based on this files(processing csv and pdf files and generating a data table) I’m creating a datatable and inserting this data table rows into Queue-2, on successful bulk insertion to Queue-2, I want to set the Transaction status to success. In between if the transaction failed after successful bulk insertion, transaction status would be “In Progress” after some time it would be “Abandoned”. Hence it will be retried next time. If Queue-1 transaction item is retried, again this data table rows will be inserted to Queue-2, how can I restrict this.
Any suggestion or help would be appreciated. Thanks.