BUG-000096129 for ArcGIS for Server

Bug-ID-Nummer	BUG-000096129
Eingereicht	April 27, 2016
Zuletzt geändert	July 20, 2022
Gilt für	ArcGIS for Server
Gefunden in Version	10.4
Server-Plattform	Windows OS
Client-Plattform	2008 R2
Version Fixed	10.5.0
Status	Fixed

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;

Schritte zur Reproduzierung

Bug-ID: BUG-000096129

Software:

ArcGIS for Server

Hilfe von ArcGIS-Expert*innen erhalten

Technischen Support kontaktieren

Die Esri Support-App herunterladen

Zu den Download-Optionen

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."

Workaround

Schritte zur Reproduzierung

Weitere Informationen zu diesem Thema erkunden