laptop and a wrench

Bug

Creating a utility network diagram using the Basic template returns the drawing error "A column was specified that does not exist."

ArcGIS Pro
Bug ID Number BUG-000178567
SubmittedAugust 8, 2025
Last ModifiedAugust 27, 2025
Applies toArcGIS Pro
Version found3.3.6
Operating SystemWindows OS
Operating System Version11.0 64 bit
StatusKnown Limit

Additional Information

This happens after upgrading 10.9.x or earlier geodatabase in SQL Server. After this upgrade operation, the fully qualified names of tables and feature classes no longer contain the database name in the SQL geodatabase while the diagram layer, diagram rule and layout definitions still reference this database name.

Workaround

In this SQL geodatabase example, any <FeatureClassName> network source class is referenced in the diagram definitions as 'Elec_UN.UNOWNER.<FeatureClassName>' while it should be referenced as 'UNOWNER.<FeatureClassName>'.

The workaround consists in removing the database name in the diagram definitions like detailed below.

Note: This workflow applies configuration and administration tools that must be run using a database connection to the utility network in the enterprise SQL geodatabase.

The following are requirements:

  • Create a database connection to the database using the database utility network owner credentials.
  • Connect to ArcGIS Enterprise portal using the portal utility network owner credentials.
  1. Run the 'Export Diagram Template Definition' tool to export both the Rule and Layout Definition (A_BuilderDef.ndbd output file) and the Diagram Layer Definition (A_LayerDef.ndld output file) for diagram template A.
  2. Update the layer definition for template A.
    1. Rename the A_LayerDef.ndld file with the .zip extension => A_LayerDef.zip, and unzip A_LayerDef.zip.
    2. Open the unzipped resulting Dummy.json using a text editor such as Notepad.
    3. Search for the '<DatabaseName>.' strings; for example 'Elec_UN'. In this example, and replace all these string occurrences by an empty string''.
    4. Save the Dummy.json file and close it.
    5. Zip the edited Dummy.json file and rename the zip file with the .ndld extension as 'A_LayerDef.ndld'.
    6. Delete Dummy.json file.
  3. Update rule and layout definition for template A.
    1. Rename the A_BuilderDef.ndbd file with the .zip extension => A_BuilderDef.zip, and unzip A_BuilderDef.zip.
    2. Open the unzipped resulting Dummy.json using a text editor such as Notepad.
    3. Search for the '<DatabaseName>.' string; for example, 'Elec_UN'. In this example, and replace all these string occurrences by an empty string ''.
    4. Save the Dummy.json file and close it.
    5. Zip the edited Dummy.json file and rename the zip file with the .ndbd extension as 'A_BuilderDef.ndbd'.
    6. Delete Dummy.json file.
  4. Update the template definitions.
    1. Run the 'Import Diagram Template Definition' tool to import both the edited Rule and Layout Definition (A_BuilderDef.ndbd edited file) and Diagram Layer Definition (A_LayerDef.ndld edited file) for diagram template A.
    2. Stop and restart the related network service.
    3. Create a diagram based on template A and verify it now opens as expected without drawing error anymore.
  5. Repeat steps 1 to 4 for each diagram template B, C, D, and so on, existing for the utility network.

Steps to Reproduce

Bug ID: BUG-000178567

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options