Error 37000 – Can't allocate

The error indicates that the file cannot be created because the database or hard-drive is out of space. This can be caused by the PDF History itself or a combination of all files in the database.

Start with purging the PDF History, then rebooting the server.  If this does not eliminate the error, your tech will need to take a look at available space on the server and within SQL.

 Also check the size of the log file for this issue. (At server, go to start -> Microsoft SQL Server -> SQL Management Studio -> Log in -> look in object explorer on left, expand the lists until you see your database -> right click database -> Properties -> Files -> Look in Initial Size column for Log) In most cases these should only be a few megabytes, up to a few hundred megabytes in the case of very active SQL servers. If your log file is exceeding sizes of 300 megabytes, please run more frequent log backups.

 If you are on SQL express – check your database MDF size from the same location as mentioned above. If you are using SQL 2008 Express or older (it will say at the top of management studio’s object explorer 10.0, 9.0 [if it says less than 9.0 you need to upgrade as your system may be vulnerable to viruses and instability]), make sure your database size is less than 4 GB.

If you are using SQL 2008 R2 Express or newer (it will say at the top of management studio’s object explorer 10.5, 11.0, 12.0+), make sure your database size is less than 10 GB.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.