Error Message
In ArcGIS Survey123 Connect, attempts to publish surveys using feature classes with related tables and attachments fail, and return the following error message:
Error:
The custom feature service submission url is not compatible with this survey (Unsupported relationship type esriFieldTypeGlobalId in key field GLOBALID for table GLOBALID)
Cause
The following are possible causes:
- The GUID relationship fields include different names in the primary feature layer and secondary table.
Note:
The GUID field cannot be the GlobalID field.
- The label name for each side of the relationship is different.
Solution or Workaround
- In ArcGIS Pro, log in to the ArcGIS Online organization account.
- Add the feature class and table without relationship classes, global IDs, or attachments. Refer to ArcGIS Pro: Get started editing for more information.
- In the feature class, open the attribute table, and click the Add Field icon to add a new GUID field. In this example, the new GUID field is named GUID.
- Click Save.
- Repeat Steps 3 and 4 in the table with the same field name.
- On the top ribbon, click the Analysis tab and click Tools.
- In the Geoprocessing pane, search for and select the Create Relationship Class tool.
- In Parameters, select the preferred options for the Origin Table, Destination Table, Relationship Type and Message Direction sections.
- Select the One to many (1:M) option for Cardinality and the GUID fields for both the Origin Primary Key and Origin Foreign Key sections.
- Click Run.
- In the Catalog pane, right-click the feature class. Click Manage > Add Global IDs.
- Repeat Step 7 for the table.
- In the feature class, open the attribute table once more. Right-click the new GUID field, and click Calculate Field.
- In the Calculate Field pane, select the GlobalID field. Click Run.
- In the Catalog pane, right-click the feature class. Click Manage > Enable Attachments.
- Repeat Step 11 for the table.
- Publish the feature layer to ArcGIS Online. Refer to ArcGIS Pro: Share a web feature layer.
- In ArcGIS Survey123 Connect, create a new survey based on the published feature service in Step 13. Refer to ArcGIS Survey123: Generate a survey from a feature layer.
- Publish the survey.