Recover catalog data - Intergraph Smart 3D - Administration & Configuration - Hexagon

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
13.1

The workflow in this topic explains how to recover catalog data if there is a mismatch of information for the Catalog or Catalog schema databases between the Host and any of the Satellite locations in a Smart 3D Global Workshare environment. This workflow does not affect the replication of the Site or Model databases and involves a much smaller maintenance window than what is required when performing the full consolidation and duplication workflows used to recover a lost Satellite.

Recovery of catalog data consists of removing the replication link (represented by the subscriptions) that exists for the Catalog and Catalog schema databases. Removing these subscriptions is necessary so that the databases can be overwritten during the restore operation at the Satellite location. After the replication link is down, a backup of the Catalog database is made at the Host. This backup is then transferred to the Satellite location where it is restored, and the replication link is subsequently re-established.

The Catalog and Catalog schema databases must be recovered as a pair, even when only one of the databases is presenting a problem.

  1. Suspend any activities that write data to the Catalog database at the Host. These activities include, but are not limited to, the following:

    • Bulkloading data into the catalog.

    • Creating catalog filters.

    • Using the Copy to Catalog command to copy assemblies into the catalog.

    • Modifying catalog data in the Catalog task.

    Modeling activities can continue during the recovery workflow as long as they do not modify the Catalog or the Catalog schema.

  2. At the Host and the Satellite location, make a backup of the Catalog database involved in the operation. This backup serves as a fail-safe recovery point. See Create a backup file.

  3. In the Microsoft SQL Server Management Studio, connect to the Host location and then remove the replication link between the Host and the Catalog and Catalog schema databases at the Satellite location being repaired. See Delete a Subscription at the Host in Remove SQL Server replication.

    If there are multiple Satellite locations, delete only the subscriptions for the Satellite location at which catalog is being recovered. In the example below, the Catalog and Catalog Schema subscriptions outlined in red are being removed:

    Do not delete the publication of the Catalog or Catalog schema databases (represented with the icon). Deletion of publications aborts the recovery workflow and requires a full consolidation and duplication of the Model at the Satellite location.

  4. In the message box that displays, make sure Connect to Subscriber and delete record of this subscription at Subscriber also is selected, and then click OK. To allow deletion of subscription records, the Satellite server must be running and accessible. Otherwise, these records must be deleted manually at the Satellite.

  5. If prompted, provide login details for the Satellite server.

    Only the subscriptions for the Model, Site, and Site schema databases remain, as shown in the example below:

  6. At the Host location, navigate to the destination folder that you specified when the backup file was created, and then locate the .dat file for the catalog.

  7. To send the backup file to the Satellite location, create a .ZIP file that contains only the compressed Catalog file data.

  8. At the Satellite location, integrate the Catalog database backup file that was transferred from the Host into one of the Satellite backups.

    When the integration is complete, the backup at the Satellite location consists of the four files required for a Smart 3D backup; however, the Catalog database contains the information from the Host server.

  9. Open Project Management at the Satellite location.

  10. Click Tools > Restore, and select the Restore one or more model databases from backup option to restore the catalog. See Restore one or more model databases from backup.

    The software displays a warning that a catalog database with the same name currently exists in the server location and asks if you want to link the existing catalog database instead of restoring the catalog database from backup.

  11. Select No in the message box to indicate that the catalog database should be restored and not be linked.

  12. Select Overwrite in the next message box to overwrite the Catalog database.

  13. Select No to prevent the Model database from being overwritten.

  14. When the restore operation at the Satellite location is complete, review the log file for any errors.

  15. Open the Microsoft SQL Server Management Studio at the Host location, and recreate the subscriptions for the Catalog and Catalog schema databases. See Set up one-way subscriptions for SQL Server. The example below shows the subscriptions for the five databases participating in the Global Workshare:

    When recreating the subscriptions, clear the Initialize check box on the Initialize Subscriptions page of the New Subscription Wizard.

  16. Open the Replication Monitor, and verify that replication of data for the new subscription is working appropriately. See Monitor replication in SQL Server.

    After you have verified that the replication of data for the Catalog and Catalog schema databases is working appropriately, normal activities can be resumed.