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.0 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.0 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.0 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.0 environment.
Campaign post-upgrade
Setting the Campaign – Help About > Version
Procedure
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
-
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 BIRT 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 BIRT report design files using BIRT
utility.
birtDBUtil -ds=CampaignDS -bPath="<Platform_Home>/Birt/Reports" -DBType=<databasetype> -URL=<databasetype> -user=<database user> -pwd=<database password>
- For Reports pack configurations, see the BIRT Reports Installation and Configuration guide.
Upgrading IBM eMessage
(This can be skipped if eMessage is not in use): You should manually execute the following scripts provided in the table underneath on the Unica Campaign database while upgrading from various base versions:
About this task
Versions | Scripts to Execute |
---|---|
8.6.x to 12.0 | Navigate to <CAMPAIGN_HOME>/eMessage/ddl/upgrade on the Newly install Campaign 12.0
setup. Execute all scripts after "-- 8.6.0.0 Updates --" from ace_upgrade_<DATABASE_TYPE>.sql |
9.0.x to 12.0 | Navigate to <CAMPAIGN_HOME>/eMessage/ddl/upgrade on the Newly install Campaign 12.0
setup. Execute all scripts after "-- 9.0.0.0 Updates --" from ace_upgrade_<DATABASE_TYPE>.sql |
9.1.x to 12.0 | Navigate to <CAMPAIGN_HOME>/eMessage/ddl/upgrade on the Newly install Campaign 12.0
setup. Execute all scripts after "-- 9.1.0.0 Updates --" from ace_upgrade_<DATABASE_TYPE>.sql |
9.1.1.x to 12.0 | Does not require any script execution. |
9.1.2.x to 12.0 | Does not require any script execution. |
10.0.x to 12.0 | Does not require any script execution. |