Procedure: Fast upgrade Unica Interact

Before you begin

Pre-requisites to upgrade from Unica Interact 8.6.x/later version to Unica Interact 12.0:

Procedure

  1. Ensure that Unica Platform and Unica Campaign are upgraded successfully on the target setup. Install Interact 12.0 on the setup.
  2. Take a backup for source system Databases InteractDT, InteractRT,Interact Learning, Interact prod
  3. Make sure that the Interact related files in Campaign's 'partition' folder are copied from the source system to the target system.
  4. Restore the backed up database schema on target system.
  5. Create data sources on the target application server and point to the new database schema. You can use the same JNDI names as those in the source system to save effort in doing manual changes.

Upgrading Interact DT

Procedure

  1. Update setenv.sh with the values required for upgrade. For details on the environment variables in the setenv.sh file, refer to the Interact Upgrade guide.
    1. Navigate to the path: <Interact_Home>/interactDT/tools/upgrade/ Set the following variables in the setenv.sh file:

      set JAVA_HOME='<Installation Path >/jre'.

      set JDBCDRIVER_CP=Actual location of the databasedriver along with database driver

      For example: set JDBCDRIVER_CP=/opt/IBM/FastUpgrade12/ojdbc8.jar

      set JDBCDRIVER_CLASS=Datasase driver

      set JDBCDRIVER_URL=Database url

    2. Change the Log file Name and location if required
    3. Navigate to <Interact_Home>\interactDT\tools\upgrade\conf
    4. Edit file ACIUpgradeTaskList.properties and change the value of CHOICES_FOR_PREVIOUS_VERSIONS=8.6.x or other base version you are upgrading from
      Note: If CHOICES_FOR_PREVIOUS_VERSIONS is already present that you are upgrading from, then do not make change in the value.
  2. Pre-requisite to complete before running the Interact upgrade tool:Update the jdbc.properties file under: <Installation_Home>\install\ <Interact_Home>\interactDT\tools\upgrade\conf
    The “jdbc.properties"  file must  contain the correct JDBC URL, Platform system database userID and encrypted password. If this information is incorrect, then the Interact upgrade tool will fail with database authentication related errors.
  3. Execute Interact “aciUpgradeTool.sh/bat". This Upgrade tool execution is similar to the usual acUpgradeToolexecution of Campaign.
  4. While executing the upgrade tool you are prompted for database details. Enter the Interact DesignTime Database details.
  5. The tool will also prompt for “select base version to upgrade". You will able to see the upgrade version specified for CHOICES_FOR_PREVIOUS_VERSIONS.
    Select the fast upgrade base version to upgrade from.
  6. Once the upgrade tool execution completes, check the related logs to ensure that no errors were encountered during the upgrade tool execution.

Upgrading Interact RT, Interact learning and Interact Production databases

Procedure

  1. Update setenv.sh with required values for Unica Interact upgrade. For details on the environment variables in the setenv.sh file, refer to the Unica Interact Upgrade guide.
    1. Navigate to <Interact_Home>/tools/upgrade. Set the following variables in the setenv.sh file:

      set JAVA_HOME= <Installation Path >/jre

      set JDBCDRIVER_CP= Actual location of the database driver along with database driver

      ex: set JDBCDRIVER_CP= /opt/IBM/FastUpgrade12/ojdbc8.jar

      set JDBCDRIVER_CLASS = Datasase driver

      set JDBCDRIVER_URL = Database url

      The database URL can be the same in DB2 and Oracle if you are using the same DB with different schemas.

      In case you need to update the database URL for the SQLServer, update the respective DB before executing the upgrade tool.

      Change the log file name and location if required.

    2. Navigate to <Interact_Home>\tools\upgrade\conf edit file ACIUpgradeTaskList_crhtab.properties and change the value of CHOICES_FOR_PREVIOUS_VERSIONS=8.6.x or other base version you are upgrading from.
      Note: If CHOICES_FOR_PREVIOUS_VERSIONS is already present that you are upgrading from, then do not make change in the value.
    3. Repeat the above change for the ACIUpgradeTaskList_lrntab.properties, ACIUpgradeTaskList_runtab.properties, ACIUpgradeTaskList_usrtab.properties files at the above mentioned path.
  2. Pre-requisite to complete before running the Interact upgrade tool: Update the jdbc.properties file under: <Installation_Home>\install\ <Interact_Home>\tools\upgrade\conf
    The “jdbc.properties" file must contain the correct JDBC URL, Platform system database userID and encrypted password. If this information is incorrect, the Interact upgrade tool will fail with database authentication related errors.
  3. Execute Interact “aciUpgradeTool_crhtab .sh/bat" . This Upgrade tool execution is similar to the usual aciUpgradeTool.
    1. While executing the upgrade tool you are prompted for database details mention the details of the Interact DesignTime Database. The tool will also prompt for “select base version to upgrade". You will see the upgrade version specified with CHOICES_FOR_PREVIOUS_VERSIONS= Select the fast upgrade base version you are upgrading from.
    2. Once the upgradetool execution completes, check the related logs and ensure that no errors were encountered during the upgrade tool execution.
  4. Execute Interact “aciUpgradeTool_runtab.sh/bat". This Upgrade tool execution is similar to the usual aciUpgradeTool.
    1. While executing the upgrade tool you are prompted for database details. Enter the Interact RunTime Database details. The tool will also prompt for “select base version to upgrade", you can see the upgrade version specified in CHOICES_FOR_PREVIOUS_VERSIONS. Select the fast upgrade base version you are upgrading from.
    2. Once the upgradetool execute completes, check the related logs and ensure that no errors were encountered during the upgrade tool execution.
  5. Execute Interact “aciUpgradeTool_lrntab .sh/bat". This Upgrade tool execution is similar to the usual aciUpgradeTool.
    1. While executing the upgrade tool you are prompted for database details. Enter the Interact Learning Database details.The tool will also prompt for “select base version to upgrade". You can see the upgrade version specified with CHOICES_FOR_PREVIOUS_VERSIONS. Select the fast upgrade base version to upgrade from.
    2. Once the upgradetool execution completes, check the related logs and ensure that errors were not encountered during the upgrade tool execution.
  6. Execute Interact “aciUpgradeTool_usrtab.sh/bat". This Upgrade tool execution is similar to the usual aciUpgradeTool.
    1. During the execution of the upgrade tool, you are prompted for database details. Enter the Interact Production/prod Database details. The tool will also prompt for “select base version to upgrade". You can see the upgrade version specified with CHOICES_FOR_PREVIOUS_VERSIONS. Select the fast upgrade base version to upgrade from.
    2. Once the upgradetool execution completes, check the related logs and ensure no errors were encountered during the upgrade tool execution.

Execute ILPB Migration Uitility

About this task

Run ILPB migration utility for the migration of data from old predicate and enableStateId columns to new predicate columns scorepredicate, scorepredicateenabled, eligibilitypredicate and eligibilitypredicateenabled, EffectiveDate and ExpirationDate for the ILPB tables.

Properties setups for the ILPB migration upgrade utility

Procedure

  1. Navigate to path <Installation_Directory>\Interact\tools\upgrade\conf and open ACIILPBUpgradeTaskList_usrtab.properties file.

    ILPB_TABLES_TO_UPDATE – Append the ILPB table (whitelist offers, default offers, offer by SQL) names which you want to migrate data from old columns to new predicate columns. The utility work only on the tables mentioned for this property.

    ILPB_MIGRATIONTASK_BATCHSIZE - You can set this property for specifying the batch size for data update operations of this utility.

  2. Run the standalone batch file aciILPBUpgradeTool_usrtab.bat or the shell script file aciILPBUpgradeTool_usrtab.sh from path "<Installation_Directory>\Interact\tools\upgrade" to run the migration utility.

Updating the JDBC file in InteractRT WAR

About this task

In case you do not want to reuse the Platform schema used in the 12.0 clean installation and rather want to use another user schema, follow the additional steps underneath:

Procedure

  1. Take a back up of the interactRT.war file from the 12.0 environment (Interact/interactRT.war).
  2. Unwar the interactRT.war file.
  3. Copy the jdbc.properties file from Platform/tools/bin/ directory and paste it under interactRT.war/WEB-INF/classes.
  4. Re-war the interactRT.

Post Upgrade

Procedure

  1. Register Interact DT Rest API Filter V2. Navigate to the PLATFORM_HOME/tools/bin directory. Execute the following commands:

    configTool.bat -vp -p "Affinium|suite|security|apiSecurity|interact" -f <Interact_Home>\interactDT\conf\ Interact_API_V2_Filter.xml

  2. Interact version registration:
    1. Execute the following command on the source environment: Navigate to the PLATFORM_HOME/tools/bin directory. Execute the command: ./configTool.sh -x -p "Affinium|Interact|about" -f Interact_about.xml
    2. Update the product name from 'IBM Interact' to 'Unica Interact' in the 'Interact_about.xml"' file.Note: Do not update the product name if you are upgrading from 11.0 -> 11.x in the Interact_about.xml file.
    3. Copy the exported output on the 12.0 - Destination system under the PLATFORM_HOME/tools/bin directory.
    4. Modify the version information in "Interact_about.xml" file referring to the Interact version in version.txt.For example:<value>12.0.0.<Build number as per version.txt></value></property>The following are the lines from 8.6.x
      <property id="6261" name="support" type="string_property" width="40"> 
      <value>https://customercentral.unica.com%3C/value%3E</value
    5. Update the following property.
      <property id="6260" name="java" type="string_property" width="40">
                      <value>IBM Corporation 2.4</value>
              </property>
      to
      <property id="6260" name="java" type="string_property" width="40">
       <value>HCL Technologies Ltd.</value>
       </property>
    6. Execute the following command on the destination 12.0 environment:./configTool.sh -v -o -i -p "Affinium|Interact" -f Interact_about.xml
    7. For the Interact sub component version, execute the following commands on the destination 12.0 environment.

      Navigate to the PLATFORM_HOME/tools/bin directory.

      Execute command: ./configTool.sh -i -p "Affinium|Campaign|about|components " -f <INTERACT_HOME>/interactDT/conf/interact_subcomponent_version.xml –o

  3. This step is not required if you are upgrading from 11.x version. You must update the old Interact navigation with a new one.
  4. Execute the following commands on the destination 12.0 environment:

    Remove old menu: configTool.bat -d -p "Affinium|suite|uiNavigation|mainMenu|Campaign|Interactive Channels" -o

    Add the new menu: configTool.sh/bat -i -p "Affinium|suite|uiNavigation|mainMenu" "full_path_to_Interact_installation_directory/conf/interact_navigation.xml"

  5. Register Unica Interact settings as configuration menu under "Affinium|suite|uiNavigation|settings" menu using full_path_to_Interact_installation_directory/interactDT/conf/interact_setup_navigation.xml.
  6. Platform – DBResourceBundle: The following steps imports resource bundles in Unica Platform. Execute the script underneath as specified: a. b.
    1. Navigate to <platform_home>/tools/bin.
    2. Run this command. DBResourceBundle.sh /bat -P interact-F <Interact_home>/resourcebundles
  7. If you have added any custom entries in the 'interact_log4j.xml' file on source 8.6 setup, then you must copy those custom entries into the target setup in the newly added 'interact_log4j2.xml' file.
  8. Deploy Interact RT WAR file.
  9. Update the configuration instanceURLs accordingly for your ServerGroup defined at Affinium|Campaign|partitions|partition1|Interact|serverGroups.

The second Interact runtime

Procedure

  1. Repeat the following steps for each Interact runtime if you have used a different server group and Platform.
  2. Install New Platform 12.0 with Interact RT.
  3. Perform the Platform upgrade and make the setup ready. (Refer the Platform Upgrade Guide.)
  4. Copy and restore the InteractRT database from the source to the target.
  5. Upgrade the database from source database to 12.0 by running the aciupgrade utility for RT.
  6. Create data sources on the target application server using the same JNDI names as the source setup.
  7. Deploy InteractRT.war.

Important

CFS updates: If the customer is using SOAP, then generate the proxy code based on the new WSDL and rebuild the CFS code using the new proxy.

Notes

Procedure

  • After Upgrade, it is observed that a Configuration Node sessionManagement is displayed under:Affinium|interact|. Removal of this configuration can be done using the Platform configTool.sh/configTool.bat tool.
  • After upgrade, it is observed that configuration Node treatmentStore is displayed under Affinium|Interact|services|contactHist|. Removal of this configuration can be done using the Platform configTool.sh/configTool.bat tool.
  • In case, after deployment during access you encounter the DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7 error, then contact your DBA and run the REORG query on the necessary database tables.
  • Removal steps are not applicable if you are upgrading from 11.x to 12.0.

Configure BIRT reports with Interact

Complete the following steps.

Procedure

  1. Import Interact Reports schemas in Platform configuration.

    Navigate to "<INTERACT_HOME>/reports/tools".

    Run the import_all.sh/bat script.

  2. For Reports pack configurations, see the BIRT Reports Installation and Configuration guide.