topic RE: Increase in Production DB size due to to Session Logs in Product Forum

Increase in Production DB size due to to Session Logs

pal_blueprism — Fri, 02 Jul 2021 13:46:00 GMT

we are using Blueprism 6.10.1
What is root cause of increasing session logs below is the screen shown.
what are best practices to avoid increasing session log so DB size will not be full.

------------------------------
Pallavi Metkar Senior Consultant
Consultant
capgemini
Indian/Antananarivo
------------------------------

RE: Increase in Production DB size due to to Session Logs

EmersonF — Fri, 02 Jul 2021 14:00:00 GMT

Hi @pal_blueprism There was already this discussion here on the forum, please see these topics, it will definitely help you.
good practices
#BPTechTips - Help with DB maintenance | Blue Prism Product
Suport
BP DB Maintenance Scripts | Blue Prism Product

If it was useful to you, mark as best answer

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------

RE: Increase in Production DB size due to to Session Logs

EmersonF — Fri, 02 Jul 2021 14:22:00 GMT

FYI - But basically, you can significantly reduce it just by activating the appropriate logs, I usually just activate the "Only Error" which is what interests me,
in debug mode too, go to options at all stages and select only error this should help a lot

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------

RE: Increase in Production DB size due to to Session Logs

james.man — Mon, 05 Jul 2021 08:02:00 GMT

Yes, you absolutely need to put into place an archiving scheme of sorts to make sure that you keep the session logging tables under control. This can be done through the database, or by using the in-product session log archiving function. The links that Emerson has provided should give you information on how to set up archiving.

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------