Error: Space Allocation

This topic describes the following error while working with Verify Privilege Manager:

Could not allocate space for object 'Ams.ItemState'.'UX_ItemState' in database 'ThycPrivMgr' because the 'PRIMARY' filegroup is full.

Error message displayed

The error indicates that either the Verify Privilege Manager database is full and out of space or the database server running is out of space.

Resolving the Error

  1. Navigate to SQL Server Management Studio.

  2. Click Connect.

  3. Expand Databases.

    Expand the databases node

  4. Right-click the Verify Privilege Manager database, select Reports.

  5. Select Standard Reports.

    Expand the databases node

  6. Select Disk Usage by Top Tables report.

    Expand the databases node

  7. The report shows the top tables by data usage.

  8. If the top table does contain a lot of data, locate the table that contains the highest number of files and open a support case. Provide the information collected with a screen shot of the report to determine the best way to reduce the size of the table.

    If the top tables do not contain a lot of data, the issue could possibly be:

    • The database server is running out of disk space. You can check to see what drive the database is stored on to see how much space is left. This will be specific to your environment regarding disk space.
    • Check if there are other databases on the same server and investigate if a different database is taking up space.