Amputate and re-duplicate - Intergraph Smart 3D - Administration & Configuration

Intergraph Smart 3D Global Workshare (SQL Server)

Language
English
Product
Intergraph Smart 3D
Subproduct
Global Workshare
Search by Category
Administration & Configuration
Smart 3D Version
12.1 (2019)

Use the following workflow when one of the Satellite servers participating in a Global Workshare Configuration (GWC) experiences a catastrophic failure and can no longer participate in the GWC. This workflow allows the GWC to remain active. Only the lost Satellite location experiences an immediate work stoppage.

  1. Delete all subscriptions (MSSQL) or Golden Gate processes (Oracle) to the lost Satellite server to be amputated. For example, in the following configuration, Satellite server HOUSRV1 has suffered massive failure causing it to be periodically unavailable. As a result, SQL Agents for the Push Subscriptions HSVSRV1 > HOUSRV1 and OSLSRV1 > HOUSRV1 are failing. See Remove SQL Server replication.

    BackupRestpre_GWC2

    After the incoming and outgoing distributions are removed for the failed Satellite, the resulting configuration resembles the illustration below. In this scenario, the remaining locations can continue participating in the GWC with no work stoppage.

    BackupRestpre_GWC3

    Permission groups cannot be moved and must stay with the "amputated" Satellite.

  2. As soon as it becomes practical to do so, use Tools > Consolidate Model from Workshare Command to perform the consolidation workflow for the failed Satellite location to merge at the Host location.

  3. Use the standard replication workflow to re-duplicate the amputated satellite location to create a consolidated dataset. See Duplicate the model for Global Workshare Configuration.

Because consolidation scripts only execute against the Host server, the absence of any Satellite is recoverable. As a result, you can extend the amputate and re-duplicate workflow to a situation involving multiple Satellite servers failing due to a broader network failure that has a long-term fix date.