Upgrade from version 12.1.0.0 to version 12.1.0.3
About this task
Procedure
- Verify that the environment is up and running.
- Take a backup of Insights.war and Campaign.war.
- Take a backup of the existing deployment directory.
- Copy Insights.war on the deployment directory path.
- Re-deploy new Insights.war file and start the application server.
-
Review
BIRT_RESOURCE_PATH
in web.xml in Insights deployment directory <Unica_Home>\Platform\Insights\Reports\translated\. -
Copy the following properties files to
BIRT_RESOURCE_PATH.
- Campaign_Home/reports/translated/Campaign/ *.properties
- Campaign_Home/reports/translated/Deliver/ *.properties
- Run InsightsDBUtil for data source upgrade for Campaign and Deliver products.
-
Run
Unica_home\Campaign\reports\schema\templates_sql_load.sql
in Platform database. -
Log in to the application and navigate to the following locations.
- For Campaign and Collaborate: Configuration > Report SQL Generator > Select Campaign Reports
- For Deliver: Configuration > Report SQL Generator > Select Deliver Reports
- For Interact: Configuration > Report SQL Generator > Select Interact Reports
-
Copy and replace the rpt design files for Campaign, Deliver, Interact,
Collaborate, and Plan to the Platform/Reports/Insights/.
For more configuration details, see the following sections.
- Copy the Campaign and Deliver reports folder in Unica Insights directory
- Creating and populating reporting tables for Unica Campaign and Unica Deliver
- Copy the Interact reports folder in Unica Insights directory
- Copy the Plan report folder in Unica Insights directory
- Copy the Collaborate report folder in Unica Insights directory
-
For Campaign reports, navigate to
Unica_home\Campaign\reports\ddl\<DB Type>\ directory
and run
sp_whatifofferperf.sql
in Campaign system database.Note: MariaDB is not supported, where the DB types are Oracle/SQLServer/DB2/OneDB. - Start the application server.