VMware vCenter Server Storage Monitoring Service fails to start

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• Cannot start the VMware vCenter Server Storage Monitoring service or the VMware vSphere Profile Driven Storage service.
  
• vCenter Server Storage Monitoring or vSphere Profile Driven Storage service fails to start.
• Accessing the Storage View tab fails with the error:
  
  The storage service is not initialized. Please try again later
  
  
• In the sms.log or sps.log file, you see entries similar to:
  
  -11-07 08:05:05,907 [Thread-15] DEBUG com.vmware.vim.sms.data.DataMapperImpl - Initializing cache database...
  -11-07 08:05:05,907 [Thread-15] DEBUG com.vmware.vim.sms.data.DataMapperImpl - Executing sql script: C:/Program%20Files/VMware/Infrastructure/tomcat/webapps/sms/WEB-INF/classes/schema/cachedb.sql
  -11-07 08:05:05,993 [Thread-15] ERROR com.vmware.vim.sms.data.DataMapperImpl - Error initializing cachedb
  com.ibatis.common.jdbc.exception.NestedSQLException:
  --- The error occurred in com/vmware/vim/sms/data/xml/CacheDbQuerySqlMap.xml.
  --- The error occurred while executing mapped statement.
  --- Check the runscript.
  --- Check the statement or the result map.
  --- Cause: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "-1 of 2057". Possible solution: use the recovery tool; SQL statement:
  
  CREATE PRIMARY KEY PUBLIC.PRIMARY_KEY_A ON PUBLIC.VM(ID) [90030-147]

Environment

VMware vCenter Server 4.1.x

Cause

This issue occurs when the H2 database is corrupt.

Resolution

To resolve this issue, recreate the H2 database.

To recreate the H2 database:

1. Stop the VMware Management Webservices service. For more information, see Stopping, starting, or restarting vCenter services (1003895).
2. If you are using vCenter Server 5.5, stop the VMware vSphere Profile-Driven Storage service. For more information, see Stopping, starting, or restarting vCenter services (1003895).
3. Navigate to data folder:
   
   In vCenter Server 4.1/5.0/5.1 the path is:
   C:\Program Files\VMware\Infrastructure\tomcat\webapps\sms\WEB-INF\classes\com\vmware\vim\sms\data.
   
   In vCenter Server 5.5 the path is:
   C:\Program Files\VMware\Infrastructure\Profile-Driven Storage\resources\cachedb
   
   
4. Create a backup folder.
5. Copy all sms-cache*.* files to the backup folder.
6. Delete sms-cache*.* files.
   
7. Restart the VMware Management Webservices.

Additional Information

To be alerted when this document is updated, click the Subscribe to Article link in the Actions box
How to stop, start, or restart vCenter Server services
VMware vCenter Server Storage Monitoring Service が起動に失敗する