ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

00222: Query layer has duplicate field

  • Solution
  • More information

You attempted to publish a feature service to ArcGIS Server, but your layer contains duplicate columns.

It is possible to include a column multiple times in a query layer definition SQL statement; however, feature services require each column be referenced only once.

Solution

To publish a feature service to ArcGIS Server, do one of the following:

  • Change the query definition of your layer so that it no longer contains duplicate columns.
  • If the layer is not needed, remove it from your map.

More information

You create query layers in ArcMap by defining an SQL query. Also, ArcMap automatically creates a query layer containing a simple SQL query whenever you add a table from a database to the map. The query runs against tables in your database and the result set is added to ArcMap as a layer.

You primarily publish feature services from your map so that you can deploy the feature service in client applications for others to edit the data. Feature services can only edit the data if the SQL queries used for the layers in the map are simple and contain no joins, where clauses, duplicate columns, or virtual (computed) columns.

Learn more about authoring a feature service

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal