Running the Unica Interact upgrade tools

Run the upgrade tool for the design time environment to update the Unica Interact tables in the Unica Campaign system tables. Run the upgrade tools for the runtime environment to update the Unica Interact run time, learning, contact history, response history, and user profile tables.

Running the upgrade tool for the design time environment

Before you begin

If you are upgrading from 12.1.0.3 to 12.1.0.4 or higher, you must specify the required values again in the setenv.sh/.bat file.

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

About this task

The Unica Interact design time environment uses the Unica Campaign system tables as the database.

When running the upgrade tool for the design time environment, you can stop the upgrade at any prompt by typing abort.

The user who runs the upgrade tool must have access to the appropriate database client executable files (sqlplus, db2, or osql) for the Campaign system tables data source.

The latest version of the upgrade tool (aciUpgradeTool) is in the /interactDT/tools/upgrade directory under your Unica Interact design time environment installation. Enter the requested information at the prompts to upgrade your system tables for the new version of Unica Interact. When the tool completes successfully, your upgrade process is complete.

If you have multiple partitions, configure and run the upgrade tool once for each partition.
Note: If audience specific Detail contact history tables (example: UA_DTLContactHist) are not mapped in Campaign configuration under the path partitions|partition#|systemTableMapping before upgrading environment for upgraded customers (if customers are upgrading to version 12.1.0.3 and onwards), then upgraded customers must add "ABTestBranchID" column in audience specific Detail contact history tables (example: UA_DTLContactHist) manually to view A/B Test Performance related informations. Upgraded customers can add this column by using the following query:
  • For Oracle DB:

    ALTER TABLE <audience specific Detail contact history table> ADD ABTestBranchID NUMBER(19,0);

  • For other DBs:

    ALTER TABLE <audience specific Detail contact history table> ADD ABTestBranchID BIGINT;

  • Example:

    ALTER TABLE UA_DTLContactHist ADD ABTestBranchID BIGINT;

Note: In case of a failure in migration of old strategies, you can use Strategy migration utility tool to migrate specific strategy to smart strategy after fixing the issue.

Running the upgrade tools for the runtime environment

Before you begin

If you are upgrading from 12.1.0.3 to 12.1.0.4 or higher, you must specify the required values again in the setenv.sh/.bat file.

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

About this task

The Unica Interact runtime environment uses the Unica 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 Unica Interact runtime environment installation. Enter the requested information at the prompts to upgrade your tables for the new version of Unica Interact. When the tool completes successfully, your upgrade process is complete.

Important: Run the SQL scripts/upgrade tools once for each server group.

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

Procedure

  1. Run aciUpgradeTool_runtab to update the systemTablesDataSource and the Unica Interact runtime configuration properties.
  2. If you are using built-in learning, run aciUpgradeTool_lrntab to update the learningTablesDataSource.
  3. 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 Unica Interact version 8.x and if the Unica Interact runtime data source (as specified in the contactAndResponseHistoryDataSource configuration property under the Interact | general category) is not the same as the Unica Campaign system tables data source.

  4. If you are using the scoreOverride or defaultOffers tables, run aciUpgradeTool_usrtab to update the prodUserDataSource.
    Note: If customers are having Platform-Campaign on one VM and Platform-Interact on second VM, then on Platform-Interact VM users must copy jdbc.properties from Platform-Campaign VM and replace by taking backup at the following locations <Interact_Home>/tools/bin and <Install_Location>/install and run aciUpgradeTool_crhtab.sh.

    After running aciUpgradeTool_crhtab.sh tool, the users must restore jdbc.properties file on Platform-Interact VM.