Digital Exchange

 View Only
last person joined: 5 days ago 

This community is a place to discuss Blue Prism DX assets and development.

  • 1.  Queue Reports - Performance Report Cell value error

    Posted 08-01-2023 07:19

    Hi, Community

    I've generated the Performance Report using the Queue Reports VBO downloaded from the DX. In the Performance Report, I noticed that the Median Case Times field is broken. Is there any pre-requisites to run this VBO safely or did I miss some settings? Your help would be much appreciated.


    HongJoo Choi

  • 2.  RE: Queue Reports - Performance Report Cell value error

    Posted 08-02-2023 11:23

    Hello HongJoo,

    These are great but old reports that were create by Blue Prism consultants many... many years ago (I was the last person to apply some fixes maybe 6 years ago.. @John Carter was the guy who created them originally over 10 years ago?).  I doubt the are in anyway supported in an ongoing way.

    Num! errors suggest that there is a calculation error of some sort,  considering this report worked fine for years without such problems this could either be because of a Blue Prism product change that has not been matched by a change in the report.  It it potentially be a date/time issue related to global use (we only ever used it in UK all those years ago).   
    It could also be something different about your process - I see the name is WQ_Generate, is this a business process being worked (what this report was created to report on) or is this some kind of background task process where case time is almost instant.  It could be something as simple as a divide by zero error in a report we never expected so never built in robustness for.

    To fix the report you are going to have to dive into it.  It is in reality just a BP process using the Work Queue actions and the Excel actions with some calculations - so not anything too difficult.  I would recommend steping through it in debug mode to get familiar with it and to get to the point where it is calculating the average times.

  • 3.  RE: Queue Reports - Performance Report Cell value error

    Posted 12 days ago

    The latest version of the VBO is maintained on the DX but I'm not aware of any recent changes to the performance report. It works by creating an Excel file from a binary data item that has been hardcoded in the VBO. Data pulled from the queue is pushed into the template, where pivots and formulae are used to calculate the metrics. At the end of the automation, all sheets are deleted apart from the presentation page. If you omit this deletion step you'll be able to see how the calculations work and maybe this will reveal the problem. Denis is probably correct (he usually is) to guess divide-by-zero or something like that.

    John Carter
    Blue Prism

Welcome to the Blue Prism Digital Exchange Community!

The Blue Prism Digital Exchange is a "shop window" for new and emerging technologies—a platform that puts powerful RPA and AI capabilities into the hands of business leaders. Users can find and apply pre-built AI capabilities, in the form of downloadable integrations and Visual Business Objects (VBOs), to automated processes. These assets connect and integrate Digital Workers, existing systems and processes to Blue Prism's technology partners, creating a solid foundation of AI-enabled Intelligent Automation that's scalable and sustainable.

Blue Prism Digital ExchangeDX Asset IdeasContact DX Support


The Blue Prism Digital Exchange (DX) is an online marketplace where businesses can instantly access, apply and share pre-built AI, cognitive and advanced RPA technologies from best-in-class providers. These assets easily connect to existing digital workers, systems and processes to enhance automation capabilities.
The Digital Exchange is free to all users. Most of the content on the DX is free to download but there are some submissions that do have a cost associated. The submissions with a cost are advertised on the asset card and profile. No unwanted costs will be applied to any users.
You can visit and browse the Digital Exchange here. If you would like to consume or download any material it is necessary to create an account on the Blue Prism Portal first.
Everyone can access the Digital Exchange and consume the assets on it. If you would like to contribute to the marketplace it is necessary that you create an account and sign up as a partner.