In the event viewer, the following error is recorded under the application log -
Source: LANDesk Inventory Server Service
Event ID: 4100
Database exception: SCA759.SCN, LDInv.dll
Could not allocate space for object 'OSUpdates' in database 'lddb' because the 'PRIMARY' filegroup is full.
Commit, Thread ID: 5492.
The 2 major causes of this error are either the MSDE or SQL Express database has reached their respective 2GB and 5GB limit or the partition where the database and log files are stored is full.
Note: MSDE database size limit is 2GB. SQL Express database size limit is 5GB.
- If you are using MSDE and have reached the 2GB limit you can download and install SQL Express for free from Microsoft to expand the limit to 5GB. This would not be an upgrade of the MSDE instance but an installation of an instance of SQL Express than a backup and restore of the database to the new instance.
- If you are using SQL Express and have reached the 5GB limit you will need to move to a licensed SQL 2000 or SQL 2005 instance. You can install SQL 2000 or SQL 2005 on the core server then back up and restore the LDMS database to it. If you already have a SQL server you can use it but please be sure that there are adequate resources on the server to support the LANDesk database (1MB of RAM per node for example but a full list can be found in the LDMS installation guide).
- If the partition housing the database is full move the database to a larger partition. If the database is 30GB or larger you may want to consult with LANDesk Support to identify if there are better practices to avoid this much database usage.
How to install Microsoft SQL Management Studio Express
Article on moving the LDMS database (backup and restore of the SQL database).