topic Failed to add Utility Network Feature Service Layers in Geodatabase Questions

Failed to add Utility Network Feature Service Layers

EdwardBlair — Thu, 13 Dec 2018 14:43:29 GMT

So I published to my ArcGIS Enterprise site a set of utility network layers based on UPDM 2018. I can view these in map viewer and scene viewer and even in ArcMap. But when I try to add the feature service to ArcPro it fails and I get the notification "Failed to add facility network data" with no further information.

Any pointers on what I am missing here would be much appreciated.

Thx,

Ed#

Re: Failed to add Utility Network Feature Service Layers

XanderBakker — Thu, 13 Dec 2018 14:52:48 GMT

Hi Edward Blair ,

Did you follow the steps explained here: Gas Utility Network Configuration | ArcGIS Solutions for Gas to set up your Utility Network? Did you use the UPDM data model UPDM 2018 Edition as asset package in the Apply Asset Package tool?

If so, maybe tdewitte-esristaff can give you some pointers.

Re: Failed to add Utility Network Feature Service Layers

EdwardBlair — Thu, 13 Dec 2018 15:07:53 GMT

Xander -

Thanks for the feedback. I followed the steps in Gas Utility Network

Configuration

<http://solutions.arcgis.com/gas/help/gas-utility-network-configuration/>

to the best of my ability. Though I admit that I'm not sure if the

results of the deployment tool

<http://solutions.arcgis.com/shared/help/deployment-tool/#what-you-get> were

complete or correct.

I was just hoping that the error message I got when trying to add the

feature service layers would have a little more info.

Re: Failed to add Utility Network Feature Service Layers

EdwardBlair — Thu, 13 Dec 2018 16:24:06 GMT

I think I found my problem. Its at least *one* problem anyway. Checked the server log and found that it was choking on a feature with an empty geometry. Need to see if I can find and resolve the offending feature.

Re: Failed to add Utility Network Feature Service Layers

EdwardBlair — Thu, 13 Dec 2018 18:10:32 GMT

Found that there are no truly "empty" geometries in the data, though there are some lines that are quite short. Need to find out what geometry characteristics that server uses to conclude that a feature geometry is "empty"...

Re: Failed to add Utility Network Feature Service Layers

EdwardBlair — Sun, 16 Dec 2018 15:02:47 GMT

A little more info here. Rebuilt the source database with a smaller set of data. Validated the network topology and only a handful of topology errors remain. Re-published map/feature services.

Now I can open and edit feature services in the Enterprise "Map Viewer", which I take as a good sign.

However, when I try to add these services to ArcGIS Pro I get nothing. Examining the server log shows a bunch of "operation was attempted on an empty geometry" errors (below). Scratching my head here.

- Is Pro sensitive to lines with parametric curves?

- The database is SQL*Server 2017. Is there something about geometry data storage in this database that Pro doesn't like?

- Some features have no data - StructureJunctions, for example. Does Pro not like this?

If anyone has seen this kind of thing any pointers would be appreciated.

Thx,

Re: Failed to add Utility Network Feature Service Layers

MichaelVolz — Sun, 16 Dec 2018 19:47:48 GMT

Did any documentation say that a SQL Server 2017 database has been certified for Pro?

Re: Failed to add Utility Network Feature Service Layers

EdwardBlair — Sun, 16 Dec 2018 19:55:29 GMT

Michael -

As I've spoken with Tech Support (a couple times now) this was not

mentioned as a problem. Guess I can double-check. Thanks for the feedback.

Re: Failed to add Utility Network Feature Service Layers

EdwardBlair — Sun, 16 Dec 2018 19:57:17 GMT

Yep.. Seems to be

https://pro.arcgis.com/en/pro-app/help/data/databases/database-requirements-sqlserver.htm

Re: Failed to add Utility Network Feature Service Layers

EdwardBlair — Sun, 16 Dec 2018 21:02:56 GMT

Wonder if this could be related to the Error Layers that are associated with the Utility Network that's in the map? I've tried publishing the service with these things turned on and turned off and have seen no difference.

Re: Failed to add Utility Network Feature Service Layers

HusseinNasser2 — Tue, 18 Dec 2018 05:23:51 GMT

Hi Edward,

Can you provide which version of Pro and server?

Also, can you try publishing a brand new feature service by doing the following? I want to eliminate certain variables

1. Connect to your geodatabase and make sure the connection is branch

2. Right click on your utility network dataset and select add to a new map

3. Say yes to the prompt to add all layers

4. Publish as feature service and enable the version management server and make sure to enable default for Zs

5. Use this service and see if you still see the errors.

Would you mind sharing an asset package with us as repro case?

Re: Failed to add Utility Network Feature Service Layers

EdwardBlair — Tue, 18 Dec 2018 14:16:07 GMT

Hussein -

Thanks for the suggestion. These steps seem to work - as in, I can add

the resulting feature service to ArcGIS Pro, edit things and the Utility

Network toolbar is enabled. The attached has a blow-by-blow account.

Am not sure what steps are different than what I had done before (and which

failed). Other than the way the map was composed. In my work flow I

included individual feature classes in the map one by one (PipelineLine,

PipelineDevice, etc.) and then added the UtilityNetwork choosing to not

add all layers -- they were already in the map. Wonder if this made a

difference.

Anyway, I seem to have a path to follow. Thank you very much!

Re: Failed to add Utility Network Feature Service Layers

HusseinNasser2 — Tue, 18 Dec 2018 15:02:42 GMT

Glad that worked Ed,

I still would like to know why the original approach didn't work for you, because there could be a lurking bug that we have been chasing for a while. I'm assuming you were using a special publishing map Gas Utility Network, so you can get advantage of the symbologies that comes with the model and then you repaired that map to point to your dataset correct?

Can you compare the subtypes for each layer between the service that works and the service that doesn't ? You can do that by adding both services to Pro (two different maps and just compare each layer)

Re: Failed to add Utility Network Feature Service Layers

EdwardBlair — Tue, 18 Dec 2018 17:10:44 GMT

Hi Hussein -

I originally started with an empty map and added to it layers, one-by-one

from my client-server Geodatabase and then assigned symbology to asset

groups/asset types that are actually present in my sample database. I

added the utility network at the end and opted to not include layers as

that would have duplicated layers I thought were already present. The

attached PPT has layer-by-layer contents from the original map (that did

not work) and the map started by adding in the utility network and

associated layers (that did work). Contents look pretty much the same to

me - but I hope this is helpful.

Thanks,