Running acUpgradeTool

To upgrade Campaign, run acUpgradeTool after you run the installers in the upgrade mode.

Before you begin

To successfully run acUpgradeTool, verify the following information:
  • The setenv file is customized with the information that the upgrade tool requires.
  • The upgrade tools are installed on the computer where you run them. If your setup is distributed, the tools must be installed on the computer where the Campaign web application is installed. If you did not install the upgrade tools during the Campaign installation, run the installer again and select only the Upgrade Tools option.
  • The appropriate database client executable file (db2, osql, or sqlplus) for the Campaign system tables data source is accessible in the PATH of the user who runs the upgrade tool.
Complete the following steps before you run the upgrade tool:
  1. Run the Campaign installer in upgrade mode.
  2. Redeploy Campaign.
  3. Restart RCT if you are using eMessage.
  4. Modify the SQL script if required, and gather information to enter when you run the tool.

About this task

Note: If you have multiple partitions, you must configure and run the upgrade tool once for each partition.

If you are upgrading from 10.0 Fix Packs to version 10.1, some errors related to database tables might occur. The errors are for tables that are already present in the database or for columns that are already present in some tables in the database. You can ignore the errors.

Errors might occur for the following tables:
  • UA_EMAILSEND
  • UA_EMAILOPEN
  • UA_EMAILCLICK
  • UA_EMAILBOUNCE
  • UA_SENTSMS
  • UA_INTERACTEDSMS
  • UA_APP_INSTALLED
  • UA_APP_UNINSTALLED
  • UA_APP_SESSIONSTARTED
  • UA_APP_SESSIONENDED
  • UA_APP_UIPUSHENABLED
  • UA_APP_UIPUSHDISABLED
  • UA_SIMPNOT_APPOPENED
  • UA_SIMPNOT_URLCLICKED
  • UA_MOB_PUSH_SEND
  • UA_GEN_EVENT_RECORD
  • UA_CAMPAIGNENGAGERESPONSEMAP
  • UA_ENGAGEETLRECORDSTATUS
  • UA_ENGAGEETLTRACKER
  • UA_SimpNot_appOpened

Procedure

Complete the following actions to run acUpgradeTool and complete the upgrade process:
  1. Start the web application server on the target system and the HCL® Marketing Software web application.
  2. Make sure that the Campaign listener is stopped.

    Stop the Campaign utilities (unica_*) that might be running. For instructions, see the IBM Campaign Administrator's Guide.

  3. Run the upgrade tool in the path where you installed Campaign, Campaign_Home/tools/upgrade/10.0+To10.1/acUpgradeTool
  4. Enter the requested information at the prompts to upgrade your system tables for the new version of Campaign.
  5. Complete one of the following steps to restart the Campaign listener:
    • On Windows™, run the cmpServer.bat file in the bin directory under your Campaign installation.
    • On UNIX™, run the following command as root:

      ./rc.unica_ac start

What to do next

Complete the following steps after you have run acUpgradeTool:
  1. Restart the Campaign listener, also known as the server.
  2. If you are using eMessage, restart the RCT.

    To restart the RCT manually, use the rct start command. The RCT script is in the bin directory under your eMessage installation.

    To restart the RCT every time you restart the operating system of the machine where the RCT is installed, add the RCT as a service. For instructions, see The MKService_rct script.

    Note: When you restart the RCT as a service, you must manually restart the RCT the first time.