00294: Editable feature services cannot contain database views. <value> is a database view

The editable feature layer you attempted to publish includes a database view. Views are often used to join two or more tables together and cannot be edited in ArcGIS software; therefore, you cannot enable editing on a feature layer that contains a view if the feature layer references a registered database.

Tip:

Database views include views that are registered with the geodatabase as well as those that are not.

Solution

How you proceed depends on what you need to accomplish. Use one of the following suggestions to publish the data you need in a web layer or layers:

• If you need to edit other data in the map and only need the data from the view as a reference, you can do the following:
  1. Remove the view from the map and publish the other data to an editable feature layer.
  2. Create a separate map that contains the view, and publish a map image layer or read-only feature layer.
  This makes the same data available through web layers while allowing you to edit the data that supports editing.
• If your registered data store is an enterprise geodatabase and you are using the view to present joined tables that you need to edit, you can do the following:
  1. Remove the view from the map.
  2. Create a relationship class between the tables you were joining together using the view.
  3. Add the tables that participate in the relationship class to the map.
  4. Publish an editable feature layer.
• If you don't need to edit any of the data in the map (for example, you didn't change the default feature layer properties before attempting to publish even though you don't need to edit), disable editing in the Feature Properties pane and publish a read-only feature layer.