mark.littell

Upgraded to 10.5, can no longer publish services...

Discussion created by mark.littell on Feb 22, 2017
Latest reply on May 9, 2018 by williamw

Upgraded from 10.4.1 to 10.5

I applied the 10.5 publishing patch

Copied the the st_geometry.so and libst_raster_pg.so from Desktop to the Linux server running the PostgreSQL 9.3

When I try to publish a new or update an existing service ArcMap returns the following error message:

   Packaging succeeded, but publishing failed.

   ERROR 001487: Failed to update the published service with the server-side data location. Please see the server's log for more details.

   Please consult the GP Results Window for enhanced error description or contact your administrator for the server logs.

The Server Logs read:

Error executing tool. PublishServiceDefinition Job ID: j868d0fe80d114806ab528cf36ac3fe7f : 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 Shelters - County failed. Attempted connection string was ENCRYPTED_PASSWORD=<snip>;SERVER=1XX.XXX.XXX.175;INSTANCE="DSID=<snip>";DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=1XX.XXX.XXX.175;DATABASE=sde;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS. Table name is sde.sde.MyFeatureClass. Please verify the data exists on the server.

System/PublishingTools.GPServer

Failed to rename cache folder.

MyFolder/MyService _201702221422.MapServer

DoAfterSDExtraction failed.

System/PublishingTools.GPServer

SwizzleService failed.

System/PublishingTools.GPServer

Failed to rename cache folder.

MyFolder/MyService.MapServer

Method failed.HRESULT = 0x80070057 : The parameter is incorrect. .

MyFolder/MyService.MapServer

Method failed.HRESULT = 0x80070057 : The parameter is incorrect. .

MyFolder/MyService.MapServer

Service instance activation failed in 'MyFolder/MyService.MapServer'. AutomationException: 0x80004005 - Underlying DBMS error [FATAL: terminating connection due to administrator command could not receive data from server: Software caused connection abort (0x00002745/10053)::SQLSTATE=57P01] [sde.DEFAULT] in 'esriDataSourcesGDB.SdeWorkspace.1'

MyFolder/MyService.MapServer

Instance of service 'MyFolder/MyService.MapServer' failed to process a request.

MyFolder/MyService.MapServer

Outcomes