vSphere – Virtual Center Server Service Stops

KB ID 0000479

Problem

If your VC Database reaches 4GB, the VMware Virtual Centre Server service will stop. A restart of it will result in the service stopping again within a minute.

You will also see see this event logged.

Description:

Could not allocate space for object ‘dbo.VPX_HOST_VM_CONFIG_OPTION’.’PK_VPX_HOST_VM_CONFIG_OPTION’ in database ‘VIM_VCDB’ 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 file group.

Solution

1. Download and install the Microsft SQL Server Management Studio Express.

2. Connect to ServernameSQLEXP_VIM and login with Windows Authentication.

3. Expand databases > Expand VIM_VCDB > Expand Tables > Open table dbo.VPX_PARAMETER:

4. Modify event.maxAge to a be 30 > Modify event.maxAgeEnabled to value of true.

5. Modify task.maxAge to be 30 > Modify task.maxAgeEnabled to a value of true.

5. Then run the built in stored procedure: from the VCDB > Programmability > Stored Procedures.

6. Right Click dbo.cleanup_events_tasks_proc and click “Execute Stored Procedure”.

7. This will purge the data from tables: vpx_event, vpx_event_arg and vpx_task based on the date specified for maxAge.

8. When this has sucessfully completed, close the SQL Management Studio down > Then start the VMware Virtual Centre Server service.

 

Related Articles, References, Credits, or External Links

NA