Upgrade from version 12.1.0.3 to version 12.1.0.4

To upgrade from version 12.1.0.3 to version 12.1.0.4, perform the following steps:

Procedure

  1. To upgrade the Unica Campaign system database, complete the following steps:
    1. Access the location Campaign_Home\reports\Deliver-ddl\<DBType>\upgrade and run the command upgrade12103to12104.sql.
    2. Access the location Campaign_Home\reports\Deliver-ddl\<DBType> and run the command acer_scripts_<database-name>.sql, where <database-name> is the name of the database used. For example, if you are using Oracle, the <database-name> is ora.
  2. To refresh the report files in the installation directory, complete the following steps:
    1. In the Unica_home\Campaign\reports\Affinium Campaign\Deliver Reports location, back up existing Deliver report design files.
    2. Move the report design files from Unica\home\Campaign\reports\Affinium Campaign\Deliver Reports location to Unica_home\Platform\Insights\Reports\campaign\partitions\partition1\Affinium Campaign\Deliver Reports location.
  3. Update the datasource in the Report design files. For more information, see Update data source in Unica Insights report design files using Unica Insights utility.
  4. Set up the database jobs for WhatsApp Contacts, and setup Responses for WhatsApp and Mobile report. For more information, see For Unica Deliver only: How to schedule and run stored procedures.
    The procedure names are:
    • sp_populate_mobile_Responses
    • sp_populate_WhtsApp_Contacts
    • sp_populate_WhtsApp_Responses
  5. Copy the Unica Deliver translation files from <Unica_Home>\Campaign\reports\translated\Deliver*.properties location and paste it to the <Unica_Home>\Platform\Insights\Reports\translated location.
  6. In the Unica Campaign database, refresh the uare_lookup_population script data. Navigate to Unica_Home\Campaign\reports\tools\ location and execute the uare_lookup_populate*.sql script for all the languages.