Procedure: Fast upgrade Contact Optimize

About this task

Procedure

  1. Restore CO system tables backup from old / base version to system tables schema used for clean 11.0 environment.
  2. Take a File system backup for the “CO_HOME/partitions/partition1" directory.
  3. Copy all partitions data from the old environments partition folders to the clean 11.0 environments CO partition folder.
  4. Execute following script on Campaign 11.0 system database:
    1. Execute following script on Campaign 11.0 system database:

      -- 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 >

    2. Execute the script that resides at the following location on the Campaign 11.0. system database: <CONTACTOPTIMIZE_HOME>/ddl/aco_extra_indexes_ora.sql

Setting the Contact Optimize – Help About > Version

Procedure

  1. Change the CO version in the Marketing Platform registration:
    1. Export the version configuration using the following command on a clean 11.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. Change the version to 11.0.0.0.0.GA_BUILD".

      <displayNameKey>Optimize Version</displayNameKey>

      <displayName>Optimize Version</displayName>

      <value>11.0.0.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 Campaign configurations in the Marketing Platform configuration:
    1. Change the “serverHost�? in the Settings of 'unicaACOListener'(Affinium|Campaign|unicaACOListener)
    2. Remap all the system tables in the Campaign table mapping. This can be done using following the steps:
      Stop the listener.
      Remove “unica_tblcache.mgr�? from <CO_HOME>/partitions/partition/conf.
      Start the listener.
      Navigate to Campaign settings > Table mapping.