Blue Prism Data Base

[BraianVenieri]

Hi people! I'm having some problems with the Blue Prism Data Base. I can't import, save or do any action with the problem that I showing below: "An error occurred while attempting to import the release: Import failed: An error occurred while writing an audit record: Could not allocate space for object 'dbo.BPAAuditEvents'.'INDEX_BPAAuditEvents_eventdatetime' in database 'BluePrismBD' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup." Any solution? Thanks.

[PSSupport]

It sounds like your database is full? 

[BraianVenieri]

Yes, but... Is there any way to empty everything that is not of interest or is in disuse? And... How is possible to have the database full with a few small processes and objects?

[John__Carter]

If you look you'll see that the session log table is the biggest table and probably accounts for 80-90% of the DB. Running processes produces log data, so the more you run, the more data is created, and if you do nothing about this, eventually the DB fills up. The solution is to limit the amount of data that is stored: http://portal.blueprism.com/system/files/2017-09/Archive%20and%20Backup%20Policy.zip http://portal.blueprism.com/system/files/2018-03/Logging%20Best%20Practices%20Guide.pdf