Upgrading from version 8.6.x with manual migration
The Marketing Platform upgrade installer can perform all of the data migration that is required for an upgrade automatically. However, if the policy of your organization does not allow automatic migration, you must complete the migration procedure to upgrade Marketing Platform manually. To upgrade to Marketing Platform version 9.1 manually, you must run specific SQL scripts and insert the required configuration properties.
Ensure that you have the following installers in the same directory:
*
The IBM® master installer
*
The Marketing Platform installer
Also, ensure that your installation of Marketing Platform 8.x is fully functional and you can run the command-line tools. Running the command-line tools requires the use of three Marketing Platform utilities that are in the tools/bin directory under your Marketing Platform installation. Complete information about using the utilities with example commands for common tasks is available in the following topics:
*
populateDb
*
configTool
*
alertConfigTool
See Marketing Platform upgrade scenarios for information on upgrading from other versions.
1.
Complete the following steps to upgrade your Marketing Platform installation to version 9.1:
2.
Make a backup of your Marketing Platform system table database.
*
Do not skip this step. If upgrade fails, you will not be able to roll back your database and your data will be corrupted.
3.
Undeploy your current version.
4.
Run the IBM® EMM master installer.
The IBM® EMM master installer starts. Use the following instructions after theIBM® EMM master installer starts:
*
When the IBM® EMM master installer prompts you to choose an installation directory, choose the root installation directory, not the Marketing Platform installation directory that is under this root directory.
*
When the IBM® EMM master installer prompts you to enter Marketing Platform database connection information, enter the information that pertains to your current Marketing Platform system tables.
The IBM® EMM master installer pauses and starts the Marketing Platform installer.
5.
Complete the following steps while the Marketing Platform installer is running:
a.
When the Marketing Platform installer prompts you for an installation directory, select the directory of your current Marketing Platform installation, usually named Platform.
b.
Allow the installer to create a back-up copy of your previous installation of Marketing Platform.
c.
Select Manual database setup.
d.
Clear the Run Platform configuration check box.
e.
Follow the remaining steps in the installation wizard and enter the requested information.
6.
Run the ManagerSchema_DB_Type_90upg.sql script in the db\upgrade86to90 directory under your Marketing Platform installation.
7.
Run the ManagerSchema_DB_Type_91upg.sql script in the db\upgrade90to91 directory under your Marketing Platform installation.
8.
Run one of the following commands:
*
For Windows™:
installation_directory\platform\tools\bin\upgrade90to91.bat
*
For Unix:
installation_directoryplatform/tools/bin/upgrade90to91.sh
9.
Use the configTool utility to import configuration properties as described in the following table:
*
The configTool utility is in the tools/bin directory under your Marketing Platform installation. For complete details on the function of the configuration properties, see the online help for the Configuration page, or the IBM® Marketing Platform Administrator's Guide.
The example commands in the following table are for the Windows™ operating system.
Files for upgrading from version 8.6.0.
File details
Example command
Skip this import if the property named LDAP BaseDN periodic search enabled is present under the Platform | Security | Login method details | LDAP synchronization category. This is the property you checked for in step 1 of this procedure.
If the property is not present, perform the following import.
*
File: Ldap_Auto_Sync_BaseDN_Settings.xml
*
Location: conf\upgrade86to90 directory under your Marketing Platform installation
*
Purpose: Import a configuration property that enables LDAP import search by DN
configTool.bat -i -p "Affinium|suite|security|ldapSynchronization|ldapProperties" -f "C:\Unica\Platform\conf\Ldap_Auto_Sync_BaseDN_Settings.xml"
*
File: quicklinks_category.xml
*
Location: conf\upgrade86to90 directory under your Marketing Platform installation
*
Purpose: Import properties for quicklinks dashboard portlets
configTool.bat -i -o -p "Affinium|suite" -f "C:\Unica\Platform\conf\upgrade86to90\quicklinks_category.xml"
*
File: communication_email.xml
*
Location: conf\upgrade86to90 directory under your Marketing Platform installation
*
Purpose: Import configuration properties to enable email notifications
configTool.bat -i -o -p "Affinium|Manager" -f "C:\Unica\Platform\conf\upgrade86to90\communication_email.xml"
*
File: notification.xml
*
Location: conf\upgrade86to90 directory under your Marketing Platform installation
*
Purpose: Import configuration properties for the notification feature
configTool.bat -i -o -p "Affinium|suite" -f "C:\Unica\Platform\conf\upgrade86to90\notification.xml"
*
File: manager_alerts_registration.xml
*
Location: conf directory under your Marketing Platform installation
*
Purpose: Import configuration properties that create the alerts menu items
configTool.bat -i -o -p "Affinium|suite|uiNavigation|alerts -f "C:\Unica\Platform\conf\manager_alerts_registration.xml"
*
File: disablePageTagging.xml
*
Location: conf\upgrade82to85 directory under your Marketing Platform installation
*
Purpose: Import a configuration property that determines whether IBM® can gather basic statistics that track overall product usage trends.
configTool.bat -i -o -p "Affinium|suite" -f "C:\Unica\Platform\conf\upgrade82to85\disablePageTagging.xml"
*
File: scheduler.xml
*
Location: db\upgrade90to91 directory under your Marketing Platform installation
*
Purpose: The boolean property to enable or disable the scheduler feature in Marketing Platform
configtool -i -p "Affinium|suite|scheduler" -f "C:\Unica\Platform\conf\upgrade90to91\scheduler.xml"
*
File: unknownPolling.xml
*
Location: db\upgrade90to91 directory under your Marketing Platform installation
*
Purpose: Imports properties for quicklinks dashboard portlets
configtool -i -p "Affinium|suite|scheduler" -f "C:\Unica\Platform\conf\upgrade90to91\unknownPolling.xml"
*
File: communication_email.xml
*
Location: conf\upgrade86to90 directory under your Marketing Platform installation
*
Purpose: Imports configuration properties to enable email notifications. When enabled Marketing Platform attempts to send emails to users for system alerts and notifications.
configTool.bat -i -o -p "Affinium|Manager" -f "C:\Unica\Platform\conf\upgrade86to90\communication_email.xml"
*
File: notification.xml
*
Location: conf\upgrade86to90 directory under your Marketing Platform installation
*
Purpose: Imports configuration properties for the notification feature. The following properties are added:
*
The number of days to retain alerts - 90
*
Frequency in minutes at which emails are sent - 30
*
Maximum number of retries for sending and email - 1
configTool.bat -i -o -p "Affinium|suite" -f "C:\Unica\Platform\conf\upgrade86to90\notification.xml"
*
File: is_clustered.xml
*
Location: conf\upgrade86to90 directory under your Marketing Platform installation
*
Purpose: The boolean property to specify if the Marketing Platform instance is clustered. If you install Marketing Platform in a clustered deployment, set this property to True. Otherwise, retain the default value of False.
configtool -i -p "Affinium|suite" -f "C:\Unica\Platform\conf\upgrade90to91\is_clustered.xml"
*
File: taskNotification.xml
*
Location: conf\upgrade86to90 directory under your Marketing Platform installation
*
Purpose: Imports the Group Name field where you can enter the groups that are notified with scheduled notifications.
configtool -i -p "Affinium|suite|scheduler|taskRegistrations|Campaign|flowchart" -f "C:\Unica\Platform\conf\upgrade90to91\taskNotification.xml"
configtool -i -p "Affinium|suite|scheduler|taskRegistrations|Campaign|mailing" -f "C:\Unica\Platform\conf\upgrade90to91\taskNotification.xml"
configtool -i -p "Affinium|suite|scheduler|taskRegistrations|Campaign|optimize" -f "C:\Unica\Platform\conf\upgrade90to91\taskNotification.xml"
configtool -i -p "Affinium|suite|scheduler|taskRegistrations|InteractionHistory|ETL" -f "C:\Unica\Platform\conf\upgrade90to91\taskNotification.xml"
configtool -i -p "Affinium|suite|scheduler|taskRegistrations|AttributionModeler|TrainingRun" -f "C:\Unica\Platform\conf\upgrade90to91\taskNotification.xml"
configtool -i -p "Affinium|suite|scheduler|taskRegistrations|AttributionModeler|ScoringRun" -f "C:\Unica\Platform\conf\upgrade90to91\taskNotification.xml"
*
File: config_data_filter_cache.xml
*
Location: conf\upgrade90to91 directory under your Marketing Platform installation
*
Purpose: Allows you to configure the data filter cache. If the configuration property is set to True, the data filter cache is enabled for enhanced performance. If the configuration property is set to False, the caching is not enabled, and all operations are completed by connecting to the database for each data filter request. The configuration property is visible on the user interface.
configTool.bat -vp -p "Affinium|Manager|datafiltering" -f "C:\Unica\Platform\conf\upgrade90to91\Config_data_filter_cache.xml"
*
If you change this value, you must restart the Marketing Platform for the changes to take effect.
*
File: Refresh_data_filter_cache.xml
*
Location: conf\upgrade90to91 directory under your Marketing Platform installation
*
Purpose: If data filter caching is enabled, this configuration property ensures that the cache is refreshed every time that there is a change in the data filter definitions.
configTool.bat -vp -p "Affinium|Manager|datafiltering" -f "C:\Unica\Platform\conf\upgrade90to91\Refresh_data_filter_cache.xml"
*
Files: navigation.xml and emm_spss_configuration.xml
*
Location: conf\upgrade90to91
*
Purpose: Import IBM® SPSS® Modeler Advantage Marketing Edition configuration properties.
configTool -i -o -p "Affinium|suite|uiNavigation|mainMenu|Analytics" -f "C:\Unica\Platform\conf\emm_spss_navigation.xml"
configTool -i -o -p "Affinium" -f "C:\Unica\Platform\conf\emm_spss_configuration.xml"
10.
Run the alertConfigTool utility from the tools\bin directory under your Marketing Platform installation to register the Marketing Platform alerts and notifications.
Example command (Windows™):
alertConfigTool.bat -i -f "C:\Platform\conf\Platform_alerts_configuration.xml"
11.
Go to Help > About and complete the following steps to update the About page:
a.
Use the configTool utility to export the Affinium | Manager | about category.
*
The Affinium | Manager | about is not visible on the Configuration page because it is marked hidden.
Example (Windows™):
configTool.bat -x -p "Affinium|Manager|about" -f "C:\Unica\Platform\conf\about.xml"
b.
Edit the exported XML file that you just created (about.xml in the example) to change the version number and display name. Find the releaseNumber property and change the value to the current version of Marketing Platform.
In the following example, change 8.0.0 to your new version:
<property name="releaseNumber" type="string">
<displayNameKey>about.releaseNumber</displayNameKey>
<value>9.1.0.0.0.build_number</value>
</property>
c.
Use the configTool utility to import the revised file. You must use the -o option to overwrite the node. You must specify the parent node when you import.
Example (Windows™):
configTool.bat -i -p "Affinium|Manager" -f "about.xml" -o
12.
Deploy and verify your installation as described in the Deploying Marketing Platform chapter.
See the IBM® EMM Reports Installation and Configuration Guide for the additional steps that are required for reporting upgrades.
Copyright IBM Corporation 2014. All Rights Reserved.