With the SviConfig command-line utility, you can upgrade the View Composer database separately from the View Composer software. This utility also creates a log file to simplify troubleshooting if the upgrade fails.

Important: Only experienced View Composer administrators should use the SviConfig utility. This utility is intended to resolve issues relating to the View Composer service.

Prerequisites

  • Back up the View Composer database. For instructions, see the documentation for your database server.
  • Verify that you know the database source name (DSN) for the View Composer database.
  • Verify that you know the user name and password for the database administrator account for this database.

Procedure

  1. On the vCenter Server virtual or physical machine, open a Windows command prompt and navigate to the SviConfig executable file.
    The file is located with the View Composer application. The default path is C:\Program Files (86)\VMware\VMware View Composer\sviconfig.exe.
  2. Enter the command to stop VMware View Composer.
    net stop svid
  3. Run the SviConfig databaseupgrade command. 
    sviconfig -operation=databaseupgrade
                  -DsnName=target_DSN
                  -Username=database_administrator_username
    For example: 
    sviconfig -operation=databaseupgrade -dsnname=LinkedClone
-username=Admin
  4. When prompted, supply the password.
    A successful operation displays output that shows the upgrade steps. 
    Establishing database connection.
Database connection established successfully.
Upgrading database.
Load data from SVI_VC_CONFIG_ENTRY table.
Update SVI_DEPLOYMENT_GROUP table.
Update SVI_REPLICA table.
Update SVI_SIM_CLONE table.
SviConfig finished successfully.
Database is upgraded successfully.
  5. Enter the command to start the View Composer.
    net start svid

    A complete log of the upgrade process is created and placed in C:\Users\All Users\VMware\View Composer\vmware-sviconfig.log.

What to do next

If the database upgrade fails, see Troubleshooting a View Composer Database Upgrade Failure.

If the result code is any number other than 0, which means success, see Result Codes for a Manual Database Schema Update.