Receiving Error: Could not allocate space for object 'cw_change_log' in database

Modified on Mon, 30 Nov 2015 11:32 by Kevin Ricciardo — Categorized as: FAQ

Source: jProgBusiness - Could not allocate space for object 'cw_change_log' in database 'CW_CHANGE_LOG_0008' because the 
'PRIMARY' filegroup is full. 
INSERT INTO cw_change_log ( chn_lg_pk , chn_lg_table_name , chn_lg_pk_value , chn_lg_field_name , chn_lg_is_delete , 
chn_lg_new_value , chn_lg_usr_fk , chn_lg_dmn_fk , chn_lg_bt_version , chn_lg_date_time) VALUES (@chn_lg_pk , @chn_lg_table_name 
, @chn_lg_pk_value , @chn_lg_field_name , @chn_lg_is_delete , @chn_lg_new_value , @chn_lg_usr_fk , @chn_lg_dmn_fk , @chn_lg_bt_version 
, @chn_lg_date_time)

The error occurring is due to insufficient space on the hard drive where the database is installed or if using a SQL Server Express edition, the database has reached its maximum size limit. You can check both of these using the procedures below.

To find the amount of available hard drive space:

  1. Go to My Computer
  2. Right click on C: drive
  3. Select Properties
  4. The available hard drive space will be title Free Space

If the hard drive is out of space, then you will need to free up space. This can be done in a multitude of ways. The help desk suggests removing old backups first as this may be the cause of the reduced hard space. You may also want to remove unnecessary programs, clear caches, and so forth in order to create enough hard drive space. You can also move the SQL Server database to another hard drive if you are unable to free any space on the hard drive.

To find out the database size:

  1. Browse to the location of the database (Default location for SQL Server 2000: C:\Program Files\Microsoft SQL Server\MSSQL$CAREWare\Data)
    (Default location for SQL Server 2008: C:\Program Files (x86)\Microsoft SQL Server\MSSQL10CAREWare\MSSQL\DATA)
  2. Right click on CW_Data.MDF
  3. Select Properties

For SQL Server 2000: If the database size is close to 2 GBs then you will need to upgrade to SQL Server 2005 or 2008 Express or upgrade to a licensed version of SQL Server.
If you are using CAREWare build 827 or newer, it is required to use SQL Server 2008 Express or newer. Instructions to upgrade to SQL Server 2008 Express can be read here.

For SQL Server 2008: If the database size is close to 4 GBs then you will need to upgrade to SQL Server 2008 R2 Express or newer to increase the database size limit to 10 GB. A licensed version of SQL Server can increase to database size limit to 524,272 petabytes.

If you do not know which version of SQL Server you are using, then you can log in to CAREWare and press Ctrl-I. This will bring up the System Information screen. The Data Tier Version will state the version number and in parenthesis the version type. If the version type is Express or Desktop Engine, then you have the free SQL Server instance installed.

Back to Errors

Back to Frequently Asked Questions