Repair spatial views tool

Idea created by ejuarbe on May 10, 2013
    • mvolz47
    • ejuarbe
    • WakePing
    • dewright_ca
    • middleton
    Add function to sdetable or GUI to repair corrupted spatial views (for previously functioning ones).

    Scenario:  I've built spatial views with joined business tables (using SQL Server Management Studio) they work fabulous...  Problems occur when we modify these views (removed existing fields, add subsequent joins. 

    Problems: The process of modifying the views seems to break the views functioning within ArcMap-all table registries seems to be present otherwise (and the view still work directly in the Database Management software).  All ArcServer services that rely on these views will stop working

    Suggestion: It would be nice to have the ability to reconstruct or fix the registry for these previously broken views, without having to start at the beginning and rebuild every view-thus reating new id values for these layers and forcing the need to rebuild links to the layers down the dependency line.

    Benefits: Repairing the existing views would alleviate the need to repair every ArcMap document and republishing every service that uses these views.  Yes, some may still break, but this will certainly be a lesser amount of effort, and a smaller impact due to disruption of service.