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

  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

57 Tips Every Admin Should Know

Active Directory 1. To quickly list all the groups in your domain, with members, run this command: dsquery group -limit 0 | dsget group -members –expand 2. To find all users whose accounts are set to have a non-expiring password, run this command: dsquery * domainroot -filter “(&(objectcategory=person)(objectclass=user)(lockoutTime=*))” -limit 0 3. To list all the FSMO role holders in your forest, run this command: netdom query fsmo 4. To refresh group policy settings, run this command: gpupdate 5. To check Active Directory replication on a domain controller, run this command: repadmin /replsummary 6. To force replication from a domain controller without having to go through to Active Directory Sites and Services, run this command: repadmin /syncall 7. To see what server authenticated you (or if you logged on with cached credentials) you can run either of these commands: set l echo %logonserver% 8. To see what account you are logged on as, run this command: ...
Post a Comment
Read more
  The Guardrails of Automation VMware Cloud Foundation (VCF) 9.0 has redefined private cloud automation. With full-stack automation powered by Ansible and orchestrated through vRealize Orchestrator (vRO), and version-controlled deployments driven by GitOps and CI/CD pipelines, teams can build infrastructure faster than ever. But automation without guardrails is a recipe for risk Enter RBAC and policy enforcement. This third and final installment in our automation series focuses on how to secure and govern multi-tenant environments in VCF 9.0 with role-based access control (RBAC) and layered identity management. VCF’s IAM Foundation VCF 9.x integrates tightly with enterprise identity providers, enabling organizations to define and assign roles using existing Active Directory (AD) groups. With its persona-based access model, administrators can enforce strict boundaries across compute, storage, and networking resources: Personas : Global Admin, Tenant Admin, Contributor, Viewer Projec...
Post a Comment
Read more