laptop and a wrench

Bug

The Export Data operation fails when the hosted feature service is published from a shapefile with a definition query applied.

Last Published: September 25, 2017 Portal for ArcGIS
Bug ID Number BUG-000105159
SubmittedMay 15, 2017
Last ModifiedJune 5, 2024
Applies toPortal for ArcGIS
Version found10.5
Operating SystemWindows OS
Operating System Version10.0
StatusKnown Limit

Additional Information

ArcMap's Query Builder quotes the fields for shapefiles. The created service ends up having the quotes in its definition query causing this problem. This is a known limit. Please refer to the workaround.

Workaround

1. Remove the definition queries from the layers before publishing. The filters can be applied later in the Portal for ArcGIS web map to get the same effect as definition queries.2. Export the shapefile to a file geodatabase, and then publish the service. Definition queries remain this way. Data from published service can be exported without any problem.3. Publish from ArcGIS Pro instead of ArcMap. ArcGIS Pro's query builder does not quote any fields (shapefiles, and data from FGDB's and EGDB's)

Steps to Reproduce

Bug ID: BUG-000105159

Software:

  • Portal for ArcGIS

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options