laptop and a wrench

Bogue

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

ArcGIS Pro
Numéro d’ID de bogue BUG-000157867
EnvoiApril 27, 2023
Dernière modificationJune 5, 2024
S’applique àArcGIS Pro
Version trouvée2.9.6
Système d’exploitationWindows OS
Version du système d’exploitation10.0 64 Bit
Version de correction3.2.0.48495, 2.9.11
StatutFixed

Informations supplémentaires

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.

Étapes pour reproduire

ID de bogue: BUG-000157867

Logiciel:

  • ArcGIS Pro

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement