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
-
To upgrade the Unica Campaign system database, complete the following
steps:
- Access the location Campaign_Home\reports\Deliver-ddl\<DBType>\upgrade and run the command upgrade12103to12104.sql.
- 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.
-
To refresh the report files in the installation directory, complete the
following steps:
- In the Unica_home\Campaign\reports\Affinium Campaign\Deliver Reports location, back up existing Deliver report design files.
- 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.
- 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.
-
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
- 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.
- 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.