dbo.VPX_HOST_VM_CONFIG_OPTION & ‘VIM_VCDB’ because the ‘PRIMARY’ filegroup is full


Error:
Vcenter service stops frequently or Unable to login through VIClient.

Event-ID: 1105

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 filegroup.

RootCause: This error due to limitation size in log file growth in SQL and we need to clear unwanted files in the log file to reduce the size.

Solution:

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

2. Connect to ServernameSQLEXP_VIM and login with Windows Authentication.

sqlserver-authentication

 

 

 

 

 

 

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

2-vimcdb-vm-table-modify

 

 

 

 

 

 

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

4-vm-table-event-max-true-setting

 

 

 

 

 

 

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

2-vimcdb-vm-table-modify-taskmax-aged-current

 

 

 

 

 

 

5-task-max-enabled-true

 

 

 

 

 

 

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

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

6-execute-cleanup-from-table

 

 

 

 

 

 

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

executeprocedure

 

 

 

 

 

 

 

 

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

9. If you are getting error on the Step 7 (“Right Click dbo.cleanup_events_tasks_proc and click “Execute Stored Procedure””)

7-sql-log-file-full

 

 

 

 

 

 

10. Increase the log file size as mentioned in the below screen shot

a. Right click on the VIM_VCDB and go to properties

8-sql-log-full-solution-1-properties

 

 

 

 

 

 

 

 

 

b. Select the log “File type” option as highlighted

8-extend-log-file-growth

 

 

 

 

c. Extend the log file growth as mentioned

9-extend-sql-log-file-growth-2gb

 

 

 

 

 

d. Now the solved Output of the Step7. “”Right Click dbo.cleanup_events_tasks_proc and click “Execute Stored Procedure””

 

10-table-cleanup-solved

 

 

 

 

 

 

Ref article: http://www.petenetlive.com/KB/Article/0000479

 

 

 

Advertisements

CEH V9


Karthick-CEH-V9