The Management Console makes failed lookups visible so you can easily resolve the failures by adding the relevant values to the lookup table. This not only helps in building and testing your system, but also in maintaining your system when the lookup criteria has changed.

Refer to Handling Lookup Failures for details.

To resolve lookup failures:

  1. Navigate to Management>Lookup Tables. The Lookup Tables list page is displayed.
  2. Choose one of the following methods to export lookup failures:
    • Select the the appropriate table to display the lookup table details page and click the Export link for the Lookup Failures table.
    • Hover your mouse over the icon and click the Export Failures link in the popover.
  3. Save the .csv file.
  4. Edit the .csv file by adding the relevant failed lookup entry rows and entering the relevant values (or deleting the rows) in the table. Save the file.

  5. Import the file using the Import Type of Update the existing table with the values in the imported data. Refer to Importing Lookup Tablesfor details.

    The column names in the import must match the column names in the user's locale. In other words if you export failures, change locale and then import the failures, the import fails.

    The extra "Count" column that is included in the exported file will be ignored when re-importing.

    If you wish to clear all the lookup failures you added to the table, click the Cleanup Now link.