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
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!
I am having the same issue. My setup:
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.
It fails if I want access to features, WMS is OK.
Same data published OK in our test environment.
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.
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...