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

参考情報

対処法

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.

再現の手順