Archive | February 2014

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