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

00162: Versioned standalone table does not have a versioned view

  • Solution
  • More information

The table you're 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 select 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 table that does not have a versioned view defined on it. This would most likely occur if your table 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

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