laptop and a wrench

Bug

The Delete Diagram Template tool runs indefinitely and does not complete.

ArcGIS Pro
Bug-ID-Nummer BUG-000157867
EingereichtApril 27, 2023
Zuletzt geändertJune 5, 2024
Gilt fürArcGIS Pro
Gefunden in Version2.9.6
BetriebssystemWindows OS
Betriebssystemversion10.0 64 Bit
Behoben in Version3.2.0.48495, 2.9.11
StatusFixed

Zusätzliche Informationen

This issue is addressed in version 3.2.0.48495 and version 2.9.11. Side note after deleting a template with or without this fix Since a diagram template is not versioned, there is no interest to keep any of its related versioned diagram rows (including its related features, aggregations and relations) after its deletion. After deleting a diagram template in production, all these rows should be deleted by the utility network owner/database admin to reduce the database foot print. To do so, once the template deletions complete, the database admin can run the following sample SQL script USE GO DECLARE @guid VARCHAR(100) SET @guid = (SELECT TOP(1) [GLOBALID] FROM [].[UN__DIAGRAMS] WHERE [TEMPLATEGUID] NOT IN (SELECT [GLOBALID] FROM [].[UN__TEMPLATES])) WHILE (@guid <> '') BEGIN DELETE [].[UN__RELATIONS] WHERE [DIAGRAMGUID] = @guid DELETE [].[UN__AGGREGATIONS] WHERE [DIAGRAMGUID] = @guid DELETE [].[UN__JUNCTIONS] WHERE [DIAGRAMGUID] = @guid DELETE [].[UN__EDGES] WHERE [DIAGRAMGUID] = @guid DELETE [].[UN__CONTAINERS] WHERE [DIAGRAMGUID] = @guid DELETE [].[UN__DIAGRAMS] WHERE [GLOBALID] = @guid SET @guid = (SELECT TOP(1) [GLOBALID] FROM [].[UN__DIAGRAMS] WHERE [TEMPLATEGUID] NOT IN (SELECT [GLOBALID] FROM [].[UN__TEMPLATES])) END; Specific use case With this specific backup database, it appears that the single diagram template in the dataset is going to be deleted. In such a situation, once the template deletions complete and there is no template anymore in the dataset, and the database admin can run a TRUNCATE on the following 6 tables: [].[UN__RELATIONS], [].[UN__AGGREGATIONS], [].[UN__JUNCTIONS], [].[UN__EDGES], [].[UN__CONTAINERS] and [].[UN__DIAGRAMS] NOTE: This fix is provided as an example and could be probably optimized.

Schritte zur Reproduzierung

Bug-ID: BUG-000157867

Software:

  • ArcGIS Pro

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln