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

00223: Query layer has virtual column

  • Solution
  • More information

You attempted to publish a feature service to ArcGIS Server, but your layer contains one or more virtual columns.

Virtual columns (also known as computed or generated columns) contain values that are calculated when the query is executed and are not physically stored in a table in the database. For example, the column total_cost is a virtual column that adds the values from the fee and tax columns in the following expressions:

SELECT shape, (fee + tax)
 AS cost, OBJECTID
 FROM myuser.maintenance

Solution

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

  • Change the query definition of your layer so it no longer contains a virtual column or 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 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