ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for 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
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

00222: Query layer has duplicate field

  • Solution
  • More information

You attempted to publish a feature service to ArcGIS for 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 for 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

Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal