Blue Prism Product

 View Only
last person joined: 6 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  database maintenance

    Posted 20 days ago
    For a few days now we have been having slow problems when opening blueprism and those in charge of maintaining the database tell us that the load of logs and audits is being overloaded, they have asked us to review and most of our processes work in log mode "Errors Only" hence my question,
    is there a table that indicates the maintenance or standards recommended by blueprism? Are there queries to clean and maintain log tables?

    Javier Jiménez
    RPA Developer

  • 2.  RE: database maintenance
    Best Answer

    Posted 20 days ago

    Hi Javier

    From my experience, maintenance on the Database is very important.  There are a few tables that need to be regularly maintained, i.e.  BPASessionLog_NonUnicode, BPAWorkQueueItem, BPAWorkQueueItemTag.  There are others like schedule log and audit logs etc. 

    In terms of the retention of data, this is based on your business and what they comfortable with to remove.  I know Blue Prism suggests that you drop it down to the minimum number of days where possible, like 7 days but in our environment, we need to keep 31 days for customer queries where they will query the work queue tables for case data evidence.  

    There are standard scripts that is provided for maintenance and to obtain them you need to log a ticket with support. I find that the standard scripts are not that efficient in larger environments, but never had an issue with them in our non-prod databases. However, we engaged with Chris McGowan (Blue Prism PS), to help create scripts that are much more efficient, there are separate scripts that can be run to plan log space and there is a monitor script that he helped us with to track progress and then the maintenance scripts.  These scripts that he helped us with perform well and we were able to get through maintenance relatively easy.  The past weekend we just managed to clean out over 170 millions rows from our session log and workqueue tables. 

    Hope that helps!

    Good luck


    Allan Ross
    Digital Technologist

  • 3.  RE: database maintenance

    Posted 20 days ago
    Thank you for your help, I have also opened a support ticket so that they can help me regarding this issue.
    Thanks greetings.

    Javier Jiménez
    RPA Developer

  • 4.  RE: database maintenance

    Posted 20 days ago

    Hi Javier - if you create a ticket the Support team will be able to advise you.

    John Carter
    Blue Prism

Welcome to the Blue Prism RPA Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering
Product Research Programv6 End of Life


Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism RPA can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism RPA can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.