Configuring Siebel eBusiness Applications > Creating and Administering Lists of Values >

Upgrading Existing Data Using the MLOV Upgrade Utility

After you have configured your application for use with MLOVs and added new display values for all the languages you intend to support, you must upgrade your existing LOV data. You do this using the MLOV Upgrade Utility.

NOTE:  Even if you have just completed a new installation of your Siebel application, you must perform this data upgrade.

You run the MLOV Upgrade Utility in two modes.

• Validation. Running the utility in this mode validates the current repository for data inconsistencies. If the utility finds inconsistencies, the program stops and writes the errors to a log file.
• Translation. Running the utility in this mode:
  • Changes data in target columns that are configured for MLOVs from the display value to the language-independent code.
  • When you set the target column for an LOV Type to multilingual, the utility sets the MULTI-LINGUAL flag in the LOV table (S_LST_OF_VAL) to make sure of consistency between the multilingual state of the target column and its corresponding List of Values in the LOV table (S_LST_OF_VAL).
  • Verifies that all target columns using the desired MLOV type have been enabled.

    NOTE:  Target columns are columns that store either the display value or the language-independent code as part of user data.

The MLOV Upgrade Utility upgrades target columns that are marked as bounded and updates list of values types that are not already marked as multilingual. You can run the utility as often as you need to; only data that has not already been upgraded will be affected.

NOTE:  The upgrade process run by MLOV Upgrade Utility is not reversible. Consider performing a backup of the Siebel database prior to running the utility.

You run the MLOV Upgrade Utility using the Siebel Software Configuration Utility. The Siebel Software Configuration Utility is a wizard that will help you define the required parameters for running the MLOV Upgrade Utility. You run the utility in validation mode first, fix errors as they appear, and then run it in translate mode, which will enable your existing data for MLOVs.

NOTE:  Before running the MLOV upgrade, drop all indexes from the columns that you are upgrading. After the MLOV upgrade is complete, recreate the indexes.

This task is part of the Process of Enabling MLOVs.

To run the MLOV Upgrade Utility in a Windows Environment

1. Start the Siebel Software Configuration Utility by choosing Start > Siebel Enterprise Server >Configure DB Server.

   NOTE:  You can also start the Siebel Software Configuration Utility from the DOS Prompt command line. See To start the MLOV Upgrade Utility from the DOS prompt.

   The Siebel Software Configuration Utility appears.

2. Enter the required parameters to run the MLOV Upgrade Utility in validation Mode.

   For a list of the wizard dialog boxes, options, and required values, see Table 56.

   When you run the MLOV Upgrade Utility, it checks for errors and writes them to a log file. The default name of the log file is mlovupgd_verify.log and the default location is the siebsrvr\LOG directory.

3. Review the log file and resolve errors as necessary.

   For more information, see Resuming the MLOV Upgrade Utility When Errors Occur.

4. If an error is detected, resume running MLOV Upgrade Utility in validation mode by using the DOS Prompt to navigate to the BIN directory of your Siebel Server root directory (SIEBEL_ROOT\BIN), and then at the command prompt typing:

   siebupg /m master_mlov_verify.ucf

   The MLOV Upgrade Utility resumes running.

5. Repeat Step 1 through Step 4 until no errors are detected.
6. Start the Siebel Software Utility following the steps described in Step 1.
7. Enter the required parameters to run the MLOV Upgrade Utility in translation mode.

   For a list of the wizard dialog boxes, options, and required values, see Table 56.

   The MLOV Upgrade Utility enables your existing data for MLOV. For columns configured for MLOVs, the MLOV Upgrade Utility finds LOV values in user data that are not in S_LST_OF_VAL and inserts them into S_LST_OF_VAL as inactive. It changes the display value of bounded columns to the language independent code and sets the value for the Multilingual attribute to true.

To run the MLOV Upgrade Utility in a UNIX environment

1. Start the Siebel Software Configuration Utility doing the following:
   • Navigate to the Siebel root directory and type source siebenv.csh
   • Type setenv LANGUAGE DISPLAY_LANGUAGE (where DISPLAY_LANGUAGE represents the three letter code for the display language; for example ENU, FRA, DEU, and so on).
   • Type setenv SIEBEL_ROOT SIEBEL_ROOT (where SIEBEL_ROOT is the name of the directory where you installed the Siebel Server).
   • Type the command dbsrvr_config.ksh

     The Siebel Software Configuration Utility appears.

2. Enter the required parameters to run the MLOV Upgrade Utility in validation Mode.

   For a list of the wizard dialog boxes, options, and required values, see Table 56.

   When you run the MLOV Upgrade Utility, it checks for errors and writes them to a log file. The default name of the log file is mlovupgd_verify.log and the default location is the siebsrvr\LOG directory.

3. Review the log file and resolve errors as necessary.

   For more information, see To resume running in translate mode, type srvrupgwiz /m master_mlov_translate.ucf.

4. If an error is detected, resume running MLOV Upgrade Utility in validation mode by navigating to the bin directory of your Siebel Server root directory (SIEBEL_ROOT/bin), and then typing the following command:

   svrupgwiz /m master_mlov_verify.ucf

   The MLOV Upgrade Utility resumes running.

5. Repeat Step 1 through Step 4 until no errors are detected.
6. Start the Siebel Software Utility following the steps described in Step 1.
7. Enter the required parameters to run the MLOV Upgrade Utility in translation mode.

   For a list of the wizard dialog boxes, options, and required values, see Table 56.

   The MLOV Upgrade Utility enables your existing data for MLOV. For columns configured for MLOVs, the MLOV Upgrade Utility finds LOV values in user data that are not in S_LST_OF_VAL and inserts them into S_LST_OF_VAL as inactive. It changes the display value of bounded columns to the language independent code and sets the value for the Multilingual attribute to true.

To start the MLOV Upgrade Utility from the DOS prompt

1. From the DOS Prompt, navigate to the \BIN directory of your Siebel Server root directory.

   For example: cd siebsrv/BIN

2. Run the MLOV Upgrade Utility in validation mode by typing the following at the command prompt:

   ssincfgw -1 language_code -v Y

   where language_code is the three-letter code (all capitals) for the language in which you want to display the GUI.

   For example, to run the MLOV Upgrade Utility in English, you would type:

   ssincfgw -1 ENU -v Y

   The Open dialog box appears.

3. Select dbsrvr.scm and then click Open.

   The Siebel Software Configuration Utility -DB Server Configuration dialog box appears.