Upgrade from version 12.1.0.0 to version 12.1.0.3

About this task

To upgrade from version 12.1.0.0 to version 12.1.0.3, perform the following steps.

Procedure

  1. Verify that the environment is up and running.
  2. Take a backup of Insights.war and Campaign.war.
  3. Take a backup of the existing deployment directory.
  4. Copy Insights.war on the deployment directory path.
  5. Re-deploy new Insights.war file and start the application server.
  6. Review BIRT_RESOURCE_PATH in web.xml in Insights deployment directory <Unica_Home>\Platform\Insights\Reports\translated\.
  7. Copy the following properties files to BIRT_RESOURCE_PATH.
    • Campaign_Home/reports/translated/Campaign/ *.properties
    • Campaign_Home/reports/translated/Deliver/ *.properties
  8. Run InsightsDBUtil for data source upgrade for Campaign and Deliver products.
  9. Run Unica_home\Campaign\reports\schema\templates_sql_load.sql in Platform database.
  10. 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
  11. 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.
  12. 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.
  13. Start the application server.