Procedure: Fast upgrade Unica Deliver

About this task

To perform the fast upgrade of Unica Deliver from 10.1.x, 11.x.x, to 25.1.0/25.1.0.1, complete the following steps:

Procedure

  1. Open a command prompt and navigate to <PLATFORM_HOME>/tools/bin and execute the following commands.
    • configTool.bat / sh -u eMessage
    • configTool.bat / sh -d -p "Affinium|Campaign|partitions|partition1|server|internal|eMessageInstalled" -o
    • configTool.bat / sh -d -p "Affinium|Campaign|partitions|partition1|eMessage" -o
    • configTool.bat / sh -r Deliver -f "<CAMPAIGN_HOME>\Deliver\conf\deliver_configuration.xml"
    • configTool.bat / sh -v -i -p "Affinium|suite|uiNavigation|settingsMenu" -f "<CAMPAIGN_HOME>\Deliver\conf\deliver_op_odsettings_navigation.xml"
    • configTool.bat / sh -v -i -p "Affinium|suite|uiNavigation|mainMenu|Campaign" -f "<CAMPAIGN_HOME>\Deliver\conf\deliver_op_mailings_navigation.xml"
    • configTool.bat / sh -v -i -p "Affinium|suite|uiNavigation|mainMenu|Campaign" -f "<CAMPAIGN_HOME>\Deliver\conf\deliver_op_documents_navigation.xml"
    • configTool.bat / sh -v -i -p "Affinium|suite|uiNavigation|mainMenu|Analytics" -f "<CAMPAIGN_HOME>\Deliver\conf\deliver_op_analytics_navigation.xml"
    • configTool.bat/sh -v -i -p "Affinium|suite|uiNavigation|mainMenu|Campaign" -f "<CAMPAIGN_HOME>/Deliver/conf/deliver_op_new_documents_navigation.xml"
  2. Log in to Platform and navigate to Settings > Configuration.
  3. Navigate to Affinium|Campaign|partitions|partition1|Deliver and provide value for deliverPluginJarFile as following.

    deliverPluginJarFile <CAMPAIGN_HOME>/Deliver/plugin/deliverplugin.jar

  4. Navigate to Affinium|Campaign|partitions|partition1|server|internal and enable DeliverInstalled= yes.
  5. Navigate to Affinium|Deliver|partitions|partition1|dataSources|systemTables and configure systemTables properties as per your Campaign schema.
  6. Assign UNICA_HOSTED_SERVICES datasource to asm_admin user with appropriate account and its password.

    Ensure to take a backup of Campaign system table schema before executing the next steps.

  7. Navigate to <CAMPAIGN_HOME>\Deliver\ddl and execute ace_op_drop_systab_ora.sql, if you possess Oracle Campaign system schema, else execute ace_op_drop_systab.sql on Campaign system schema.
  8. Navigate to <CAMPAIGN_HOME>\Deliver\ddl\unicode and execute ace_op_systab_<DB_TYPE>.sql on Campaign system schema.
  9. Navigate to <CAMPAIGN_HOME>\Deliver\ddl and execute ace_op_populate_systab_<DB_TYPE>.sql on Campaign system schema.
  10. Restart web app server and listener.

    To perform the fast upgrade of Unica Deliver from Version 12.1.x to 25.1.0/25.1.0.1 , complete the following steps.

    Execute Below scripts on Target 25.1/25.1.0.1 Campaign schema:
    Upgrade From base version - 12.1.x to 25.1.0 / 25.1.0.1 SQL scripts to execute
    Maria DB <Campaign_Home>\tools\upgrade\12.1+To25.1/ace_upgrade_mariadb.sql
    Oracle <Campaign_Home>\tools\upgrade\12.1+To25.1/ace_upgrade_ora.sql
    Sql Server <Campaign_Home>\tools\upgrade\12.1+To25.1/ace_upgrade_sqlsvr.sql
    DB2 <Campaign_Home>\tools\upgrade\12.1+To25.1/ace_upgrade_db2.sql
    Postgres <Campaign_Home>\tools\upgrade\12.1+To25.1/ace_upgrade_postgresql.sql
    Maria DB - unicode <Campaign_Home>\tools\upgrade\12.1+To25.1/ace_upgrade_mariadb_unicode.sql
    Oracle - unicode <Campaign_Home>\tools\upgrade\12.1+To25.1/ace_upgrade_ora_unicode.sql
    Sql Server - unicode <Campaign_Home>\tools\upgrade\12.1+To25.1/ace_upgrade_sqlsvr_unicode.sql
    DB2 - unicode <Campaign_Home>\tools\upgrade\12.1+To25.1/ace_upgrade_db2_unicode.sql
    Postgres-unicode <Campaign_Home>\tools\upgrade\12.1+To25.1/ace_upgrade_postgresql_unicode
    Note: Please ignore if there are errors stating table already exists or cannot change <Column_name> used in a foreign key constraint.
    1. Generate and configure public / private key pair for SFTP authentication. Refer Chapter 3. Connections to message services from https://doc.unica.com/products/deliver/25_1_0/en_us/UnicaDeliver25_1_0StartupAdminGuide_en_us.pdf for complete steps. (If target VM is separate / different VM than source) and share with Unica Deliver Devops.

    2. Login to Unica Platform and configure SystemTables by navigating to Affinium|Deliver|partitions|partition1|dataSources|systemTables. Specify target unica campaign 25.1/25.1.0.1 schemaName and jdbcURI.

    3. Navigate to Affinium|Campaign|partitions|partition1|Deliver and give correct path for deliverPluginJarFile.
    4. Restart Campaign and Platform.
    5. Start RCT (Make sure to stop RCT from base Environment).