Running the upgrade tools for the runtime environment

Before you run the upgrade tools, start the web application server on the target system.

The Interact runtime environment uses the Interact system tables as the database.

When running the upgrade tools for the runtime environment, you can stop the upgrade at any prompt by typing abort.

The latest versions of the upgrade tools are in the /tools/upgrade directory under your Interact runtime environment installation. Enter the requested information at the prompts to upgrade your tables for the new version of Interact. When the tool completes successfully, your upgrade process is complete.

Run the SQL scripts once for each server group.

Run the tools in the following order to upgrade the Interact runtime environment:

Run aciUpgradeTool_runtab to update the systemTablesDataSource and the Interact runtime configuration properties.

If you are using built-in learning, run aciUpgradeTool_lrntab to update the learningTablesDataSource.

If you are using cross-session response tracking, modify the /tools/upgrade/conf/ACIUpgradeTaskList_crhtab.properties file if necessary, and then run aciUpgradeTool_crhtab to update the contactAndResponseHistoryDataSource.

You must modify the ACIUpgradeTaskList_crhtab.properties file if you are upgrading from Interact version 8.x and if the Interact runtime data source (as specified in the contactAndResponseHistoryDataSource configuration property under the Interact | general category) is not the same as the Campaign system tables data source.

If you are using the scoreOverride or defaultOffers tables, run aciUpgradeTool_usrtab to update the prodUserDataSource.

After you finish upgrading the Interact design time and runtime environment, redeploy the newly installed version of the Interact runtime environment in your web application server.