Numéro d’ID de bogue |
BUG-000157867 |
Envoi | April 27, 2023 |
Dernière modification | June 5, 2024 |
S’applique à | ArcGIS Pro |
Version trouvée | 2.9.6 |
Système d’exploitation | Windows OS |
Version du système d’exploitation | 10.0 64 Bit |
Version de correction | 3.2.0.48495, 2.9.11 |
Statut | Fixed
Le bogue a été corrigé. Pour plus d’informations, reportez-vous aux sections Version de correction et Informations supplémentaires, le cas échéant.
|
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: