Configuring Siebel Business Applications > Localizing Siebel Business Applications > Converting Your Current Data for an MLOV >

Troubleshooting Problems with an MLOV Conversion

When the MLOV Converter Utility finishes, it writes log files to the following directory:

siebsrvr\log\mlov_verify_validation\output or siebsrvr\log\mlov_translate\output

It writes errors to the mlovupgd_verify.log file.

Fixing an Inconsistently Bounded List of Values or an Improperly Set Translation Table Property

If a List of Values is not bound consistently, or if the Translation Table property is not set to S_LST_VAL, then the utility logs the follow message in the mlovupgd_verify.log file:

The following Validation checks for:

1- Two or more columns defined in the same LOV domain are inconsistently bounded (one bounded, one not)

2- Two or more columns are defined in the same LOV domain and at least one of them does not have a Translation Table Name of S_LST_OF_VAL

The utility includes a log entry for each error it encounters. The utility includes the LOV type, column, and table.

To fix an inconsistently bounded list of values or an improperly set Translation Table property

1. Make sure the list is consistently bounded.
2. For more information, see Step 5.
3. Make sure the Translation Table property is set properly.
4. For more information, see Step 5.
5. To make sure you corrected all errors, run the MLOV Converter Utility in validation mode.

Fixing a LOV Domain That Is Not in the S_LST_OF_VAL Table

If a list of values domain is not represented in the S_LST_OF_VAL table, then the utility logs the following message in the mlovupgd_verify.log file:

The following Validation checks for:

LOV domains in the repository that are not represented in S_LST_OF_VAL

In this situation, a list of values domain does reside in the Siebel repository but it fails one of the following tests:

• It is not represented as a value in the list of values table.
• The list of values type is not LOV_TYPE.

This problem can occur in the following situations:

• You delete a record in the list of values table instead of deactivating it. For more information, see Deactivating an MLOV Record Instead of Deleting It.
• You enter an incorrect entry in the LOV Type property for a column added using a database extension.

To fix a LOV domain that is not in the S_LST_OF_VAL table

1. Correct the LOV Type property:
   1. In Siebel Tools, correct the entry in the LOV Type property.

      For more information, see Adding Records for All Supported Languages.

   2. Compile your changes.

      A script creates a matching record in the list of values table for any values it finds in the target tables that do not include matching records in the list of values table. The script marks these records as inactive.

   3. In the Siebel client, navigate to the Administration - Data screen, and then add language-specific entries for the base records you just compiled.

      This allows Siebel CRM to display the values in the active language.

2. Add the list of values domain:
   1. In the Siebel client, navigate to the Administration - Data screen, and then click the List of Values link.
   2. Add the list of values domain and set the Type field to LOV_TYPE.