Procedure: Fast upgrade Unica Platform

Unica Platform pre-upgrade

About this task

Import the Unica Platform system tables backup from the old version to the system tables schema used in the clean 12.0.0 environment.

Upgrading the Unica Platform database manually

If system DB is DB2, see the Troubleshooting section of this guide.

You should manually execute the following scripts provided in the table underneath on the Unica Platform database while upgrading from various base versions. These steps are not applicable to Fast Upgrade from version 11.0 to version 12.0.0:

Version SQL scripts to execute
8.6.x to 12.0.0

SQL Server

  • <PLATFORM_HOME>/db/upgrade86to8601/insert_new_8601_locales.sql (do not execute this script if upgrading from 8.6.0.1 onwards)
  • <PLATFORM_HOME>/db/upgrade86to90/ManagerSchema_SqlServer_90upg.sql
  • <PLATFORM_HOME>/db/upgrade90to91/ManagerSchema_SqlServer_91upg.sql
  • <PLATFORM_HOME>/db/upgrade91to911/ManagerSchema_SqlServer_911upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_SqlServer_10upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/SqlServer_QRTZ_Scheduler_10_upgrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_SqlServer_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_SqlServer_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
8.6.x to 12.0.0

Oracle

  • <PLATFORM_HOME>/db/upgrade86to8601/insert_new_8601_locales.sql (do not execute this script if upgrading from 8.6.0.1 onwards
  • <PLATFORM_HOME>/db/upgrade86to90/ManagerSchema_Oracle_90upg.sql
  • <PLATFORM_HOME>/db/upgrade90to91/ManagerSchema_Oracle_91upg.sql
  • <PLATFORM_HOME>/db/upgrade91to911/ManagerSchema_Oracle_911upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_Oracle_10upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/Oracle_QRTZ_Scheduler_10_upgrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_Oracle_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_Oracle_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_Oracle_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_Oracle_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_Oracle_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_Oracle_12upg.sql
8.6.x to 12.0.0

DB2

  • <PLATFORM_HOME>/db/upgrade86to8601/insert_new_8601_locales.sql (do not execute this script if upgrading from 8.6.0.1 onwards
  • <PLATFORM_HOME>/db/upgrade86to90/ManagerSchema_DB2_90upg.sql

OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade86to90/ManagerSchema_DB2_90upg_unicode.sql AND

  • <PLATFORM_HOME>/db/upgrade86to90/db2_unicode_fix_90.sql
  • <PLATFORM_HOME>/db/upgrade90to91/ManagerSchema_DB2_91upg.sql

Or if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade90to91/ManagerSchema_DB2_91upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade91to911/ManagerSchema_DB2_911upg.sql

Or if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade91to911/ManagerSchema_DB2_911upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade912to10/DB2_QRTZ_Scheduler_10_upggrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg.sql

Or if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg.sql

Or if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql

  • <PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg.sql

Or if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_DB2_11upg.sql

Or if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_DB2_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_DB2_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg.sql

Or if Unicode environment execute:

  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg_unicode.sql
9.0.x to 12.0.0

SQL Server

  • <PLATFORM_HOME>/db/upgrade90to91/ManagerSchema_SqlServer_91upg.sql
  • <PLATFORM_HOME>/db/upgrade91to911/ManagerSchema_SqlServer_911upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_SqlServer_10upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/SqlServer_QRTZ_Scheduler_10_upgrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_SqlServer_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_SqlServer_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
9.0.x to 12.0.0

Oracle

  • <PLATFORM_HOME>/db/upgrade90to91/ManagerSchema_Oracle_91upg.sql
  • <PLATFORM_HOME>/db/upgrade91to911/ManagerSchema_Oracle_911upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_Oracle_10upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/Oracle_QRTZ_Scheduler_10_upgrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_Oracle_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_Oracle_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_Oracle_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_Oracle_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_Oracle_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_Oracle_12upg.sql
9.0.x to 12.0.0

DB2

  • <PLATFORM_HOME>/db/upgrade90to91/ManagerSchema_DB2_91upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade90to91/ManagerSchema_DB2_91upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade91to911/ManagerSchema_DB2_911upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade91to911/ManagerSchema_DB2_911upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade912to10/DB2_QRTZ_Scheduler_10_upggrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql

  • <PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_DB2_11upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_DB2_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_DB2_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg.sql
Or if Unicode environment execute:
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg_unicode.sql
9.1.x to 12.0.0

SQL Server

  • <PLATFORM_HOME>/db/upgrade91to911/ManagerSchema_SqlServer_911upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_SqlServer_10upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/SqlServer_QRTZ_Scheduler_10_upgrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_SqlServer_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_SqlServer_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
9.1.x to 12.0.0

Oracle

  • <PLATFORM_HOME>/db/upgrade91to911/ManagerSchema_Oracle_911upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_Oracle_10upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/Oracle_QRTZ_Scheduler_10_upgrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_Oracle_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_Oracle_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_Oracle_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_Oracle_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_Oracle_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_Oracle_12upg.sql
9.1.x to 12.0.0

DB2

<PLATFORM_HOME>/db/upgrade91to911/ManagerSchema_DB2_911upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade91to911/ ManagerSchema_DB2_911upg_unicode.sql

<PLATFORM_HOME>/db/upgrade912to10/DB2_QRTZ_Scheduler_10_upggrade_Script.sql

<PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade912to10/ ManagerSchema_DB2_10upg_unicode.sql

<PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql

<PLATFORM_HOME>/db/ upgrade10002to101/ ManagerSchema_DB2_101upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade10002to101/ ManagerSchema_DB2_101upg_unicode.sql

<PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_DB2_11upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql

<PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_DB2_11102upg.sql

<PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg_unicode.sql
9.1.1.x to 12.0.0

SQL Server

  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_SqlServer_10upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/SqlServer_QRTZ_Scheduler_10_upgrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_SqlServer_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_SqlServer_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
9.1.1.x to 12.0.0

Oracle

  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_Oracle_10upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/Oracle_QRTZ_Scheduler_10_upgrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_Oracle_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_Oracle_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_Oracle_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_Oracle_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_Oracle_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_Oracle_12upg.sql
9.1.1.x to 12.0.0

DB2

  • <PLATFORM_HOME>/db/upgrade912to10/DB2_QRTZ_Scheduler_10_upggrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql

  • <PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_DB2_11upg.sql
OR if Unicode environment execute:
  • <PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_DB2_111upg.sql

<PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_DB2_11102upg.sql

<PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg.sql

OR if Unicode environment execute:
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg_unicode.sql
9.1.2.x to 12.0.0

SQL Server

  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_SqlServer_10upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/SqlServer_QRTZ_Scheduler_10_upgrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_SqlServer_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_SqlServer_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
9.1.2.x to 12.0.0

Oracle

  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_Oracle_10upg.sql
  • <PLATFORM_HOME>/db/upgrade912to10/Oracle_QRTZ_Scheduler_10_upgrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_Oracle_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_Oracle_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_Oracle_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_Oracle_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_Oracle_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_Oracle_12upg.sql
9.1.2.x to 12.0.0

DB2

  • <PLATFORM_HOME>/db/upgrade912to10/DB2_QRTZ_Scheduler_10_upggrade_Script.sql
  • <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql

  • <PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_DB2_11upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_DB2_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_DB2_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg.sql
Or if Unicode environment execute:
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg_unicode.sql
10.0.x to 12.0.0

SQL Server

  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_SqlServer_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_SqlServer_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
10.0.x to 12.0.0

Oracle

  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_Oracle_10002upg.sql
  • <PLATFORM_HOME>/db/upgrade10002to101/ManagerSchema_Oracle_101upg.sql
  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_Oracle_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_Oracle_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_Oracle_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_Oracle_12upg.sql
10.0.x to 12.0.0

DB2

  • <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql

  • <PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_DB2_11upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_DB2_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_DB2_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg.sq

OR if Unicode environment execute:

  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg_unicode.sql
10.1.0 to 12.0.0

SQL Server

  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_SqlServer_11upg.sql
  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
10.1.0 to 12.0.0

Oracle

  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_Oracle_11upg.sql

  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_Oracle_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_Oracle_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_Oracle_12upg.sql
10.1.0 to 12.0.0

DB2

  • <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_DB2_11upg.sql

OR if Unicode environment execute:

<PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql

  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_DB2_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_DB2_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg.sql

Or if a Unicode environment exceute:

  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg_unicode.sql
11.0 to 12.0.0 Does not require execution of any scripts
11.0.1 to 12.0.0

SQL Server

  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_SqlServer_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql

Oracle

  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_Oracle_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_SqlServer_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_SqlServer_12upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_Oracle_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_Oracle_12upg.sql

DB2

  • <PLATFORM_HOME>/db/upgrade1101to111/ManagerSchema_DB2_111upg.sql
  • <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_DB2_11102upg.sql
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg.sql
Or if a unicode environment exceute
  • <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg_unicode.sql

Updating the JDBC files in Unica Platform

About this task

In case you do not want to reuse the Platform schema used for a 12.0.0 clean installation and rather want to use another user schema, you will need to follow the additional steps underneath:
  1. Take a back up the jdbc.properties file from the 12.0.0 environment (Platform/tools/bin/jdbc.properties). Update the username in the 12.0.0 platform system database / schema name in jdbc.properties file.

    Example of jdbc.properties:

    uasm.jdbc_driver=com.ibm.db2.jcc.DB2Driver

    uasm.data_source=jdbc:db2://<DB_HOST>:<DB_PORT>/<DB2_SID>

    uasm.data_source_login=<PLATFORM_DB_SCHEMA>

    uasm.data_source_password=ENC(T+rsrWP41Vqu8SoDARMhDdWkf0dFB0Zc) hibernate.dialect=org.hibernate.dialect.DB2Dialect

  2. To update the encrypted password in the jdbc.properties file run the following command:Navigate to Platform/tools/bin directory and execute the below command:

    ./encryptPasswords.sh –d <PLATFORM_DB_USER_PASSWORD>

    This will update the encrypted password in the jdbc.properties file. Save the Platform/tools/bin/jdbc.properties with this encrypted password of the new schema user.

  3. In the application server, update the JNDI details (schema / SID, userid, password) for Platform JNDI as per the new database schema used with v12.0.0 environment.

Upgrading the Unica Platform configuration

Procedure

  1. Execute the following command to upgrade Unica Platform configurations to 12.0.0:

    Navigate to <UNICA_PLATFORM_HOME>/tools/bin directory

    Execute command:

    ./configTool.sh -vp -p "Affinium" -f "<UNICA_PLATFORM_HOME>/conf/Manager_config.xml"

    Note: You may encounter an insertion of duplicate key related error or com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException:

    See the Troubleshooting section.

  2. Execute the command: ./populateDb.sh -n Manager
  3. Execute the command:
    ./configTool.sh -vp -p "Affinium|suite|uiNavigation|mainMenu|Analytics" -f "<PLATFORM_HOME>/conf/watsonAssistant_navigation.xml"
  4. Execute the command: ./alertConfigTool.sh -i -f "<UNICA_PLATFORM_HOME>/conf/Platform_alerts_configuration.xml"

    Note: If upgrading from version 11.0.1, then do not execute the below scripts(step 5,6,7).

  5. Execute the command: ./configTool.sh -vp -p "Affinium|Report|integrations" -f “<UNICA_PLATFORM_HOME>/conf/upgrade101to11/cognos11_integration.xml"

    Note: If upgrading from version 8.6.0, execute steps 6 and 7.

  6. Execute the command: upgrade86to90(Only Upgrading from version 8.6.0)
  7. Execute the command: upgrade90to91(Only Upgrading from version 9.0)
  8. Upgrade the scheduler jobs.

    Use the quartzjobtool to update scheduler jobs. This is a required step. If this upgrade tool is not run, any existing scheduled job fails to start. The quartzjobtool is in the tools\bin directory under Unica Platform installation. Run this utility from the tools\bin directory.

    Example command (Windows): quartzjobtool.bat

    Example command (Unix): ./quartzjobtool.sh

  9. For BIRT users, execute the following command.

    configTool -vp -p "Affinium" -f <Birt.xml directory_path>/Birt.xml(Birt.xml directory_path : /opt/HCL/Unica_12/Platform/Birt/conf)

Importing Asset Picker node to Unica Platform

About this task

To perform a fast upgrade of Asset Picker, you must import the Asset Picker node to Unica Platform. To import the Asset Picker node to Unica Platform, complete the following steps:

Procedure

  1. Navigate to the path <PLATFORM_HOME>/tools/bin and execute the following commands: 
    configTool.sh / bat -vp -p Affinium -f <Platform_HOME>/AssetPicker/conf/platform/cms_configuration.xml
configtool.sh / bat -vp -p Affinium -f <Platform_Home>/AssetPicker/conf/platform/APISecurity_AssetPicker.xml
  2. To verify Asset Picker navigation URL, complete the following steps:
    1. Select Settings > Configuration.
      The Configuration page appears.
    2. In the Configuration categories panel, expand assetPicker and select navigation.
      The Settings for 'navigation' page appears. Check the serverURL field. The value of serverURL should have the following format:
      http://<HOST>:<PORT>/asset-viewer
  3. Expand Unica Platform > Security > API management > Asset Picker and select (API configuration template).
    The (API configuration template) appears.
  4. Provide the following values for the fields:
    • New category name - Provide the value AssetPicker API.
    • API URI - Provide the value /*.
    • Block API access - By default, this is disabled. Do not enable it.
    • Secure API access over HTTPS - By default, this is disabled. Do not enable it.
    • Require authentication for API access - By default, this is enabled. Do not disable it.
  5. Click Save changes.
    The new category AssetPicker API appears within Asset Picker.
  6. Navigate to the path <PLATFORM_HOME>/tools/bin and execute the following command: 
    populateDb.bat -n AssetPicker -p partition1

Setting the Unica Platform – Help About > Version

Procedure

  1. Change the Unica Platform version in the database. Refer to the following guidelines: Export the version configuration using the following command on clean 12.0.0 environment: ./configTool.sh -x -p "Affinium|Manager|about" -f "<PLATFORM_HOME>/conf/about.xml"
  2. Edit the about.xml file generated by the above command. Change the version to 12.0.0.0.0.GA_BUILD. <GA_BUILD> - Please replace this with build number referring to version.txt from installation location. 
    <property id="xxxxxx" name="releaseNumber" type="string_property" width="40"> 
                  <value>12.0.0.0.0.GA_BUILD</value> 
               </property>
  3. Edit the about.xml file generated by the previous step with the destination server details of the following properties:

    1.display name

    2.copyright

    3.OS

    4.server name

    5.support and support web URL if change required.

  4. Import the above mentioned about.xml edited file using the following command: ./configTool.sh -v -i -o -p "Affinium|Manager" -f <PLATFORM_HOME>/conf/about.xml

Unica Platform post-upgrade

Procedure

  1. Unica Platform application navigation URL points to the old base environment. You must change the navigation URL using the SQL script from the Platform system database.
  2. The URL of the start page that appears when each users log in to HCL Unica products has to be changed manually from the USM_PERSONALIZATION table.
  3. Check the following properties files from the source and destination Environment. Copy all the urls mentioned in the respective properties files from source to destination files.

    1.Platform_Admin_URL.properties

    2.Platform_Admin_View_Priv.properties

    3.Platform_Admin_URL.properties

    4.Platform_Admin_Scheduler_Scripts.properties

    5.Platform_Admin_Scheduler_API.properties

  4. Perform UAT on Unica Platform application. Make sure all the functions are working correctly.