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...

00161: Versioned feature layer does not have a versioned view

  • Solution
  • More information

The layer you are attempting to publish is registered as versioned, but the data is not accessed through a versioned view.

Solution

Right-click the feature class in ArcCatalog and click Manage > Enable SQL Access.

Learn more about Enabling SQL access from ArcGIS Desktop

More information

This problem occurs if the map you are publishing contains a versioned feature class that does not have a versioned view defined on it. This would most likely occur if your feature class was registered as versioned using an ArcGIS 10 or earlier release client.

Data in versioned tables cannot be directly accessed by Standard Query Language (SQL) because it does not access the delta tables. If you publish a versioned class, it will query the base table and never see the correct edits, which reside in the delta tables.

Versioned views incorporate database views, stored procedures, triggers, and functions to allow you to read or edit versioned data in a geodatabase table or feature class using SQL. When you query a versioned view, you can see the data in the base (business) table and the edits that are stored in the delta tables.

Learn more about versioned views

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