Blue Prism Product

last person joined: yesterday 

Chat about Blue Prism products
Expand all | Collapse all

Blue Prism Session logs Archival issue - Available storage options

Jump to Best Answer
  • 1.  Blue Prism Session logs Archival issue - Available storage options

    Posted 18 days ago
    Dear Fellow Members,

    I am reaching out to you to get some insights and best practices for handling Session logs / Database archive for Blue Prism Database.

    The Archival feature provided in Blue Prism Control room is archiving the information to the local folder space. Even after running the archive from Control room, Session logs size seems not reduced greatly (only archived 100 MB from few GB space in Database). 

    Can some one take time to provide help on the below questions please?

    1. What are the options available to store it to cloud storage (say Amazon S3 etc.) instead of Local disk. If this is not feasible is there any other effective way to archive?

    2. Archival feature seems archived only certain amount of Data from the available logs structure in Control room. The archived folder occupied ~100 MB size on disk. However Database Contains the data in few GB for Session logs.

     Thanks in advance for your time to take a look into my query!

    Regards,
    Srini

    ------------------------------
    Srinivas Goriparti
    ------------------------------


  • 2.  RE: Blue Prism Session logs Archival issue - Available storage options
    Best Answer

    Posted 15 days ago
    Hi Srini,

    Two documents that I'd recommend you have a look at are the Portal>Documents>Documentation

    • Data Gateways (this is the latest version but it was introduced in V6.5)
    As for where to store the Session logs.... ultimately anywhere that's secure, but cost is obviously a major factor. This data is typically accessed for dashboard/statistical reporting or compliance purposes, but how you use the data is going to impact on where is best to store it.

    Just be mindful (you're already on the correct path by enquiring about this topic) that BP is an operational database, so the "leaner" the database the better performant the BP application will be. Archiving session logs and other tables that grow over time is a great way of achieving this. Many customers monitor their database table size growth and if they detect a spike in growth this usually indicates an anomaly somewhere, such as a process needlessly looping or high logging levels being set on an automation that has recently moved to a production environment.

    Hope this helps.

    Kind regards

    Andrew

    ------------------------------
    Andrew Beard
    Senior Consultant
    Blue Prism
    Australia/Melbourne
    ------------------------------



  • 3.  RE: Blue Prism Session logs Archival issue - Available storage options

    Posted 11 days ago
    Thank you Andrew for your inputs.

    I ran the Sql reports for disk space utilization and Session Logs table still occupy pretty good amount of space in Sql (this has been verified by Top Table Size report)

    At the same time, I do not have any more logs to archive or I could not retrieve Logs for a Item Key from Blue Prism Control room. This corresponds to the meaning that all available Session Logs were archived.

    But in reality those records still occupy space in the Database. Does the Archive feature available in Blue Prism remove the entries from Database after a successful archive?

    When I query the Database (Count(*) from Session log table it shows record count as almost the same. This confuses me if it actually removes the session logs or not.

    If not what are the best alternatives available to remove them as a Blue Prism Solutions Developer.

    thanks,

    ------------------------------
    Srinivas Goriparti
    ------------------------------



  • 4.  RE: Blue Prism Session logs Archival issue - Available storage options

    Posted 10 days ago

    Hi Srinivas,

    The in product Archive feature relies on a runtime resource being assigned to actually perform the archival process. Has this been set and if so, does this resource have spare capacity to perform the archiving when it's not running other processes?

    A couple of other sources of information the in product help on archiving may be of use - here

    Also a series of knowledge articles on the topic in the Portal>Support center may prove useful - here

    Let me know if you're still encountering problems.

    Thanks

    Andrew



    ------------------------------
    Andrew Beard
    Senior Consultant
    Blue Prism
    Australia/Melbourne
    ------------------------------



  • 5.  RE: Blue Prism Session logs Archival issue - Available storage options

    Posted 8 days ago
    Thank you very much Andrew for the links provided and explanation. Much appreciated!
    I will explore further and reach out if any other issues.
    -------
    Srini

    ------------------------------
    Srinivas Goriparti
    ------------------------------



FAQ

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 can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism 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.



Share this post