Could not allocate space for object dbo.VPX_TEXT_ARRAY in VIM_VCDB

I recently completed a vCenter 5.1 update for a customer and notice a few days later that the vCenter service had stopped.  Restarted and logged in to find the following error: “A general system error occurred”  “Could not allocate space for object dbo.VPX_TEXT_ARRAY” in VIM_VCDB, etc.
Checked the disk that the DB was located on and confirmed there was plenty of space. Turns out the default limit for SQL Express had been reached.  I followed the following article to resolve this issue:
First, I stopped the vCenter Service.
Expanded the VIM_VCDB DB, selected Tables & Opened the dbo-VPX_PARAMETER table.

Modify event.maxAge to 30, and modify the event.maxAgeEnabled value to true.
Modify task.maxAge to 30, and modify the task.maxAgeEnabled value to true.
Scroll down on the left, expand Programmability, Stored Procedures.  Right-click on dbo.cleanup_events_tasks_proc, select Excute then OK on the following screen to run the produce.
Finally once this has completed, shrink the database & restart the vCenter Service


About AJ McKean

Based in sunny Tauranga, New Zealand, AJ McKean is a Senior Systems Engineer in Mt Maunganui. With over 15 years of professional IT experience working in both New Zealand and the United States, he holds several certifications including MCSE(2000-2003), MCITP:Enterprise(2008), MCSA(2012), VMware VCP-DCV5.5, CompTIA A+ & is an HP Storage Architect. He is passionate about all things IT, especially virtualization, automation & cloud technologies.

2 Responses to “Could not allocate space for object dbo.VPX_TEXT_ARRAY in VIM_VCDB”

  1. Darren says :

    Thank you AJ – this issue was exact solution for me to help resolve a client site with all hosts not connecting to vCenter, and all VMs showing as orphaned. Now all green and happy. Thank you sir

Leave a Reply

Your email address will not be published. Required fields are marked *