topic Yes, but... Is there any way… in Product Forum

Blue Prism Data Base

BraianVenieri — Fri, 13 Apr 2018 18:27:00 GMT

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.

It sounds like your database…

PSSupport — Fri, 13 Apr 2018 19:30:00 GMT

It sounds like your database is full?

Yes, but... Is there any way…

BraianVenieri — Fri, 13 Apr 2018 20:38:00 GMT

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?

If you look you'll see that…

John__Carter — Sun, 15 Apr 2018 07:04:00 GMT

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