Procedure: Fast upgrade Unica Collaborate
Before you begin
Complete the prerequisites to upgrade from Unica Collaborate 8.6.x or higher version to Unica Collaborate version 12.1.
Procedure
- Ensure that Unica Platform and Unica Campaign are upgraded successfully on the target setup. Install Collaborate version 12.1 on the setup.
- Take a backup for Collaborate source system databases.
Upgrading Collaborate database
Procedure
- Import the source system database on the target system database for Collaborate version 12.1.
-
Run the udmdbsetup utility on target system from
COLLABORATE_HOME/tools/bin.
Example: If we are upgrading from 8.6.0.0 version, run the following utility.
./udmdbsetup.sh -t upgrade -b 8.6.0.0 -m
The following .sql file is generated under COLLABORATE_HOME/tools.udm_upgrade_[8.6.0.0.0]_[10.0.0.2.0].sql
Note: Ignore the last version 10.0.0.2.0 mentioned in the file name and execute the same .sql file to upgrade the database to Collaborate V12.1.Execute the generated .sql file on Collaborate system database.
- Create data sources on the target application server and point to the upgraded database schema. You can use the same JNDI names as those in the source system to save effort in doing manual changes.
Updating files from source to target environment
Procedure
-
Take a backup of the source and the destination system files under the
following directories.
- <COLLABORATE_HOME>/projectattachments
- <COLLABORATE_HOME>/templates
- <COLLABORATE_HOME>/taskattachments
- <COLLABORATE_HOME>/attachments
- Copy or merge all files mentioned in the previous step from the source folders to the respective destination Collaborate directories.
-
In the source version, if you have customized the following files, copy
these files to COLLABORATE_HOME/conf directory in the
destination environment.
- listmanager_tables.xml
- collaborate_log4j.xml
- listmanager_list.xml
- listmanager_searchScreens.xml
Note: You can ignore this step if you have not made any changes to the mentioned files.
Collaborate Configuration changes
About this task
Procedure
-
Execute the following query on Platform database to update the name of the
Distributed Marketing node to Collaborate in Platform configurations.
UPDATE usm_configuration SET display_name='Collaborate' where internal_name='Collaborate' and display_name_key='Distributed Marketing';
-
Execute the following commands.
configTool.bat -vp -p "Affinium|Collaborate" -f "Collaborate_Home/conf/updates/collaborate_conf_upgrade_maxLimit.xml"
-
configTool.bat -vp -p "Affinium|Collaborate" -f "Collaborate_Home/conf/updates/collaborate_conf_upgrade_insights.xml"
-
Create a xml file name. For example: validateFileUpload.xml with following
contents.
<!-- configTool.bat -vp -p "Affinium|Collaborate|UDM Configuration Settings" -f collaborate_conf_upgrade_insights.xml --> <category name="Attachment"> <property name="validateFileUpload" type="radio"> <value predefined="true" selected="false">true</value> <value predefined="true" selected="true">false</value> </property> </category>
-
Execute the following command.
configTool.bat -vp -p "Affinium|Collaborate" -f "<path_to_validateFileUpload.xml>"
-
Perform the following substep to import resource bundles in Unica Platform.
Execute the following scripts.
- Navigate to <platform_home>/tools/bin and
execute
DBResourceBundle.sh -P Collaborate -F Collaborate_Home/conf/resourcebundles
- Navigate to <platform_home>/tools/bin and
execute
-
Update
serverURL
inAffinium|Collaborate|navigation
. -
Update
flowchartServiceCampaignServicesURL
inAffinium|Collaborate|UDM Configuration Settings|Flowchart
. -
Update
flowchartServiceNotificationServiceURL
inAffinium|Collaborate|UDM Configuration Settings|Flowchart
. -
Update
notifyCollaborateBaseURL
inAffinium|Collaborate|UDM Configuration Settings|Notifications
.
Collaborate version registration
Procedure
-
On target environment navigate to the
PLATFORM_HOME/tools/bin and execute the following
command.
configTool.sh -x -p "Affinium|Collaborate|about" -f Collaborate_about.xml
-
Make the following changes to the Collaborate_about.xml file and save it as
collab_about_new.xml file.
- Replace "display name" value "IBM Unica Distributed Marketing" with "Unica Collaborate"
- Replace "releaseNumber" value "<Old version>" with "12.1.0.0.<Build number as per version.txt>".
- Replace "java" value "IBM Corporation 2.4" with "Oracle Corporation 25.162-b12".
-
Execute the following command on the target version 12.1 environment.
configTool.sh -v -i -o -p "Affinium|Collaborate" -f Collaborate_about.xml
- Restart the Unica Collaborate application server.