cancel
Showing results for 
Search instead for 
Did you mean: 

Audit Recording failed with error

radoslawrajnert
Level 3

Hello!

When I want to save the process I am getting the error that the database

Warning: Audit Recording failed with error: An error occurred while writing an audit record: Could not allocate space for object 'dbo.BPAAuditEvents'.'INDEX_BPAAuditEvents_eventdatetime' in database 'blueprism_prod' 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.

Can someone help me how to solve it?
I tried to execute this Statement in DB but it did not help:


USE blueprism_prodDELETE FROM BPASessionLog_NonUnicode

WHERE DATEDIFF(DAY, enddatetime, GETDATE()) > 30

GO

 

DELETE FROM BPAAuditEvents

WHERE DATEDIFF(DAY, enddatetime, GETDATE()) > 30

 GO



------------------------------
Radoslaw Rajnert
Financial Systems Expert
Telefonica OHG
Europe/London
------------------------------
1 REPLY 1

PritamPoojari
Level 6
The second sql statement is not correct. Please contact Blue Prism Support and they will provide you with housekeeping scripts

------------------------------
Pritam Poojari
Solution Architect
Capgemini
Europe/London
------------------------------