SQL Error "SQL Could not allocate space because the file group is full"
What is happening?
When attempting to add a user to the Recast Management Server, or when attempting to run an action in Right Click Tools, nothing appears to happen. Sometimes this error will show in the Recast Management Server as an error, This error can appear in the stdout logs for the Recast Management Server.
Why is this happening?
This is happening because SQL can no longer expand the RecastManagementServer database, and the database is full. This can happen when:
- The Hard Disk the RecastManagementServer database resides on is full
- SQL has an upper limit assigned for the amount of space that the RecastManagementServer database can grow.
- You are using SQLEXPRESS which only allows a database to grow to 10gb, at which time it is full.
How do I fix the error?
If you are using a full version of SQL, and the hard drive is full, you can either move the database to a new location, or add space to that drive (if it is virtual). If you move the database to a new location, you will need to change the location that the Recast Management Server looks for the database. That information is stored in the appsettings.production.json file which is located here C:\Program Files (x86)\Recast Software\Recast Management Server\appsettings.production.json. You will need to change the "Server=" setting to include the FQDN of the server as well as the port in the form: Server=FQDN,1433
Change the upper limit for the database. It is possible to allow the database to grow larger (if space is available) by changing the maximum size. Check here for more information on how to define the size of a SQL database. How to change the database size
Unfortunately, SQLEXPRESS limits the size of any one database to 10gb. If you have hit that limit you will need to remove some data from the Database. To do that you will need to run a query to delete items from SQL Server Management Studio (SSMS).
a. Log into SQL Server Management Studio.
b. Right Click on the RecastManagementServer database and select "New Query"
c. Enter the following query into the window that opens: delete from ActionExecutions
d. click "Execute" in the ribbon above the Object Explorer. The exection will take some time, but will list the number of rows deleted when it is complete.