Deleteing rows from dbo.BPAScheduleLogEntry & dbo.BPASessionLog_NonUnicode

[SergioSampietro]

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

[John__Carter]

Please contact the Support team for advice before deleting anything.

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

[swolonda]

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á
------------------------------