Unable to publish map service with data in enterprise database using Server 10.4
I have upgraded ArcGIS Server 10.3.1 to 10.4 and facing issues with publishing map services with data stored in enterprise databases.
The server is hosted in Amazon AWS with following infrastructure and works fine:
Windows 2012 R2
Server 10.3.1
PostgreSQL 9.3 (in the same server - localhost) with SDE enabled
PostgreSQL as AWS RDS with SDE enabled
However, when the server upgraded to 10.4, the service with data in enterprise databases (both localhost and AWS RDS) which used to publish are no longer working. The error is
The ArcServer log file shows the following details
Error executing tool. PublishServiceDefinition Job ID: j5a9a52478ffc49d19328e5ceefbb609f : 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). System/PublishingTools.GPServer
Failed to create the service.: Updating the server connection string for layer sdedb1.web.%gwstatmaster_staging Events failed. Attempted connection string was ENCRYPTED_PASSWORD=00022e68334e624d44786b57627653553542393435702b3845413d3d2a00;SERVER=xxxxxxx.c11tt3rfoa7s.eu-west-1.rds.amazonaws.com;INSTANCE="DSID=a8960749-e49c-41db-a095-a8a257a693b4";DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=xxxxxx.c11tt3rfoa7s.eu-west-1.rds.amazonaws.com;DATABASE=sdedb1;USER=web;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS. Table name is sdedb1.web.%gwstatmaster_staging. Please verify the data exists on the server. System/PublishingTools.GPServer
If I uninstall 10.4 and reinstall 10.3.1 on the same server, everything back to normal and working fine.
Has anyone else experienced the same issue?
Thanks and any suggestions much appreciated
Thomas
there are two options that i can think of:
Option #1: Try what is mentioned as the alternate solution in the bug's description. Christian Wells put the link to the bug above. Basically try to publish from a previous version of ArcMap (10.3 or 10.3.1)... It is not always guaranteed to work though.
Option #2: You can also try a manual process in case you feel adventurous 
Disclaimer: you need to have admin privileges on ArcGIS Server.
Overall steps:
- Create an msd
- Use ArcGIS Server Admin site to create a map service using the msd
Details:
To create an msd:
- you can use arcpy.mapping.ConvertToMSD() function, OR
- in ArcMap, open 'Customize' window from 'Customize | Customize Mode... menu item'
- switch to 'Commands' tab
- select 'Map Service Publishing' from 'Categories' list box.
- from 'Commands' list box on the right, drag and drop 'Save Map Service Definition...' on to an existing toolbar
- Close
- use the newly added 'Save Map Service Definition' tool to create a msd and save it some place where ArcGIS Server Account has access to.
Publish a map service from ArcGIS Server Admin site:
- Browse to http://yourServerMachine:6080/arcgis/admin/services/createService
- Read the API Reference help on 'createService' operation. There should be a json that you can use as a boilerplate.
- Make necessary changes in the boilerplate json.
Most important ones are: name of the service, path to the msd etc. - paste the json in the only textbox available on the 'createService' operation page
- click on 'Create'
- once that is done successfully, and if the service is not started yet, you can use Admin Site or Manager to start the newly created service.
