00226: In-memory joins and relates are not supported

Your layer has an associated join or relate that was created in the map. Publishing web feature layers with in-memory joined and related attributes is not supported.

Solution

Use the following solutions:

• If your layer and joined or related data are in the same geodatabase, create a relationship class between the datasets instead of using an in-memory join or relate. For more information about relationship classes, see An overview of the Relationship Classes toolset.
• If your layer has a join, you can do one of the following:
  • Use the Create Database View tool to create a view. A view is a stored query that selects data from specified tables.
  • Export your layer with the join to a new feature class and use this new feature class in the map.
    1. Select the layer in the Contents pane.
    2. Click the Data tab.
    3. Click the Export Features button in the Export group.
  • Remove the joins from your layer.
    1. Select the layer or table in the Contents pane.
    2. Click the Data tab.
    3. Click the Joins menu in the Relationship group.
    4. Click Remove Join.

• If your layer has a relate, you can do the following:

  • Remove the relate from your layer.
    1. Select the layer in the Contents pane.
    2. Click the Data tab.
    3. Click the Relates menu in the Relationship group.
    4. Click Remove Relate.

Additional information

For more information, see Analyze your GIS resource.