Steps to deploy Communications Utility Network Foundation 1.4

[robertopepato_bizpoke]

Hi community, 

I'm currently working to have available demonstration environments for Utility Network in our ArcGIS Enterprise deployment for Communications, Electric, Water, and Gas domains. The goal is to have, for each domain, a deployment of the respective Utility Network Foundation model, containing both the UN schema for that domain and the companion data from the Naperville data sample.

Indeed, I was able to apply the Asset Package with companion data for Electric, Water, and Gas, but I'm facing some challenges with the Communications Utility Network Foundation. What I did up to now was:

1. Tried to copy and paste the feature dataset from the sample UN contained in the Communications Utility Foundation Model. It did fail as discussed here (see the message box screenshot with the error details below).

2. Went through the Export/Stage/Apply:
   2.1 Executed "Export Asset Package" from the existing fgdb UN - it works
   2.2 Executed "Stage Utility Network" on the enterprise geodatabase - it works
   2.3 Executed "Apply Asset Package" using the gdb exported in step 2.1(Structures and Communications domain network selected) and the target UN generated in step 2.2 ("Load Data" and "Calculate Spatial Index and Analyze" options were selected) - it fails (failure message in the screenshot below)

I'm interested to know if anyone has additional ideas on how to meet the deployment goal. Since I'm trying to keep everything as simple and straightforward as possible.


Here are the details of my execution environment:

ArcGIS Enterprise 11.1
Enterprise Geodatabase is SQLServer
ArcGIS Pro 3.12
Communications Utility Network Foundation v1.4 

  

  

[robertopepato_bizpoke]

UPDATE:

I can apply the asset package if I let "Calculate Spatial Index and Analyze" unchecked. According to the Apply Asset Package tool reference (https://solutions.arcgis.com/utilities/help/utility-network-automation/tool-reference/apply-asset-pa...), the eventual downside (performance related) may happen at the time of enabling topology. I'll test it and update this topic with that experience soon.

Thanks.

[RobertKrisher]

@robertopepato_bizpoke I recommend you reach out to @mmiller to review the logs from apply asset package to see which specific table it was failing on.

[MikeMillerGIS]

If you zip up the ap_workspace folder, we can take a look at what is going on.  I believe the copy paste is BUG-000152404

[MikeMillerGIS]

When you go to enable, it should report what table is missing the spatial index.  This could help us track down what is going on.  I also see you have 7 maps in your pro project.  Due to a change in how Pro evaluates maps, even closed ones, we suggest calling Apply Asset Package with a Pro project with no maps.

[robertopepato_bizpoke · Accepted solution]

Hello everybody, I was able to finish the planned deployment. In summary:

1 - I didn't notice any considerable performance penalty while executing the Enable Network Topology GP;
2 - As I did uncheck "Calculate Spatial Index and Analyze" at the Asset Package load phase, I got errors about missing spatial indexes for all the UN feature classes. After I manually create those indexes, everything worked as expected.

@MikeMillerGIS, just for reference, see the logs from the errors below.

Since it works now, I'm closing this thread but I'll in near future still try your idea of using a blank project and Apply the Asset Package from there. In my case, I was using the UN Foundation project as the environment to run the tools.

Thank you @RobertKrisher and @MikeMillerGIS for your help.

Start Time: Friday, August 18, 2023 10:45:13 AM

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.

The spatial index was not found. [UN_COMM14.StructureJunction]

Failed to execute (EnableNetworkTopology).

Failed at Friday, August 18, 2023 10:45:37 AM (Elapsed Time: 23.93 seconds)

Start Time: Friday, August 18, 2023 10:48:21 AM

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.

The spatial index was not found. [UN_COMM14.StructureLine]

Failed to execute (EnableNetworkTopology).

Failed at Friday, August 18, 2023 10:48:46 AM (Elapsed Time: 24.37 seconds)

Start Time: Friday, August 18, 2023 10:53:01 AM

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.

The spatial index was not found. [UN_COMM14.CommunicationsDevice]

Failed to execute (EnableNetworkTopology).

Failed at Friday, August 18, 2023 10:53:25 AM (Elapsed Time: 23.86 seconds)

Start Time: Friday, August 18, 2023 10:55:26 AM

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.

The spatial index was not found. [UN_COMM14.CommunicationsAssembly]

Failed to execute (EnableNetworkTopology).

Failed at Friday, August 18, 2023 10:55:49 AM (Elapsed Time: 22.78 seconds)

Start Time: Friday, August 18, 2023 10:57:10 AM

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.

The spatial index was not found. [UN_COMM14.CommunicationsJunction]

Failed to execute (EnableNetworkTopology).

Failed at Friday, August 18, 2023 10:57:33 AM (Elapsed Time: 23.23 seconds)

Start Time: Friday, August 18, 2023 10:59:06 AM

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.

The spatial index was not found. [UN_COMM14.CommunicationsLine]

Failed to execute (EnableNetworkTopology).

Failed at Friday, August 18, 2023 10:59:29 AM (Elapsed Time: 23.37 seconds)