topic Deleteing rows from dbo.BPAScheduleLogEntry & dbo.BPASessionLog_NonUnicode in Product Forum

Deleteing rows from dbo.BPAScheduleLogEntry & dbo.BPASessionLog_NonUnicode

SergioSampietro — Wed, 03 Feb 2021 13:20:00 GMT

Hi all,

I'm detecting that on my prod environment the following tables size is to high :

dbo.BPAScheduleLogEntry

dbo.BPASessionLog_NonUnicode

Can I delete some old rows (2 years ago) direct from SQL Server ?
Is there any impact on my running process that I need to consider before deleting?

Thanks
Sergio

RE: Deleteing rows from dbo.BPAScheduleLogEntry & dbo.BPASessionLog_NonUnicode

John__Carter — Thu, 04 Feb 2021 08:28:00 GMT

Please contact the Support team for advice before deleting anything.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Deleteing rows from dbo.BPAScheduleLogEntry & dbo.BPASessionLog_NonUnicode

StanaST — Wed, 28 Apr 2021 12:03:00 GMT

Hello Sergio,
To be honest, I'm not familiar with the Blue Prism db structure, but I guess that records in these are referenced by some tables with data about queues and audit logs. So I would suggest cleaning the queues first.

The size of BPASessionLog_NonUnicode can be easily reduced directly from BluePrism, that way you don't have to worry about anything.
In section 'System > Archiving' you just choose the period you want to delete/archive.

------------------------------
Stanislava Tlustá
------------------------------