laptop and a wrench

Bug

When publishing a map service containing a XY event layer that is created from an enterprise geodatabase table, the layer fails to publish and results in this error: "Error 001487: Failed to update the published service with the server-side data location."

Last Published: May 23, 2016 ArcGIS for Server
Bug ID Number BUG-000096129
SubmittedApril 27, 2016
Last ModifiedJuly 20, 2022
Applies toArcGIS for Server
Version found10.4
Operating SystemWindows OS
Operating System Version2008 R2
Version Fixed10.5.0
StatusFixed

Workaround

SQL Server work around:Instead of using the XY event layer, construct a geometry or geography field based on the X and Y data in the database, and create a query layer using the new table.Oracle work around:--Create function to return the XY data as SDO shape (REQUIRED)create or replace function get_long_lat_pt(longitude in number, latitude in number, srid in number)return SDO_GEOMETRY deterministic isbegin return sdo_geometry(2001, srid, sdo_point_type(longitude, latitude, NULL),NULL, NULL);end;/--Create sample datacreate table xy (x number(38), y number(38), oid number(10));insert into xy values (1,1,1);insert into xy values (2,2,2);insert into xy values (3,3,3);insert into xy values (4,4,4);--Enter the geographic metadata infoinsert into user_sdo_geom_metadata values('XY','sde.get_long_lat_pt(x,y,4326)',sdo_dim_array( sdo_dim_element('Longitude', -180, 180, 0.005), sdo_dim_element('Latitude', -90, 90, 0.005)), 4326);--Create Function Based Index to work around ArcMap limitation of Spatial Index requirement create index xy_spidx on xy(get_long_lat_pt(x,y,4326)) indextype is mdsys.spatial_index; --Query Layer:select get_long_lat_pt(x,y,4326) as shape, oid from xy;

Steps to Reproduce

Bug ID: BUG-000096129

Software:

  • ArcGIS for Server

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic