Migrating tenant data holding large databases

In order to achieve a predictable migration time and smaller tenant backup files, exclude all ARIS databases from the tenant backup. Thus, you can start the database migration separately.

Prerequisites

Warning

Tenant data is fully backed up only if the user executing the commands has sufficient privileges for all components in every tenant and if all components were selected for the backup.

User administration audit events are not part of the tenant backup.

Extensions, for example, SSL certificates, SAP® Java Connector, and JDBC drivers, added using the enhance ACC command are not backed up.

To avoid data inconsistencies and possible data loss, you must not perform any of the following activities in parallel, neither manually nor scheduled:

- Deleting any Process Governance process instance, process version, or process

- Archiving Process Governance process instances

- Backup/restore tenant (containing Process Governance or ARIS document storage data)

Procedure

  1. In each of your ARIS 9 tenants, check the system user's functional privileges. If not revoked by an administrator, the system user has all required privileges by default:
  2. Rename the ARIS 9 United Motor Group example database to avoid name conflicts witch the ARIS 10 example database.
  3. Start ARIS Cloud Controller (ACC) on the ARIS 9 system.

    To start ACC under a Windows operating system click Start > All Programs > ARIS > Administration > Start ARIS Cloud Controller. If you have changed agent user credentials you must enter the password.

    To start ACC under a Linux operating system, execute the acc.sh shell script instead. ACC is available if you have copied and installed the aris-acc-<number> deb or rpm file depending on the Linux operating system.

  4. Enter help or help <command> to get information about the usage of the commands.
  5. Exclude the ABS runnable from being backed up. If you back-up data from ARIS Connect, enter:

    set acc config backup.restore.tenant.app.types = UMC, ADS, ECP, OCT, APG

    If you use an ARIS Design Server, the command is:

    set acc config backup.restore.tenant.app.types = UMC, ADS,OCT, APG

    These commands exclude all databases from the backup. All data from the listed runnables will be saved.

  6. Reconfigure load balancer ports (recommended step). This will prevent users to log on. User access is rejected due to changed ports.
  7. Make sure that no Process Governance processes are running when starting the backup.
  8. Back-up all tenants after another, except the master tenant. Enter these ACC commands:

    list tenants

    All tenants to be backed-up are listed.

    backup tenant <tenant name> to <pathToBackUpFile> username=<user name of a user holding the required privileges> password=<this user's password>

    such as:

    backup tenant default to “D:\\backupARIS9\\default.zip" username=system password=manager

    backup tenant custom1 to “D:\\backupARIS9\\custom1.zip" username=system password=manager

    Notice the double backslashes. Alternatively, use a single forward slash (/).

    The backup is started. Each backup is written to one single archive file.

  9. Check the archive files when completed. You can open the archive, for example, with WinZip® or 7zip. Make sure that there are subfolders for each runnable, containing all relevant data. In case of ARIS Connect, there must be 5 subfolders. ARIS Design Server only creates 4 subfolders.
  10. Migrate the tenant data by starting ACC on the ARIS 10 system. Enter:

    restore tenant <tenant name> from <pathToBackUpFile> username=<user name of a user holding the required privileges> password=<this user's password>

    such as:

    restore tenant default from “D:\\backupARIS10\\default.zip" username=system password=manager

    All additional tenants must be created before you can restore them. If you use an external database management system, make sure to have created schemes and have assigned them to those tenants (see ARIS Server Installation Guide).

    create tenant custom1

    This command is mandatory for all additional tenants. Tenants can only be restored if they exist already. The master tenant and the default tenant are installed by default.

    restore tenant custom1 from “D:\\backupARIS10\\custom1.zip" username=system password=manager.

  11. If ARIS Connect was customized or ARIS Publisher still is in use, after migration you must perform some additional steps. Make sure to add required extensions again.
  12. Restore the United Motor Group database from DVD. This will make new content available mandatory for dashboards (ARIS Aware).
  13. Restart all runnables (enter stopall and startall) and check the status (Enter List tenants).
  14. Migrate the excluded databases.

All data of the ARIS 9.8.7 backup files are now restored on the ARIS 10 Server. The default user accounts are automatically reset to their default values. The system databases are updated automatically.

If ARIS document storage is in use, timestamps must be adjusted and all migrated databases must be processed by a report.

The default user accounts are automatically reset to their default values. To prevent unauthorized access to the ARIS system, after installation or data migration, always change the default passwords of the arisservice user, the guest user, the system user and the superuser user on all operational tenants, as well as on the infrastructure tenant (master).

If you are going to use ARIS Tenant Management Tool, in ARIS 10 make sure to configure the component and create schedules again (see ARIS Tenant Management.pdf or online help).