• Resetting the Inventory Service database is destructive. Ensure you reset the database only after resetting the Individual Data Providers in the Inventory Service.
• If you reset the Inventory Service database
  • vCloud Director goes out of sync with vCenter Server and does not have accurate information about managed virtual machines.
  • Any Storage Profiles that you are using through the vSphere Profile-Driven Storage service are lost.
  • All object tags are deleted during a reset.
  • If the vCenter Server environment has Site Recovery Manager and you reset the Inventory Service database, you need to run a Change/Modify and Repair on Site Recovery Manager from the Windows Programs and Features to re-register Site Recovery Manager with the vCenter Server and Inventory Service.
     

1. Create a fresh Inventory Service database.
2. Re-register the Inventory Service with the Component Manager.

1. Download 2119422_reset-isdb6.0-bundle.zip file attached to this article and extract it on the vCenter Server machine.
   
   Note: The  createdb.bat and  exec.bat are available by default in vCenter Server Update 2 and later.
    
2. On the Management/Embedded Node stop these services in order:
   
   Note: The Services under the bullet points is shut down by stopping the main service. 
    
   1. VMware vSphere Web Client  
      
      VMware Performance Charts
       
   2. VMware VirtualCenter Server
      • VMware vService Manager
      • VMware vCenter workflow manager
      • VMware Syslog Collector
      • VMware vSphere Profile-Driven Storage Service
      • VMware Content Library Service
      • VMware ESX Agent Manager
         
   3. VMware Inventory Service
       
3. Navigate to the %PROGRAMFILES\VMware\vCenter Server\invsvc\scripts folder.
4. Backup the createdb.bat and exec.bat files.
5. Copy the  createdb.bat and  exec.bat files from the extracted  2119422_reset-isdb6.0-bundle.zip file to  %PROGRAMFILES%\VMware\vCenter Server\invsvc\scripts.
6. Open  %PROGRAMFILES%\VMware\vCenter Server\invsvc\lib\server\config\dataservice.properties file using a text editor.
7. Look for the   dataservice.xdb.password entry and remove any special characters, except the @ signs.
   
   For example:
   
   dataservice.xdb.password=cSIOMV*)2>=$EGvg
   
   to
   
   dataservice.xdb.password=cSIOMV2EGvg
    
8. Look for the  dataservice.xdb.dir entry and change the instances of \ to /.
   
   For example:
   
   dataservice.xdb.dir=C:\ProgramData\VMware\vCenterServer\data\invsvc\xdb
   
   to
   
   dataservice.xdb.dir=C:/ProgramData/VMware/vCenterServer/data/invsvc/xdb
    
9. Leave this file open as it will be used later.
10. Open the %PROGRAMFILES%\VMware\vCenter Server\vpxd\endpoints\qs-endpoint.xml file in a plain text editor.
11. Find the <instanceUuid> Tag.
    For example:
    
    <instanceUuid>1c9f5ff7-c844-45d1-bf62-a4e9c0860a57</instanceUuid>
     
12. Copy the content between  <instanceUuid> and </instanceUuid>:
    From the example in Step 11 this will be:
    
    1c9f5ff7-c844-45d1-bf62-a4e9c0860a57
     
13. Return to the dataservice.properties file and create the  dataservice.instanceuuid entry and add the UUID from step 12.
    
    For example:
    
    dataservice.instanceuuid=1c9f5ff7-c844-45d1-bf62-a4e9c0860a57
     
14. Save and close the dataservice.properties file.
15. Navigate to %PROGRAMDATA%\VMware\vCenterServer\data\invsvc.
16. Rename the xdb folder to xdb.old.
17. Click Start > run, type cmd and press OK. The Command Prompt window opens.
18. Navigate to %PROGRAMFILES%\VMware\vCenter Server\invsvc\scripts.
19. Type createdb.bat and press Enter.

Re-registering Inventory Service with Component Manager    

1. Navigate to %PROGRAMFILES%\VMware\vCenter Server\vpxd\inventoryservice-registration.
2. Move these files to a backup folder:
   • register-is.bat
   • vcregtool.bat
   • GetAppDataDir.vbs
     
     Note: Some or all the files may not exist.
      
3. Copy register-is.bat, vcregtool.bat, and GetAppDataDir.vbs from the extracted from the 2119422_ reset-isdb6.0-bundle.zip to %PROGRAMFILES%\VMware\vCenter Server\vpxd\inventoryservice-registration\.
4. Navigate to %PROGRAMDATA%\VMware\vCenterServer\.
5. Create a folder ssl.
6. Return to the command prompt from the previous section and navigate to %PROGRAMFILES%\vmware\vcenter server\vmafdd\.
7. Run these commands:
    
   • vecs-cli.exe entry getkey --store vpxd --alias vpxd --output %PROGRAMDATA%\VMware\vCenterServer\ssl\rui.key
   • vecs-cli.exe entry getcert --store vpxd --alias vpxd --output %PROGRAMDATA%\VMware\vCenterServer\ssl\rui.crt
      
8. Start these services in the order listed:
   • VMware Inventory Service
   • VMware VirtualCenter Server
      
9. Open %PROGRAMFILES%\VMware\vCenter Server\invsvc\lib\server\config\dataservice.properties file using a text editor.
10. Find the entry dataservice.cm.url=.
    
    For example:
    
    dataservice.cm.url=http://localhost:18090/cm/sdk/?hostid=d820e6b0-c730-11e4-bddf-005056031f43
     
11. Copy the url after dataservice.cm.url=.
    
    Example from step 10:
    
    http://localhost:18090/cm/sdk/?hostid=d820e6b0-c730-11e4-bddf-005056031f43
     
12. Return to the command prompt and navigate to %PROGRAMFILES%\VMware\vCenter Server\vpxd\inventoryservice-registration.
13. Run this registration command using the url copied from Step 11:
    
    register-is.bat "dataservice.cm.url "http://localhost:8095
    
    For example:
    
    register-is.bat "http://localhost:18090/cm/sdk/?hostid=d820e6b0-c730-11e4-bddf-005056031f43" http://localhost:8095
     
14. Start the following Services in the order listed:
     
    1. VMware ESX Agent Manager
    2. VMware Content Library Service
    3. VMware vSphere Profile-Driven Storage Service
    4. VMware Syslog Collector
    5. VMware vCenter workflow manager
    6. VMware vService Manager
    7. VMware vSphere Web Client
    8. VMware Performance Charts