What does the error 'Could not allocate space for object 'Event' in database 'OnePoint' because the (NETIQKB855)

  • Document ID:7700855
  • Creation Date:02-Feb-2007
  • Modified Date:28-Mar-2012
    • Micro Focus Products:
      Security Manager

Situation

What does the error 'Could not allocate space for object 'Event' in database 'OnePoint' because the 'PRIMARY' filegroup is full' mean?

Resolution

This error indicates that the OnePoint database is full. Operations Manager or Security Manager cannot groom data from the database if it's too full to allow grooming operations to continue. You must increase the size of the database before grooming can occur. Then, you can groom data from the OnePoint database.

To increase the size of the OnePoint database:

  1. Stop the Consolidator server (OnePoint service for SM 5.0 and NetIQ Security Manager service for SM 5.1 and greater) and the MSDTC service on all Consolidator machines and all DAS machines.
  2. Close all instances of the console (Operations Manager MMC, SM 5.1/5.5 Monitor and Development Consoles, SM 5.1/5.5 Incident Management Consoles, and Web Console sessions).
  3. Stop all reporting batch jobs (they will attempt to contact the database).
  4. Open SQL Enterprise Manager and go to SQL Server Group | <server name> | Management | SQL Server Agent | Jobs.
  5. In the right pane, right-click on OnePoint-Groom Events and select Start Job and then select Start.
  6. Wait about 5 to 10 minutes and do the same for OnePoint-Groom Alerts, then OnePoint-Groom Sampled Numeric Data. You can check the status of these jobs by looking at the Status and Last Run Status (Start Date).
  7. When finished, check the OnePoint database size and the transaction log size. If you were able to groom data, your database will be functional again and you can turn on the Consolidator OnePoint service. If the file sizes are unchanged, first expand the OnePoint database and transaction log by an additional 100MB each, then repeat the above procedure.
  8. You will need to expand the database to accommodate the data coming from your agents. To achieve a balance between event insertion and database grooming, while still leaving some free space in the database, you will need to apply filters, look at the grooming settings, calculate agent data output, etc.

Contact Technical Support if you need assistance with properly configuring your installation for data collection.



Cause

The database is full

Additional Information

Formerly known as NETIQKB855