Skip to main content

VMware vCenter Server Service failed with the error "The ‘PRIMARY’ filegroup is full"

My VMware vCenter Service failed and unable to start the service. I have reveiwed the logs from  vpxd.log file and got the below error message, whenever I try to start the virtual center service.
 ”ODBC error: (42000) – [Microsoftfilegroup>’ 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.” is returned when executing SQL statement “<sql statement>” .


An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) “ODBC error: (42000) – [Microsoftdbo.VPX_HOST_VM_CONFIG_OPTION’.'PK_VPX_HOST_VM_CONFIG_OPTION’ in database “vcenter4.1″ because the ‘PRIMARY’ filegroup is full”
I have resolved the issue by following the KB Article 1025914. I strongly recommend to read the Caution and NOTE mentioned in the KB Article before the running the script to purge the vCenter SQL database.
Take the backup of vCenter database before running the script.
Here Explain you the step by step procedure which i have followed to resolve the issue.
1. Login to your vCenter database server and connect the DB using SQL server Management Studio.

2. Download the Script from the above mentioned KB Article under “Attachment” Sections.
3.Stop the vCenter server service If it is running.
4. Right click the vCenter database  and select new Query.
5. Right click the Script and Edit . Open with Notepad to copy the script and paste it in SQL Query or  Double click the Downloaded SQL script “VCDB_table_cleanup_MSSQL_v4.X.sql” to open with.
Make sure You have selected the vCenter Server Database to run this script.

6. Edit the below section in the script to specify the events for number of days to delete. In the Script , It is mentioned as 180 Days.
I don’t want to delete events for 180 days. I only want to delete the events for 15 days. So Edited to 15. Refer the below screen shot
7. Execute the script to test how many tables will be deleted as part of running this script. It will not actually delete the tables. Find the below result.
8 Edit the script to actually delete the Script by modifying the value “SET @DELETE_DATA = 1″ to delete the tables and purge the database
 Edit the Value to 1.
9.Script completed successfully.
I tried to start the vCenter service after the script completed running. It started successfully.
Thanks For Reading !!!!

Comments

Post a Comment

Popular posts from this blog

Quick Guide to VCF Automation for VCD Administrators

  Quick Guide to VCF Automation for VCD Administrators VMware Cloud Foundation 9 (VCF 9) has been  released  and with it comes brand new Cloud Management Platform –  VCF Automation (VCFA)  which supercedes both Aria Automation and VMware Cloud Director (VCD). This blog post is intended for those people that know VCD quite well and want to understand how is VCFA similar or different to help them quickly orient in the new direction. It should be emphasized that VCFA is a new solution and not just rebranding of an old one. However it reuses a lot of components from its predecessors. The provider part of VCFA called Tenenat Manager is based on VCD code and the UI and APIs will be familiar to VCD admins, while the tenant part inherist a lot from Aria Automation and especially for VCD end-users will look brand new. Deployment and Architecture VCFA is generaly deployed from VCF Operations Fleet Management (former Aria Suite LCM embeded in VCF Ops. Fleet Management...
Post a Comment
Read more
  Issue with Aria Automation Custom form Multi Value Picker and Data Grid https://knowledge.broadcom.com/external/article?articleNumber=345960 Products VMware Aria Suite Issue/Introduction Symptoms: Getting  error " Expected Type String but was Object ", w hen trying to use Complex Types in MultiValue Picker on the Aria for Automation Custom Form. Environment VMware vRealize Automation 8.x Cause This issue has been identified where the problem appears when a single column Multi Value Picker or Data Grid is used. Resolution This is a known issue. There is a workaround.  Workaround: As a workaround, try adding one empty column in the Multivalue picker without filling the options. So we can add one more column without filling the value which will be hidden(there is a button in the designer page that will hide the column). This way the end user will receive the same view.  
Post a Comment
Read more
  "Cloud zone insights not available yet, please check after some time" message on Aria Automation https://knowledge.broadcom.com/external/article?articleNumber=314894 Products VMware Aria Suite Issue/Introduction Symptoms: The certificate for Aria operations has been replaced since it was initially added to Aria Automation as an integration. When accessing the Insights pane under  Cloud Assembly  ->  Infrastructure  ->  Cloud Zone  ->  Insights  the following message is displayed:   "Cloud zone insights not available yet, please check after some time." The  /var/log/services-logs/prelude/hcmp-service-app/file-logs/hcmp-service-app.log  file contains ssl errors similar to:   2022-08-25T20:06:43.989Z ERROR hcmp-service [host='hcmp-service-app-xxxxxxx-xxxx' thread='Thread-56' user='' org='<org_id>' trace='<trace_id>' parent='<parent_id>' span='<span_id>'] c.v.a.h.a.common.AlertEnu...
Post a Comment
Read more