SQL Could Not Allocate Space Because The File Group Is Full

If you look at the Recast Management Server or Event Viewer Logs, the full error is: ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Could not allocate space for object 'dbo.ActionExecutions'.'PK_ActionExecutions' in database 'RecastManagementServer' 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.

What it means

The Recast Management Server is not able to write to the SQL Database because the disk or SQL instance is full.

How to resolve the issue

SQL Express

SQL Express is limited to a 10GB database, and when it fills up you will receive the file group is full notice.

To remove information from the database you should

  1. Open SQL Server Management Studio
  2. Open the list of Databases
  3. Right Click on the RecastManagementServer database and select "New Query"
  4. In the window that appears on the right side, type delete from ActionExecutions. Note: This will remove all previous action executions from the Audit Log.
  5. Once the query is done, it will show how many rows were affected in the bottom window.
  6. We recommend opening IIS and restarting the Recast Management Server and recycling the AppPool after running the query.

SQL Query

Enterprise SQL

To remediate this error in Enterprise SQL, you can follow the same steps as above, or you can expand the database size.

  1. Open SQL Server Management Studio
  2. Open the list of Databases
  3. Right Click on the RecastManagementServer database and select "Properties"
  4. In "Database Properties" select the "Files" Page
  5. Increase the value in the initial size (MB) column for the file.
  6. Click "OK"
  7. We recommend opening IIS and restarting the Recast Management Server and recycling the AppPool after running the query.

Database Properties

How to make sure it doesn't happen again

Audit logs are the item that takes up the most space in the Recast Management Server Database. By default those logs are stored indefinitely. You can change the length of time the logs are stored in the Settings section of the Recast Management Server. Under the Global Settings section, click change on the MaxAuditLogAge setting. You can enter the number of days you would like to keep the logs in the format DD:HH:MM:SS

RMS Audit Age Setting