Shrink - BPA_sessionlog_nonunicode and BPA_Sessionlog_nonunicode_pre65

[saivikas729]

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

[Walter.Koller]

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.