Root Cause
While I go
through the Event viewer I have found several error logs in the
System and Application. System Log have Event ID 7024 which is
related to VMware VCenter Server.
“The VMware
VirtualCenter Server service terminated with service-specific error
the system cannot find the file specified.”
Then checked the
application log since above error is not obvious and cloud not
imagine exact reason for the error.
By looking at the
Application log it’s having lot of errors with Event ID 1105 and
below is the detail of the error event
Log
Name: Application
Source:
MSSQL$SQLEXP_VIM
Date:
01/25/2016 14:30:48
Event
ID: 1105
Task
Category: Server
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.
I have gone
through database and the size of the database is 9.99GB. Microsoft
SQL Server 2008 R2 is only supporting up to 10 GB. This is the root
cause for the issue.
Solution
Running the
following from the commands to shrink the database.
cd \
cd Program Files\Microsoft SQL Server\100\Tools\Binn\
OSQL.EXE -S localhost\VIM_ SQLEXP -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=’30’ where
name=’event.maxAge’
2> update vpx_parameter set value=’30’ 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
1> quit
Then start the
VMware Virtual Center Server service.
