Upgrade from version 12.1.0.0 to 12.1.0.1

Deliver reports must work on version 12.1.0 base environment. You must take a backup of all reporting folders "Unica_home\Platform\Insights\Reports ". You must take the backup of Campaign and Platform database as well.

About this task

Note: Unica Insights supports four characters for locale. For example, in the Unica_home\Campaign\reports\tools directory, if there are two lookup populate SQL files for the french locale:
  • uare_lookup_populate_fr.sql
  • uare_lookup_populate_fr_FR.sql

you must execute uare_lookup_populate_fr_FR.sql and ignore the other file.

To perform the upgrade of Unica Insights Reports from version 12.1.0.0 to version 12.1.0.1, complete the following steps:

Procedure

  1. Copy and replace report design files from Unica_home\Campaign\reports to Unica_home\Platform\Insights\Reports, as explained in the Copy the Campaign and Deliver reports folder in Unica Insights directory section.
  2. Run Unica_home\Campaign\reports\Deliver-ddl\<DBType>\acer_scripts_<DBType>.sql and <DBType>\upgrade\upgrade121to12101.sql in Campaign system database.
  3. Run Unica_home\Campaign\reports\schema\templates_sql_load.sql in Platform database.
  4. Log in to the application and navigate to Configuration > Report SQL Generator > Select Deliver Reports.
  5. Select the database type and download the views script, Deliver.sql.
  6. Run the Deliver.sql in Campaign database.
  7. Configure database job for the following SMS procedures.
    • SP_POPULATE_SMS_CONTACTS
    • SP_POPULATE_SMS_RESPONSES