Procedure: Fast upgrade Unica Campaign
Unica Campaign pre-upgrade
Procedure
- Import the Unica Campaign system tables backup from the old / base version to the system tables schema used in the clean 12.1 environment.
- Take a File system backup of the CAMPAIGN_HOME/partitions/partition1 directory.
- Copy all the partitions data from the old environment's partition folders to the clean 12.1 environment Unica Campaign partition folder.
Upgrading Unica Campaign
Procedure
-
Update the setenv.sh file the with required values for
the Unica Campaign upgrade. For details on environment variables in the
setenv.sh file, refer to the Unica Campaign 12.1 Upgrade guide.
- Pre-requisite to complete before running the Unica Campaign upgrade tool: The <CAMPAIGN_HOME>/install directory “jdbc.properties" file contains the correct JDBC URL, Platform system database userID and encrypted password. User will need to copy paste jdbc.properties file from Platform/tools/bin directory to Campaign/install directory. If this information is incorrect Campaign upgrade tool will fail with database authentication related errors.
- Execute Campaign “acUpgradeTool.sh". This Upgrade tool execution is similar to the usual acUpgradeTool execution. During the upgrade tool execution when prompted for “select base version to upgrade", you can see the upgrade version specified with the JVM option “-DFAST_UPGRADE_VERSION=<BASE_VERSION>". Select the fast upgrade base version to upgrade from.
- Updating the JDBC files in Unica Campaign: In the application server, update the JNDI details (schema / SID, userid, password) for Campaign JNDI as per the new database schema used with v12.1 environment.
Campaign post-upgrade
Setting the Campaign – Help About > Version
Procedure
-
Change the Unica Campaign version in the Unica Platform
registration:
-
Execute the following command to upgrade Campaign Security Policies
from the base version to version 12.1 and navigate to
<Platform_Home/tools/bin>.
./populateDb.sh -n Campaign
Unica Campaign configuration changes
Procedure
-
Campaign “Campaign REST API Filter" registration:
- Navigate to the PLATFORM_HOME/tools/bin directory.
-
Execute the following commands:
configTool -v -i -p "Affinium|suite|security|apiSecurity|campaign" -f "full_path_to_Campaign_installation_directory\conf\API_Filter.xml"
configTool -v -i -p "Affinium|suite|security|apiSecurity|campaign" -f "full_path_to_Campaign_installation_directory\conf\API_V2_Filter.xml"
configTool -v -i -p "Affinium|suite|security|apiSecurity|campaign" -f "full_path_to_Campaign_installation_directory\conf\API_V3_Filter.xml"
-
Campaign “Engage REST API" registration:
- Navigate to the PLATFORM_HOME/tools/bin directory.
- Execute the following command:./configTool.sh -vp -p "Affinium|suite|security|apiSecurity|campaign" -f <CAMPAIGN_HOME>/conf/Engage_API_Filter.xml
-
Optimize navigation registration
configTool -v -i -p "Affinium|suite|uiNavigation|mainMenu|Campaign" -f "full_path_to_Campaign_installation_directory\conf\optimize_navigation.xml"
-
Campaign struts Related Changes
In the upgrade MVC framework from Struts 1.3.8 to Spring 5.1.18, to fix Security vulnerability (in Struts 1.3.8) and to move to the current industry standard has caused changes in the extension of some of the urls mentioned in the configuration from ".do" to ".go". The following commands need to be executed to bring it to effect.
- configTool.bat -vp -o -p "Affinium|suite|uiNavigation|settingsMenu|campaignSettingsItem" -f <CAMPAIGN_HOME>/conf/campaign_setup_navigation_spring_update.xml
- configTool.bat -vp -o -p "Affinium|suite|uiNavigation|mainMenu|Campaign|Optimize" -f <CAMPAIGN_HOME>/conf/campaign_navigation_optimize_spring_update.xml
- configTool.bat -vp -o -p "Affinium|suite|uiNavigation|mainMenu|Campaign|All Offers" -f <CAMPAIGN_HOME>/conf/campaign_navigation_allOffers_spring_update.xml
- configTool.bat -vp -o -p "Affinium|Campaign|navigation" -f <CAMPAIGN_HOME>/conf/campaign_configuration_doLogout_spring_update.xml
- configTool.bat -vp -o -p "Affinium|suite|uiNavigation|mainMenu|Campaign|All Segments" -f <CAMPAIGN_HOME>/conf/campaign_navigation_allSegments_spring_update.xml
- configTool.bat -vp -o -p "Affinium|suite|uiNavigation|mainMenu|Campaign|All Sessions" -f <CAMPAIGN_HOME>/conf/campaign_navigation_allSessions_spring_update.xml
- configTool.bat -vp -o -p "Affinium|suite|uiNavigation|mainMenu|Campaign|All Campaigns" -f <CAMPAIGN_HOME>/conf/campaign_navigation_allCampaigns_spring_update.xml
- configTool.bat -vp -o -p "Affinium|Campaign|unicaACOOptAdmin" -f <CAMPAIGN_HOME>/conf/campaign_configuration_ext_doLogout_spring_update.xml
- configTool.bat -vp -o -p "Affinium|Campaign|navigation" -f <CAMPAIGN_HOME>/conf/campaign_configuration_offerDetails_spring_update.xml
- configTool.bat -vp -o -p "Affinium|suite|uiNavigation|mainMenu|Campaign|Monitoring Console" -f <CAMPAIGN_HOME>/conf/campaign_navigation_monitoring_console_spring_update.xml
- configTool.bat -vp -o -p "Affinium|Campaign|navigation" -f <CAMPAIGN_HOME>/conf/campaign_configuration_displayOfferList_spring_update.xml
- configTool.bat -vp -o -p "Affinium|Campaign|navigation" -f <CAMPAIGN_HOME>/conf/campaign_configuration_flowchartDetails_spring_update.xml
- configTool.bat -vp -o -p "Affinium|Campaign|unicaACOOptAdmin" -f <CAMPAIGN_HOME>/conf/campaign_configuration_ext_runOptimizeSession_spring_update.xml
- configTool.bat -vp -o -p "Affinium|Campaign|unicaACOOptAdmin" -f <CAMPAIGN_HOME>/conf/campaign_configuration_ext_stopOptimizeSessionRun_spring_update.xml
- configTool.bat -vp -o -p "Affinium|Campaign|unicaACOOptAdmin" -f <CAMPAIGN_HOME>/conf/campaign_configuration_ext_optimizeSessionProgress_spring_update.xml
- configTool.bat -vp -o -p "Affinium|Campaign|navigation" -f <CAMPAIGN_HOME>/conf/campaign_configuration_optimize_sessionLinkClicked_spring_update.xml
- configTool.bat -vp -o -p "Affinium|Campaign|navigation" -f <CAMPAIGN_HOME>/conf/campaign_configuration_optimize_editOptimizeSchedule_spring_update.xml
-
Change Campaign configurations in the Unica Platform configuration:
-
Platform – DBResourceBundle: The steps underneath will import resource
bundles in Unica Platform. Execute the script underneath as
specified:
- Navigate to <platform_home>/tools/bin
- DBResourceBundle.sh /bat -P Campaign -F <Campaign_home>/resourcebundles
Unica Campaign post-upgrade functional check
Procedure
- The Unica Campaign application navigation URL points to the old base environment. You must change this navigation URL to point to the target environment using the SQL script in the Unica Platform system database.
- Perform UAT on Unica Campaign application. Ensure that all the flowchart are opening and the run is successful.
Configuring Unica Insights reports with Campaign
Complete the following steps.
Procedure
- Import Campaign Reports schemas in Platform configuration.
-
Run the following commands. Navigate to
Platform_HOME/tools/bin directory.
configTool -v -i -o -p "Affinium|Report|about" -f "<CAMPAIGN_HOME>/reports/schema/config_version.xml"
configTool -v -i -o -p "Affinium|Report|schemas" -f "<CAMPAIGN_HOME>/reports/schema/config_schemas_Campaign.xml"
configTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/templates/camp_cust_attributes_template.xml"
configTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/templates/camp_performance_template.xml"
configTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/templates/offer_performance_template.xml"
configTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/templates/camp_offer_response_breakout_template.xml"
configTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/templates/camp_offer_contact_status_breakout_template.xml"
configTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/base/camp_view.xml"
c
onfigTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/custom/camp_cust_attributes.xml"
configTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/custom/camp_offer_response_breakout.xml"
configTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/custom/camp_offer_contact_status_breakout.xml"
configTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/custom/camp_performance.xml"
configTool -v -i -o -p "Affinium|Report|schemas|Campaign" -f "<CAMPAIGN_HOME>/reports/schema/custom/offer_performance.xml"
-
Update Campaign data source in Unica Insights report design files using Unica Insights
utility.
InsightsDBUtil -ds=CampaignDS -bPath="<Platform_Home>/Insights/Reports" -DBType=<databasetype> -URL=<databasetype> -user=<database user> -pwd=<database password>
- For Reports pack configurations, see the Unica Insights Reports Installation and Configuration guide.