Shrink - BPA_sessionlog_nonunicode and BPA_Sessionlog_nonunicode_pre65

saivikas729 — Wed, 14 Dec 2022 06:27:43 GMT

HI All,

Can someone please elaborate on importance of BPA_sessionlog_nonunicode and BPA_Sessionlog_nonunicode_pre65

These two tables are of considerable size now in DB - And I want to shrink them,. Can I get some guidance on how to do this please?

Thanks and Best Regards

Re: Shrink - BPA_sessionlog_nonunicode and BPA_Sessionlog_nonunicode_pre65

Walter.Koller — Wed, 14 Dec 2022 14:58:46 GMT

The session and session log tables store the execution logs that can be viewed in Control in Blue Prism client.
The increase of used storage can be controlled by reducing the log levels in processes and VBO. (also make sure there is no override in the resource management in System tab).
In order to decrease current storage, the preferred way is to use Blue Prism's feature of archiving logs. This archiving can also be automated and can be found in System tab / Archiving.

There is also SQL script to delete the logs directly from those tables. This script can be provided by Blue Prism support.

topic Shrink - BPA_sessionlog_nonunicode and BPA_Sessionlog_nonunicode_pre65 in Product Forum

Shrink - BPA_sessionlog_nonunicode and BPA_Sessionlog_nonunicode_pre65

Re: Shrink - BPA_sessionlog_nonunicode and BPA_Sessionlog_nonunicode_pre65