Procedure: Fast upgrade Unica Contact Central

About this task

Prerequisites - Contact Central application must be up and running on the target setup, with no data created. Contact Central database name should be the same on both base and target setups.

Upgrade Steps
  1. Stop Services (Base Setup)

    Stop Contact Central services on the base setup.

  2. Backup Database (Base Setup)

    Take a full backup of the Contact Central database from the base setup.

  3. Stop Services (Target Setup)

    Stop Contact Central services on the target setup.

  4. Backup & Drop Target Database
    • Take backup of Contact Central database on the target setup.
    • Drop the Contact Central DB from the target setup.
    Fast upgrade mainly involves:
    • Upgrading the Contact Central database manually on the target setup.
    • Upgrading the Contact Central configuration on the target setup.
  5. Perform Version-Specific Upgrade Steps
    If Base Version = 12.1.2
    • Database Scripts to Run on respective databases type:
      • <Contact_Central_Install_Location>\ddl\upgrade1212to1213
      • <Contact_Central_Install_Location>\ddl\upgrade1217to1218
    • Configuration Scripts to Run:
      • <Contact_Central_Install_Location>\conf\upgrade1213to1214\ContactCentral_Navigation.xml
      • <Contact_Central_Install_Location>\conf\upgrade1218to1219\ContactCentral_API_V2.xml
    If Base Version = 12.1.3
    • Database Scripts to Run on respective databases type:
      • <Contact_Central_Install_Location>\ddl\upgrade1217to1218
    • Configuration Scripts to Run:
      • <Contact_Central_Install_Location>\conf\upgrade1213to1214\ContactCentral_Navigation.xml
      • <Contact_Central_Install_Location>\conf\upgrade1218to1219\ContactCentral_API_V2.xml
    If Base Version = 12.1.4 to 12.1.7
    • Database Scripts to Run on respective databases type:
      • <Contact_Central_Install_Location>\ddl\upgrade1217to1218
    • Configuration Scripts to Run:
      • <Contact_Central_Install_Location>\conf\upgrade1218to1219\ContactCentral_API_V2.xml
    If Base Version = 12.1.8
    • Database Scripts to Run on respective databases type:
      • Not Required
    • Configuration Scripts to Run:
      • <Contact_Central_Install_Location>\conf\upgrade1218to1219\ContactCentral_API_V2.xml
    If Base Version = 12.1.9
    • Database Scripts to Run on respective databases type:
      • Not Required
    • Configuration Scripts to Run:
      • Not Required
    If Base Version = 12.1.10
    • Database Scripts to Run on respective databases type:
      • Not Required
    • Configuration Scripts to Run:
      • Not Required
  6. Delete Temporary Files

    Delete the temp folder in the application server.

  7. Update Navigation URL

    Update the Contact Central navigation URL as per the target setup.

  8. Start Services (Target Setup)

    Start Contact Central services on the target setup.

  9. Final Validation
    Ensure that all contents and configurations from the base setup are:
    • Successfully migrated
    • Verify ContactCentralAdmin role is assigned to the user – asm_admin → Edit roles.
    If ContactCentralAdmin role is not available, run the following query on associate Platform database:
    select * from usm_role where application=123

    If the query does not yield any results, complete the following steps:

    1. Navigate to <Platform_installation_location>\tools\bin.
    2. To populate Contact Central specific roles and permission, execute the following command:
      populateDb.bat -n ContactCentral -l HIGH

      This command will add the ContactCentralAdmin user role.

    Verify if ContactCentral main menu is available. If not, run the following configuration Please populate roles for user as suggested in previous comments.
    1. Import Contact Central navigation from the path <ContactCentral_installation_location>\conf\upgrade1213to1214\ContactCentral_Navigation.xml
    2. Revalidate if Contact Central is properly configured and fully functional on the target setup.