Exception Work Queue

[Anonymous]

Hi, We use work queue with tags for our process, that looks like that: Item Tag "Pending: Process1; Pending: Process2" -> Process1 start [Untag "Pending: Process1"; Tag "Start: Process1"] -> Process1 end [Untag "Start: Process1"; Tag "End: Process1"]-> Process2 start [Untag "Pending: Process2"; Tag "Start: Process2"] -> Process2 end [Untag "Start: Process2"; Tag "End: Process2"] ->... Sometimes some items are marked with exception: "Cannot insert duplicate key row into object "dbo.BPATag" with unique index "UNQ_BPATag_Tag". Repeated key value: ("Start: Process1")." Cannot understand how is that possible, if I make untag every time whenever process finishes its work. Has anyone faced with same issue? Best regards, Daria Galdina

[John__Carter]

I suspect that is a bug, as the message related to a table in the database. maybe you should raise it with the Support team. However I'd question your use of tags. Tags aren't timestamps, they are just labels for categorising queue items. You should avoid creating too many different types of tag (eg customer phone numbers) and if you need to store unique values then use Set Data to store information in the Item data collection instead.