24040: Layer has an in-memory join or relate
Your map layer has an associated join or relate that was created in the map document using the layer properties dialog box. Joined and related attributes will not be accessible through the feature service.
Solution
If your layer has a join:
- Create a view. A view is a stored query that selects data from specified tables.
Learn more about views and creating a database view in ArcGIS for Desktop
- Or, you could export your layer with the join to a new feature class and use this new feature class in the map you want to publish.
- Right-click the layer in the table of contents.
- Click Data > Export Data.
- You can remove the joins from your layer.
- Open the Layer Properties dialog box.
- Click the Joins & Relates tab.
- Click Remove.
- Do nothing. The joined attributes will not be available through the feature service.
If your layer has a relate:
- Make sure both the table and the layer involved in the relationship class are in the data frame.
- You can remove the relate from your layer.
- Open the Layer Properties dialog box.
- Click the Joins & Relates tab.
- Click Remove.
- Do nothing. The related attributes will not be available through the feature service.
More information
Feature services allow queries on related data. For example, a published map document can have layers and tables that are related through geodatabase relationship classes. In this case, the feature service allows queries on a layer to return objects from the related layer or table. Note that to support queries that return related objects, both the table and the layer involved in the relationship class must be in the published map document. If either the origin and/or destination layer or table is not included in the map document, the relationship is ignored by the feature service.