Upgrading a Cluster with the Location Intelligence Module

When a common repository database is used for clustering, these additional steps required before and after the Spectrum™ Technology Platform upgrade process. Before the upgrade, you must move to a local database setup; after the upgrade, you then change back to the cluster setup by pointing repository.xml to the external database.
Note: To preserve access control settings, use the Administration Utility instead of WebDAV. See the Administration section of the Spectrum Spatial Guide for instructions on using the Administration Utility. The limrepo commands in the Administration Utility were available beginning in version 11.0; if you are upgrading from a version prior to 11.0, you must use WebDAV.
  1. Before upgrading Spectrum™ Technology Platform, back up the repository by following these steps.
    1. Select a node from the cluster. This will be the seed node (see Installing a Cluster).
    2. Back up the repository content using the Administration Utility's limrepo export command with ACL, pointing to the seed node.
    3. Back up the Spectrum\server\modules\spatial\jackrabbit folder to a location outside the installation folder.
  2. Switch the common repository database to a local database (temporarily, just for upgrade purposes). Apply these steps to all nodes in the cluster.
    1. Stop the Spectrum™ Technology Platform server.
    2. Delete the jackrabbit folder (Spectrum\server\modules\spatial\jackrabbit) and create an empty "jackrabbit" folder in the same location.
    3. Copy repository.xml into the jackrabbit folder from Spectrum\server\app\tmp\RepositoryService.war-xxxxxxxx-contents\ webapp\WEB-INF\classes\org\apache\jackrabbit\core. If you cannot find this file, you can extract it from RepositoryService.war under Spectrum\server\app\deploy.
    4. Start the Spectrum™ Technology Platform server.
    5. Import the repository content (backed up in Step 1b) into the repository using WebDAV (the limrepo import command will not work with an empty folder).
    6. Stop the Spectrum™ Technology Platform server.
  3. Follow normal procedures to upgrade Spectrum™ Technology Platform to the new version on all nodes.
  4. For the seed node only, after the Spectrum™ Technology Platform upgrade is complete, back up the upgraded content by following these steps.
    1. Start the Spectrum™ Technology Platform server
    2. Download the Administration Utility from the upgraded Spectrum™ Technology Platform server.
    3. Back up the content from the repository using the limrepo export command with ACL.
    4. Stop the Spectrum™ Technology Platform server.
    5. Back up the upgraded Spectrum\server\modules\spatial\jackrabbit folder to a location outside the installation folder.
  5. Configure the platform cluster as described in Installing a Cluster.
  6. On all nodes of Spectrum™ Technology Platform modify the configuration to specify the common database.
    1. Copy the contents of repository.<databaseType>.xml to repository.xml located under the server/modules/spatial/jackrabbit folder where <databaseType> is the appropriate type for your database (postgres, oracle, or mssql).
    2. In repository.xml:
      • Modify the DataSource section with the server host name, port, database, user, and password.
      • Modify the Cluster section to assign a distinct cluster ID, like Node1. Ensure unique IDs are assigned to every subsequent node in the cluster (for example, Node2, Node3).
      • Save the changes to repository.xml.
    3. Remove these folders from the /server/modules/spatial/jackrabbit folder: repository, version, workspaces.
  7. If your database has previously contained any repository content, you must remove tables from it so that a clean repository can be created. These tables need to be removed:
    default_binval security_binval
    default_bundle security_bundle
    default_names security_names
    default_refs security_refs
    rep_fsentry version_binval
    rep_global_revision version_bundle
    rep_journal version_names
    rep_local_revisions version_refs
    If using Oracle, then also delete version_seq_names_id, security_seq_names_id, and default_seq_names_id.
  8. On the seed node only, import the backed up repository content.
    1. Start the Spectrum™ Technology Platform server (for instructions, see Starting a Cluster).
    2. Import the contents using the limrepo import command, pointing to the seed node.
  9. Start the remaining nodes in the cluster (for instructions, see Starting a Cluster).