Skip To Content

00222: Query layer has duplicate field

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.


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

In this topic
  1. Solution
  2. More information