Procedure: Fast upgrade Unica Optimize

About this task

Procedure

  1. Optimize system tables are migrated while migrating Campagin system tables
  2. Copy Optimize old session data from source environment to 12.1 environment:
    1. Copy Optimize/partitions/partition1/reports content into Campaign/partitions/partition1/reports directory. You will need to repeat this steps for each partition.
    2. Copy Optimize/partitions/partition1/logs content into Campaign/partitions/partition1/logs directory.
    3. Repeat the above steps for each partition.
  3. This step is not applicable to Fast Upgrade from version 11.0 to version 12.1. Execute following script on Unica Campaign 12.1 system database:
    1. Execute following script on Unica Campaign 12.1 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';

      Execute the following step only if you are using DB2 database for system tables.

      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. Do not perform the following step if you are upgrading from prior 12.0 version.Execute the script that resides at the following location on the Unica Campaign 12.1 system database:

      <CAMPAIGN_HOME>/ddl/aco_extra_indexes_<db>.sql

Setting the Unica Optimize Configurations

Procedure

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 higher, to execute Optimize sessions, users are required to apply for licenses. For more details, contact the HCL Support or Sales team.