topic Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data in Water Utilities Questions

Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

JoelMa — Tue, 07 Apr 2020 02:28:03 GMT

I have tried many different things but still getting this error whenever I publish some utility network data. I was just trying out the ESRI sample Sewer Utility Network data (Naperville), followed the instructions to apply asset package, registered as branch versioned, enabled network topology, then tried to publish the map with utility network data from ArcGIS Pro, then got that error. My environment:

SQL Server Express 2019

ArcGIS Enterprise 10.7.1 (federated server with portal)

ArcGIS Pro 2.5

Weird thing is, I could publish another feature class from the same database just fine! I even tried publishing the Service Territory feature class within the utility network feature dataset and that was ok too! So ArcGIS Server can access that database fine, it somehow just doesn't like the utility network data.

The database is registered with ArcGIS Server, and seeing that I'm getting this error, I also created a data store item in Portal based on this: Create a data store item for an existing registered data store—Portal for ArcGIS (10.7 and 10.7.1) | Documentation for… BUT, that did not help at all.

I also tried arcpy, created an SD file and attempted to publish it directly in ArcGIS Server Manager - and got the same error!

Feels like this error will haunt me forever... I'm all out of ideas now, any help is much much appreciated!

Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

MikeMillerGIS — Tue, 07 Apr 2020 08:00:13 GMT

If you log into Server Manager, are any errors reported in the server log?

Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

JoelMa — Tue, 07 Apr 2020 09:26:07 GMT

Yes, error messages are like:

Server and publisher are both referencing the same database, so it is weird that it says it couldn't update with server-side data location. And the fact that I could publish a regular feature class (not from the utility network) from the same database shows that ArcGIS Server can access the data.

Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

SkipHeise — Tue, 12 May 2020 15:26:11 GMT

Hi Micheal,

I have encountered the same error as this person, on ArcGIS Pro 2.5 and server version 10.6.1. Has a workaround for this issue been discovered?

Thank you.

Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

MikeMillerGIS — Tue, 12 May 2020 15:44:39 GMT

Skip,

I would work with Tech Support, there may be an issue with pro 2.5 publishing to a 10.6.1 server. What version of the UN are you trying to publish?

Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

NaveenRawat — Sat, 30 May 2020 09:58:43 GMT

Hi Michael,

I am also encountering the same issue. Below are the configuration and UN info:
-SQL Server 2017
-ArcGIS Enterprise 10.6.1
-PRO 2.5.1
-UN Release 3

Is there a workaround for this issue?

Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

MikeMillerGIS — Sat, 30 May 2020 12:58:54 GMT

I believe you need Enterprise 10.7.1 or greater for a version 3 UN. I would suggest updating to 10.8 and make sure to install the patch.

Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

NaveenRawat — Mon, 01 Jun 2020 10:40:42 GMT

Thanks Michael, I am currently updating to 10.8, will test it when its done.

Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

ScottBaum — Tue, 20 Oct 2020 14:21:26 GMT

For reference, I am running into the same issue. I am using Pro 2.6 publishing to AGS 10.8 with the latest suggested service packs. I am also using the latest version of the Sewer model. Has this been resolved or are there any known workarounds? Thanks for any input you can provide.

Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

MikeMillerGIS — Tue, 20 Oct 2020 17:40:30 GMT

If you used 2.6 to create a Utility Network, you have a version 4 UN, which is not supported on 10.8. More info here:

https://pro.arcgis.com/en/pro-app/help/data/utility-network/utility-network-dataset-administration.htm

Re: Get Error 001487: Failed to update the published service with the server-side data location, when publishing Utility Network data

Joshua-Young — Wed, 28 Apr 2021 20:28:08 GMT

Did anyone find a resolution for this issue?

I am not even using the utility network. I am trying to publish three layers configured for branch editing and one of the three layers fails with the same error message as @JoelMa was getting. The layers are coming from the same enterprise geodatabase connection file, same user, and same owner. I turned on more detailed logging and the layer that is failing is trying to use a different encrypted password for the server side connection than what the other two layers are using when trying to publish. I tried changing the password for the database user and updating the data store connection string through the ArcGIS Server UI but publishing still fails at the SwizzleService because it does not like the encrypted password string and only for that one layer out of three.