Map Layer Failed to Load (3047 duplicate field) - Inspection Workflows and Join Features layer

[BrennanSmith1]

I am following the instructions in ESRI's Inspection Workflows YouTube video series.  I am using ArcGIS Pro 2.9 and Enterprise Portal 10.9.  My 'Join Features' layer is functioning correctly in the webmap, but will not load in Field Maps, with the following error:

Map: Hydrant Inspections Webmap
Layer: Recent_Hydrant_Inspections
Domain: ARCGIS_RUNTIME
Code: 3047
Description: Geodatabase duplicate field not allowed.

The issue is that both the feature layer (Hydrants) and related table (Inspections) contain a GlobalID field. When I perform a Join Features (so we can symbolize on most recent inspection), the resulting layer contains two GlobalID fields named 'globalid' and 'globalid_1649266887779'.  I can't find any way to remove one of these fields or resolve the issue.

How is it possible to view a 'Join Features' layer in Field Maps? Why did it work in Eric's demo but not in my environment?

[AndreasB]

@BrennanSmith1 Did you already found a workaround for this issue? 

[BrennanSmith1]

Unfortunately no

[AndreasB]

Bump

[Kristofer]

Hi Brennan Smith,

I had also the similar issue but now with the below given tricks we can resolve this issue.

First, Remove the Global ID from the Layer & add a new field in this layer with different name (not Global ID) and specify the data type as GUID.

When you perform the analysis join features, resulting layer will be only one global id field.

Regards,

Sunita

[BrennanSmith1]

Update: I worked with ESRI and this is now a known bug with our Enterprise (BUG-000148852).  Hopefully they patch it soon.

Sunita, thanks for the advice, but unfortunately we can't remove or rename globalID fields.  And because of how we will use the data layers, we need 'Supports applyEdits with GlobalIDs' to be True.

[XV__]

Hi @BrennanSmith1 , interested if this has ever been resolved. Facing the same bug.

[BrennanSmith1]

Unfortunately, the bug has not been addressed yet.  Its status is listed as 'Under Consideration'.  My workaround has been to add a "recent inspection date" field to my feature class, and run a script every night that updates this value.  It is far from ideal, and doesn't instantaneously update the labels and symbology, but it's something...

[StaceyCurry1]

Bump, I'm having the same issue!