VCenter and Event ID 1105, SQL Error with vmware.

Today one of speedsters clients VMware Vcenters server was not starting due to the SQL express being overloaded, after a little looking around on the web we have the answer !

The problem event log

Reporting the following event log.

Log Name: Application
Source: MSSQL$SQLEXP_VIM
Date: 06/06/2012 14:14:48
Event ID: 1105
Task Category: (2)
Level: Error
Keywords: Classic
User: SYSTEM
Description:
Could not allocate space for object 'dbo.VPX_HOST_VM_CONFIG_OPTION'.'PK_VPX_HOST_VM_CONFIG_OPTION' in database 'VIM_VCDB' because the 'PRIMARY' 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.
Solution----

Running the following from the command

64 BIT

"C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\OSQL.EXE" -S localhost\SQLEXP_VIM -E"

32 Bit

c:> "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\OSQL.EXE" -S <server>\SQLEXP_VIM -E

then follow the below, update value with your desired time to keep items for inside the DB.

1> use VIM_VCDB
2> go
1> update vpx_parameter set value='<value>' where name='event.maxAge'
2> update vpx_parameter set value='<value>' where name='task.maxAge'
3> update vpx_parameter set value='true' where name='event.maxAgeEnabled'
4> update vpx_parameter set value='true' where name='task.maxAgeEnabled'
5> go
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
1> exec cleanup_events_tasks_proc
2> go
1> dbcc shrinkdatabase ('VIM_VCDB')
2> go
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ----------- ----------- ----------- ----------- --------------
5 1 81080 280 78776 78776
5 2 128 128 128 128

(2 rows affected)
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
1> quit

Then off you go again !

Related Articles