ERROR 001487: Failed to update the published service with the server-side data location.

2559
5
08-29-2019 05:57 AM
Arpa_PiemonteGeoportal_Team
Occasional Contributor II

Everytime we try to update a map service using the overwrite web layer option in ArcGIS Pro  the error appears.

Notice that this error appears only when we try to do an "Overwrite" . The publish  new web layer tool always works fine.

We use Arcgis pro 2.4 to publish on ArcGIS Enterporise 10.7 istance (Porlal and Arcgis server 10.7 on windows server)

The complete Log is here attached:

All our ArcGIS projects  are based on different SDE layers as registered databases.  All the databases used are correctly validated in the ArcGIS Server manager 

To better undestand the error :

1) We tried to publish and overwrite the same services changing the connection to the dataset, from "registered data" to "copy all" option : in this case the overwrite works fine.

2) We tried also to publish /overwrite  the service directly on the hosted ArcGis server using arcmap , and it works fine.

Please, any help is higly appreciated...

Thank you in advance

Enrico

0 Kudos
5 Replies
DanielCota
New Contributor II

Arpa Piemonte Geoportal Team

Check to make sure the layers in the project are indeed sourced in the proper enterprise geodatabases. Different versions/connection properties can affect the publishing process if you are referencing the data. For example, if the data is sourced in the same database, but accessed with a different user than what is registered with AGS, then it can result in this error.

Best of luck!

VaL
by
New Contributor II

I am having the same issue. My setup:

  1. Data is stored in SDE DB.
  2. Data is accessible in arcmap.
  3. I create and sd file in arcmap.
  4. Sde file is referenced by arcgis server and validates OK (user has full access to data in SDE).

When trying to publish from AGS from sd file I get:

 ERROR 001487: Failed to update the published service with the server-side data location. Please see the server's log for more details. ERROR 001369: Failed to create the service. Failed to execute (Publish Service Definition).

Nothing more in the server log for this attempt than this:

 

 

Failed to create the service.: Updating the server connection string for layer sqldbuatgisdb.PROPERTY.prLettingEasementLine failed. Attempted connection string was ENCRYPTED_PASSWORD=fffff;SERVER=ip.net;INSTANCE="DSID=c9e5a34b-8bec-4f9f-85e6-87daf7d98674";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ip.net;DATABASE=db;USER=user;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS. Table name is sqldbuatgisdb.user.fc. Please verify the data exists on the server.

 

 

any idea?

It fails if I want access to features, WMS is OK.

Same data published OK in our test environment.


0 Kudos
Arpa_PiemonteGeoportal_Team
Occasional Contributor II

Tried all the forum and posts suggestions but the error remains...

All database sources are always  the same as before and they are validated client side and server side.

We did't undestand the error but we Solved it  trying a total restore of Arcgis ebnetreprise  from portal backup.

Notice that the backup file  we used referenced a portal status that already had the error (back up of one day before versun error that appeared since unone month ago) : so we think that restore "heal " some confifuration statust in the data store or in the sevice definitions..

Hoping ESRI Staff will look min this eror deeply.

best

Enrico

0 Kudos
JeffSauder
Occasional Contributor

I had this same issue, I had changed a password on the account that is used for the layers in the project.  I realized after searching for just about everything else, and looking at the not very helpful AGS Server logs, that I needed to remove the account from the registered DBs in AGS Server, and re-add the connection.  After that it worked fine, I guess it had a conflict with the new password and the one that was stored in the registered connection on Server.  I hope this saves someone a lot of frustration and searching...

Hussam_AlJabri
Occasional Contributor II

Super!

Hussam Al Jabri,
0 Kudos