Digital Exchange

Expand all | Collapse all

Blue Prism Tags

  • 1.  Blue Prism Tags

    Posted 05-05-2020 22:32
    We are in the middle of doing the DB housekeeping recently. One of the concern is our BPATag table record is huge and sometime it caused our process run into Deadlock when they are running in multiple BOTs.
    May I know how many tags you have been created so far throughout the entire processes? Did you faced any performance issue or deadlock when your process deal with tags in Work Queue?

    ------------------------------
    SeeAnn Loh
    Senior Programmer
    Jabil
    Asia/Kuala_Lumpur
    ------------------------------


  • 2.  RE: Blue Prism Tags

    Posted 05-06-2020 03:50
    Tags are intended as labels to group or classify queue items, eg male/female, loan account/credit card account/savings account. They aren't designed to carry unique values like customer IDs, phone numbers etc, and filtering on tags can result on DB performance issues when there are a high number of unique tags. What is a high number is hard to say as there are lots of unknown dependencies such as table sizes, solution design, infrastructure etc.

    If you contact Support they will be able to advise you on housekeeping and may provide you with clean up scripts.

    ------------------------------
    John Carter
    Professional Services
    Blue Prism
    ------------------------------