Procedure: Fast upgrade Unica Optimize

About this task

Procedure

  1. Restore Optimize system tables backup from old / base version to system tables schema used for clean 12.0 environment.
  2. Copy Optimize old session data from source environment to 12.0 environment: Copy Optimize/partitions/partition1/reports content into Campaign/partitions/partition1/reports directory. You will need to repeat this steps for each partition. Copy Optimize/partitions/partition1/logs content into Campaign/partitions/partition1/logs directory. You will need to repeat this steps for each partition.
  3. This step is not applicable to Fast Upgrade from version 11.0 to version 12.0. Execute following script on Unica Campaign 12.0 system database:
    1. Execute following script on Unica Campaign 12.0 system database:

      8.0 Updates

      Oracle:

      ALTER TABLE UACO_OptSession MODIFY CustomSettingsXML VARCHAR(4000);

      SQL:

      ALTER TABLE UACO_OptSession MODIFY CustomSettingsXML VARCHAR(4000);

      DB2:

      ALTER TABLE UACO_OptSession ALTER COLUMN CustomSettingsXML SET DATA TYPE VARCHAR(4000);

      -- 9.0 Updates --

      ALTER TABLE UACO_OptSession ADD AgentChannelName VARCHAR(192);

      ALTER TABLE UACO_OptSession ADD AgentInfoTemplateTable VARCHAR(192);

      ALTER TABLE UACO_OptSession ADD AgentCustomerRelTemplateTable VARCHAR(192);

      ALTER TABLE UACO_OptSession ADD CustomSettingsFlag int;

      ALTER TABLE UACO_OptSession ADD CustomSettingsXML VARCHAR(4000);

      ALTER TABLE UACO_OptSession ADD LastRunType VARCHAR(192);

      UPDATE UACO_OptSession SET LastRunType = 'Production Run';

      CALL SYSPROC.ADMIN_CMD ('REORG TABLE UACO_OptSession');

      -- 9.1.1 Updates --

      ALTER TABLE UACO_OptSession ADD AgentChannelName VARCHAR(192);

      ALTER TABLE UACO_OptSession ADD AgentInfoTemplateTable VARCHAR(192);

      ALTER TABLE UACO_OptSession ADD AgentCustomerRelTemplateTable VARCHAR(192);

      ALTER TABLE UACO_OptSession ADD LastRunType VARCHAR(192);

      UPDATE UACO_OptSession SET LastRunType = 'Production Run';

      -- 10.0 Updates --

      < No script needed >

      -- 10.1 Updates --

      < No script needed >

      -- 11.0 Updates --

      < No script needed >

    2. This step is not applicable to Fast Upgrade from version 11.0 to version 12.0. Execute the script that resides at the following location on the Unica Campaign 12.0 system database: <CAMPAIGN_HOME>/ddl/aco_extra_indexes_<db>.sql

Setting the Unica Optimize – Help About > Version

Procedure

  1. Change the Optimize version in the Unica Platform registration:
    1. Export the version configuration using the following command on a clean 12.0 environment:configTool.sh -x -p "Affinium|Campaign|about" -f <PLATFORM_HOME>/conf/campaign_about.xml
    2. Edit the campaign_about.xml file generated by the above command. Remove the Optimize version and build number details tags from the following XML. 
      <displayNameKey>Optimize Version</displayNameKey>

<displayName>Optimize Version</displayName>

<value>11.0.1.0.0.33</value>
    3. Import the above edited file using the following command:configTool.sh -v -i -o -p "Affinium|Campaign" -f <PLATFORM_HOME>/Platform/conf/campaign_about.xml
  2. Change Unica Campaign configurations in the Unica Platform configuration:
    1. Change the “serverHost" in the Settings of 'unicaACOListener'(Affinium|Campaign|unicaACOListener)
    2. Remap all the system tables in the Unica Campaign table mapping. This can be done using following the steps:
      Stop the listener.
      Remove “unica_tblcache.mgr" from <CAMPAIGN_HOME>/partitions/partition/conf.
      Start the listener.
      Navigate to Unica Campaign settings > Table mapping.

Optimize post-upgrade functional check

Perform UAT on Optimize application. Ensure that all the sessions are opening and the run is successful.

About this task

Note: For versions 12.0 and 12.0.0.1, to execute Optimize sessions, users are required to apply for licenses. For more details, contact the HCL Support or Sales team.