nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Join Features tool fails when joining related table with the main table

StephenKaranja

We have a feature layer for a Survey123 form that has a repeat. The feature layer has a main layer and a related table. We are trying to use the Join Features tool to perform a join on the main layer and the related table based on the uniquerowid field of the main layer and the parentrowid field of the related table. The tool fails with the message "JoinFeatures failed".

The ArcGIS Server Manager log shows the following message at SEVERE level:

Error executing tool. JoinFeatures Job ID: jfa8877272837406a809572136a7bcb54 : {"messageCode": "AO_100215", "message": "JoinFeatures failed."} Failed to execute (JoinFeatures).

The job's messages.xml at F:\arcgisserver\directories\arcgisjobs\system\spatialanalysistools_gpserver\jfa8877272837406a809572136a7bcb54\scratch\messages.xml contains the following error messages:

[100, 2557, 'ERROR 002557: Cannot delete field globalid from F:\\arcgisserver\\directories\\arcgisjobs\\system\\spatialanalysistools_gpserver\\jfa8877272837406a809572136a7bcb54\\scratch\\scratch.gdb\\targetLayer.']
[100, -2147467259, 'Failed to execute (DeleteField).']

I have also attached the messages.xml file.

We'd appreciate any suggestions on how to get the join features tool to work
successfully.

messages.xml.txt

Encuentra más publicaciones etiquetadas con

Accepted answers

Elizabeth_LorenaRodriguez

Hello @StephenKaranja

I think the error could be related with attachments enabled. Could you make a copy of the layer, disable the attachments, and try to make again the test ?

Best regards

Lorena

All comments

StephenKaranja

Thanks for the suggestion.

I've made a copy of the layer but it doesn't have the option to disable attachments (see attached screenshot). The Join Features tool still fails. (I made the copy by opening the layer in map viewer, copying it, and then saving the copy.)

Capture.PNG

Elizabeth_LorenaRodriguez

Hello @StephenKaranja

I think the error could be related with attachments enabled. Could you make a copy of the layer, disable the attachments, and try to make again the test ?

Best regards

Lorena

StephenKaranja

Thanks Lorena.

We are running Portal version 10.8.1. The main layer has attachments enabled.

Does the error mean there is no way to perform a join between the main layer and related table?

Elizabeth_LorenaRodriguez

Hello @StephenKaranja

I think this is related to the error: https://support.esri.com/en/technical-article/000010132

"If the index is managed by the Geodatabase, such as an index on the ObjectID field or an index added because of a relationship class, it cannot be deleted."

Are you working on ArcGIS Online or Portal? If Portal, what version?

Also, does the layer has attachments enable?

Best regards

Lorena

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Iniciar Sesión
Registrarse

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.