ERROR

Unable to submit. Geodatabase data type mismatch

Last Published: January 20, 2023

Error Message

In ArcGIS Field Maps, submitting a form for a related table returns the following error message:

Error:
Unable to submit. Geodatabase data type mismatch.

ArcGIS Field Maps (Android)

Error message in ArcGIS Field Maps.

ArcGIS Field Maps (iOS)

Error message in ArcGIS Field Maps.

Cause

The data types of the Primary Key and Foreign Key fields do not match while creating the relationship class in ArcGIS Desktop.

Solution or Workaround

To resolve the issue, change the field data type of the feature layer to match the field data type of the stand-alone table.

  1. Open the ArcGIS Pro project.
  2. Delete the relationship class between the feature layer and the stand-alone table.
    1. In the Catalog pane, expand the Databases folder and expand the desired geodatabase.
    2. Right-click the relationship class, and click Delete.
Options under a relationship class in the Catalog pane of ArcGIS Pro.
  1. In the Delete window, click Yes.
  1. Add a new field to the feature layer with the desired field type, and use the Calculate Field tool to populate the values of the new field with values from the original field. Refer to How To: Change the data type of an existing field in ArcGIS Pro for further instructions.
Editing session of an attribute table in ArcGIS Pro.
  1. Create a new relationship class and use the newly created field as the Primary Key or Foreign Key. Refer to How To: Set up related tables in ArcGIS Pro for further instructions for ArcGIS Field Maps.
  2. Overwrite the web feature layer. Refer to ArcGIS Pro: Overwrite a web feature layer for further instructions.
  3. In ArcGIS Online, enable editing on the updated feature layer.
    1. Log in to ArcGIS Online.
    2. Click Content > My Content.
    3. Browse to the hosted feature layer, click More Options More Options icon. , and click View item details.
    4. Click the Settings tab.
    5. Under the Feature layer (hosted) section, check the Enable editing check box.
    6. Click Save.
  4. Add the hosted feature layer to the web map on ArcGIS Online.
    1. On the Content page, browse to the web map, click More Options More Options icon. , and select Open in Map Viewer.
    2. Remove the old version of the hosted feature layer in the web map. Refer to ArcGIS Online: Organize layers (Map Viewer) for further information.
    3. Add the updated feature layer to the web map. Refer to ArcGIS Online: Browse layers for further instructions.
    4. Save the web map. Refer to ArcGIS Online: Save maps (Map Viewer) for further instructions.
  5. Open ArcGIS Field Maps web app and log in using the same credentials used in ArcGIS Online.
  6. Configure the form for the recently saved web map. Refer to ArcGIS Field Maps: Configure the form for further instructions.
Note:
Configure the form under Tables, not Layers.
Form configuration page in the ArcGIS Field Maps website.

The images below show the forms successfully submitted in ArcGIS Field Maps.

ArcGIS Field Maps (Android)

Submitted message in ArcGIS Field Maps.

ArcGIS Field Maps (iOS)

Submitted message in ArcGIS Field Maps.

Article ID:000028998

Software:
  • ArcGIS Online
  • ArcGIS Pro 3 0
  • ArcGIS Pro 2 8 x
  • ArcGIS Field Maps Android
  • ArcGIS Field Maps iOS
  • ArcGIS Pro 2 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options