Automatic migration - Automatic migration - Saperion ECM - Saperion - Saperion-ECM/Saperion/Foundation-EP7/Saperion-Update-Guide/Migrate-from-version-7.5/Automatic-migration - Foundation EP7 - Foundation EP7

Saperion Update Guide
Platform
Saperion ECM
Product
Saperion
Release
Foundation EP7
License
ft:lastPublication
2026-03-26T12:00:19.359000
ft:locale
en-US
This section lists the steps that the system executes when you start the Java Core Server for the first time after updating to version Foundation EP7. If there is an error in any of the migration actions – migrating clients, roles, groups, users, ACLs – the system stops the migration and the server start fails. Make sure you have completed all the steps in the “Prepare” and “Update” topics.When you start the Java Core Server for the first time, Saperion completes the following procedures.
  1. Creates the new XS_* tables, if they do not yet exist. For more information, see the “Data Model” topic at the end of this document.
  2. Creates necessary TRIGGER, FUNCTIONS und STORED PROCEDURES.
  3. Deletes existing views that ensure compatibility with 32-bit applications (XSUSR, XSGRP, XSACC, XSACL, XSMND).
  4. Renames existing backup tables XS_USR_BACKUP, XSGRP_BACKUP, XSACC_BACKUP, XSACL_BACKUP and XSMND_BACKUP to XSUSR, XSGRP, XSACC, XSACL and XSMND respectively.
  5. Creates the migration tables XS_MIGRATED and XS_MIGRATION_CHECK, if these do not exist.
  6. Checks whether the migration was already executed successfully by reviewing the XS_MIGRATED table. If the migration was successful, the system creates the compatibility views.
  7. Checks the data consistency. Logs inconsistencies in the XS_MIGRATION_CHECK table. The system empties the table before the check, and stops the check when inconsistencies are found.
  8. If necessary, extends the XSACL table with the new ID and SYSINDEXSTATE fields, and initializes the columns with a consecutive number beginning with 1, and the SYSINDEXSTATE with 0 (not deleted).
  9. Migrates clients
    1. Creates a default client with ID 0, which is marked as deleted.
    2. Copies all clients from XSMND to XS_TENANTS
    3. Writes the number of converted clients in the XS_MIGRATED table (from the XS_TENANTS table).
    4. Creates a backup, and renames XSMND to XSMND_BACKUP.
  10. Migrates roles (previously called profiles)
    1. Creates a default role with ID 0, and marks it as deleted.
    2. Copies all roles from XSACC to XS_ROLES.
    3. Writes the number of converted roles in the XS_MIGRATED table (from the XS_ROLES table)
    4. Creates a backup and rename XSACC to XSACC_BACKUP.
  11. Migrates groups
    1. Creates a default group with ID 0, and marks it as deleted.
    2. Copies all groups from XSGRP to XS_GROUPS.
    3. Copies references to other groups to the XS_GROUP_GROUP table. The system ignores references to groups that no longer exist.
    4. Writes the number of converted groups in the XS_MIGRATED table (from the XS_GROUPS table).Copies references to other groups to the XS_GROUP_GROUP table. The system ignores references to groups that no longer exist.
    5. Writes the number of converted group references in the XS_MIGRATED table (from the GROUP_GROUP table).
    6. Creates a backup and renames XSGRP to XSGRP_BACKUP.
  12. Migrates users
    1. Creates a default group with ID 0, and marks it as deleted.
    2. Copies all users from XSUSR to XS_USERS.
    3. Copies the group references in the XS_USER_GROUP table. The system ignores references to groups that no longer exist.
    4. Writes the number of converted users in the XS_MIGRATED table (from the XS_USERS table).
    5. Writes the number of converted group references in the XS_MIGRATED table (from the XS_USER_GROUP table).
    6. Creates a backup and renames XSUSR to XSUSR_BACKUP.
  13. Migrates ACLs
    1. Creates a default ACL with ID 0, and marks it as deleted.
    2. Copies all ACLs from XSACL to XS_ACLS. Does not migrate ACLs with invalid clients.
    3. Copies the group permissions in the XS_ACL_GROUP and XS_ACL_GROUP_RIGHTS tables. The system ignores references to groups that no longer exist.
    4. Writes the number of converted ACLs in the XS_MIGRATED table (from the XS_ACLS table).
    5. Creates a backup and renames XSACL to XSACL_BACKUP.
  14. Updates the admin role with the privilege to administer clients. This privilege is new and is evaluated by the ECM Services.
  15. Creates the compatibility views XSUSER, XSGRP, XSACC, XSACL and XSMND.