Updating lookup tables for eMessage and Interact

If you are using reports for eMessage and Interact, you must update the lookup tables. You must use your database client to run specific upgrade scripts against the system table database.

Procedure

Complete one of the following steps:
  • Complete the following steps if you are upgrading from version 8.6.0.4 or 9.0 for eMessage:
    1. In the ReportsPackCampaign\tools directory under your reports pack installation, locate the uare_lookup_create_DB_type.sql script, where DB_type is the database type appropriate for your installation of Campaign.
  • Complete the following steps for Interact
    1. In the ReportsPackInteract\tools directory under your reports pack installation, locate the uari_lookup_create_DB_type.sql script, where DB_type is the database type appropriate for your installation of Campaign.
    2. Run the appropriate version of the script against your Interact design time database.