Updating lookup tables for eMessage and Interact

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

About this task

Depending on your product, complete one of the following steps:

Procedure

  • To upgrade eMessage from version 8.6.0.4 or 9.0: In the ReportsPackCampaign\tools directory under your reports pack installation, run the uare_lookup_create_DB_type.sql script.

    Where DB_type is the database type appropriate for your installation of Campaign.

  • For Interact, do the following steps:
    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.