BUG-000157867 for ArcGIS Pro

Número de ID del error	BUG-000157867
Enviado	April 27, 2023
Última modificación	June 5, 2024
Relacionado con	ArcGIS Pro
Versión encontrada	2.9.6
Sistema operativo	Windows OS
Versión de sistema operativo	10.0 64 Bit
Versión corregida	3.2.0.48495, 2.9.11
Estado	Fixed

Información adicional

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.

Pasos para reproducir

ID del error: BUG-000157867

Software:

ArcGIS Pro

Descubrir más sobre este tema

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga

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

Información adicional

Pasos para reproducir

Recibir notificaciones cuando cambie el estado de un error

Descubrir más sobre este tema