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 modifications.

      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.