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.

About this task

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.