Has anyone else run into this?
We’re seeing duplicated PR000 numbers. Looking at the database, the duplicates were created at different times, so it doesn’t appear to be a concurrency issue.
hey @Eugene_West
if you’re saying the duplicates were created at different times, you should look for other workflows in your app that have this step. Maybe it’s triggered by another event that you forgot about? or the duplicates are for different team_ids…or maybe the (search for protrack_doc) is filtering relevant elements somehow
1 Like
Hello @Eugene_West, one question, the PR Number, once created, can it be deleted ? For any reason, not useful anymore or created by mistake … so leads to its deletion ?
We don’t delete it from db, but rather tag it as deleted, and I don’t use any filters. Overall impacted percentage of data is like 0.3 - 0.5 % of 100.
Hmm, strange … this could be maybe someone is deleting from db rather than ‘tag it as deleted’. But if you don’t find the cause of this maybe set up a condition on the workflow something like only when PR000 search for protrack_document_prs:count+1 is not in search for protrack_document_prs’PR Number –> not properly written but you get the idea I guess.