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.
vCenterError
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: http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1025914
First, I stopped the vCenter Service.
vCenterError1
Expanded the VIM_VCDB DB, selected Tables & Opened the dbo-VPX_PARAMETER table.
vCenterError2

vCenterError3
Modify event.maxAge to 30, and modify the event.maxAgeEnabled value to true.
vCenterError4a
Modify task.maxAge to 30, and modify the task.maxAgeEnabled value to true.
vCenterError4b
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.
vCenterError5
Finally once this has completed, shrink the database & restart the vCenter Service
vcenter-shrinkdb

 

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 to AJ McKean Cancel reply

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