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
- 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.
-
Run
Unica_home\Campaign\reports\Deliver-ddl\<DBType>\acer_scripts_<DBType>.sql
and<DBType>\upgrade\upgrade121to12101.sql
in Campaign system database. -
Run
Unica_home\Campaign\reports\schema\templates_sql_load.sql
in Platform database. - Log in to the application and navigate to Configuration > Report SQL Generator > Select Deliver Reports.
- Select the database type and download the views script, Deliver.sql.
- Run the Deliver.sql in Campaign database.
-
Configure database job for the following SMS procedures.
- SP_POPULATE_SMS_CONTACTS
- SP_POPULATE_SMS_RESPONSES