How to resolve Apex application error: "Could not allocate space for object..."

How to resolve Apex application error: "Could not allocate space for object..."

Sometimes the software will give an application error when you try to attach a document.

Application Error
Apex encountered a problem and will close
EDatabaseError
Could not allocate space for object "X" in database "Y" 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.

This is because there is not enough space on the server.
You need to contact your IT manager to create more space or assist you in deleting unwanted files.

Please be advised that HTI does not manage your hardware or network as all PC, hardware or network configuration has to be managed by your IT manager. We can only make suggestions.

Below is a helpful article posted by Managed.com which could help your IT manager resolve the issue:

"Could not allocate space for object 'X' in database 'Your Database' because the 'PRIMARY' filegroup is full" error Issue

You receive an error similar to: 'Could not allocate space for object 'X' in database 'Your Database' 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 auto growth on for existing files in the filegroup.' when browsing to your site.

Cause
Your database is either too big or had an artificial size limitation imposed on it by a previous host.

Resolution
The following steps require Microsoft SQL Server Management Studio. If you do not have this installed on your local computer please follow the instructions at How To Connect to Your MS SQL 2008 Database and Disable Collation
  1. Open Microsoft SQL Server Management Studio.
  2. Right-click [your database] and select Properties.
  3. In the left navigation window of the dialog box that pops up, select Files.
  4. In the Autogrowth column select the ... button noted in the image below and change it to Unrestricted Growth under Maximum File Size.
    Change Autogrowth MS SQL Settings
  5. Repeat step 4 for the second file type.
  6. Click OK
  7. Reset your site (reset the web.config file by renaming the files and saving it, then renaming it back.)

If you still continue to get this error, your database is over 4 GB in size.  You can shrink your database using the instructions at How To Truncate Your DNN Logs In Your MSSQL Database then follow the above resolution again.


    • Related Articles

    • How do I fix a Version Conflict on Apex after an Auto upgrade?

      1. Auto Upgrade After upgrading Apex through the Auto upgrade service, when opening the  Apex application a version conflict is displayed. The version conflict usually occurs when the Apex.exe was still open or in use by user/s. Due to the Apex.exe ...
    • Why can I not allocate a room number to my reservation in Apex?

      In order to allocate a room number to a reservation in Apex please follow the below steps: 1.  Have you checked the Room Chart? Navigate to the Room Chart by either using the icon on the Speed Bar or selecting Processing -> Reception -> Room Chart. ...
    • Apex V2.44

      Defects Resolved Zoho Number Module  Revision Description Zoho Desk Number AX-I78 Quotations 0414 Quotation and booking giving different rate amounts The issue where the rate amounts for extra adult- and kid- combinations calculated by accommodation ...
    • Apex V2.38

      Defects Resolved Jira Number Module Revision Description Zoho Number AX-447 Reports 0710 31 Day Marketing Analysis Report property filter When a property is selected, on a multi-property Apex the other properties will now be excluded. A warning has ...
    • Apex V2.56

      Defects Resolved Zoho Number Module Version  Description Zoho Desk Number AX-214 Reservations 0412 ADODataSet2: Cannot perform this operation on an open dataset This occurred when the user did a master lookup on a reservation and pressed ENTER 3 ...