Select to view content in your preferred language

Warning for Utility Network and Trace Network users before upgraded a geodatabase in SQL Server to 11.0 or higher

130
0
a week ago

Warning for Utility Network and Trace Network users before upgraded a geodatabase in SQL Server to 11.0 or higher

Context

Network diagram building process is based on diagram rule & layout definitions configured on the diagram template that users choose at the time they create a diagram.
Also, diagram display reflects diagram layer definition set up on this diagram template.

When an Enterprise SQL geodatabase is created with ArcGIS Pro versions prior to 3.0, these definitions are stored in the Templates table with a fully qualified object name, database.owner.table.
Once this Enterprise SQL geodatabase is upgraded to 3.0/11.0 or higher, the fully qualified name of tables and feature classes no longer contain the database name. That is, the ArcGIS client returns each table and feature class name without the database name: owner.table.
However, the diagram template definitions still reference the database name in the upgraded geodatabase causing mismatching that impact your network diagram workflow.

Symptoms

In this situation, whether you are working with the SDE direct connection or consuming the related published service, this results in the following bad consequences:

  • Diagram creation and update can fail when diagram rules set up on the template try to process network feature/object related to particular network sources since these network sources no longer exist with the database name in the upgraded dataset.
  • Diagram display may appear ok at a first glance when using ArcGIS Pro 2.9 client, but warnings telling about invalid fields raise up in the Symbology/Label panes when checking diagram sublayer or labeling properties. Also, when using any ArcGIS Pro 3.0 client and higher, diagram display completes with drawing alerts and the diagram content is not fully visible. Again, these display failures are due to database names that persist in diagram layer definitions while there is no network source anymore with such a fully qualified name in the upgraded dataset.

Solution

To avoid such mismatching, there are two distinct workflow:

A - The first one is the simplest and starts before you upgrade your Enterprise SQL geodatabase. It only applies standard Pro tools.

B - The second one concerns Enterprise SQL geodatabases that are already upgraded. It runs a custom console app to upgrade template definitions.

These two workflow are detailed in the following sections.

A - Exporting template definitions before upgrading Enterprise SQL geodatabases and re-importing them after upgrade

NOTE: This workflow is the one to run when you did not upgrade your Enterprise SQL geodatabase yet. It prevents the geodatabase and template definition mismatching described above.

This workflow consists of 3 simple steps.

1/ Exporting the diagram template definitions

  • Start ArcGIS Pro and connect to your portal using the portal owner credentials.
  • Create a New Database Connection to the Enterprise SQL Server geodatabase you want to upgrade using the database owner credentials.
  • Connecting as the database owner, run the Export Diagram Template Definitions tool on each diagram template to export both its rule & layout definition and its layer definition. You end with a couple of .ndld and .ndbd files for each.

2/ Upgrading the Enterprise SQL geodatabase

  • Stop any ArcGIS service related to the geodatabase.
  • Start ArcGIS Pro 3.0 or higher.
  • Create a New Database Connection to the Enterprise SQL Server geodatabase you want to upgrade using the database administrator credentials.
  • Connecting as the database administrator, run the Upgrade Geodatabase tool.

3/ Importing the diagram template definitions

  • Connecting as the database owner, run the Import Diagram Template Definitions tool on each diagram template to re-import both the couple of .ndld and .ndbd files for each template in the upgraded geodatabase.

Post Requirement: Re-start the related services.

NOTE: In the WorkflowA.zip file attached below, you will find a custom toolbox with two simple script tools that you can use to apply step#1 and #3 more efficiently. They loop on each diagram template existing for the utility network or trace network you provide as an input to:

  • Export their related definitions to the output folder you specify (Export All Diagram Template Definitions script tool) .
  • Import layer and rule & layout definitions from an input folder you specify (Import All Diagram Template Definitions script tool).

Note that these two custom script tools can also help in other scenarios.

 

B - Fixing diagram build and display failures in upgraded Enterprise SQL geodatabases

NOTE: This workflow is the one to run when you already upgraded your SQL Server Enterprise SQL geodatabase. It allows fixing the failures that start raising up after this upgrade.

In this situation, both the diagram rule & layout and diagram layer definitions must be updated by removing the persisted database name occurrences for each existing diagram template.

If you end up in such a situation, download the WorkflowB.zip files attached with this post and run the workflow steps detailed in the WorkflowB_ReadMe PDF document to fix your diagram template definitions.

Attachments
Version history
Last update:
a week ago
Updated by:
Contributors