Duplicate GlobalID renders deleting/removing feature impossible - Delete selected features failed.

1200
4
Jump to solution
08-07-2022 07:15 PM
EC1
by
New Contributor III

I have two features that have the same Global ID. When I try to remove/delete one of the pair I get this error:

EC1_0-1659924747199.png


This is not the first time this has happened.
Currently the only way to fix this is to connect to the database via sql manager and generate new global IDs for the duplicated features. 

 

Is there a way to get around this/delete the duplicated feature with duplicate GID via ArcPro without the use of sql management studio? 

0 Kudos
1 Solution

Accepted Solutions
EC1
by
New Contributor III

Managed to fix this via SQL Management Studio. There is no way to fix this via arcPro as far as I can tell. 

Solution using SQL Management studio:
-Find the table which has duplicate GIDs

-Identify the duplicate GIDs and record them.

-use a command similar to this. 

UPDATE [egdb name].[unm].[WATERJUNCTION] SET GLOBALID=NEWID()

WHERE GLOBALID = '(your GID(s) here)'

 

Lastly you'll have to delete the duplicated items manually in ArcPro. 

View solution in original post

0 Kudos
4 Replies
RobertKrisher
Esri Regular Contributor

If you experience and continue to experience this issue, please log a case with support. The application should not be able to create features with duplicate global ids.

0 Kudos
LindseyStone
Occasional Contributor III

@EC1 Did you ever get any resolution on this?  I have the same problem and have a support case open for over 3 weeks now and still no resolution.

0 Kudos
EC1
by
New Contributor III

Managed to fix this via SQL Management Studio. There is no way to fix this via arcPro as far as I can tell. 

Solution using SQL Management studio:
-Find the table which has duplicate GIDs

-Identify the duplicate GIDs and record them.

-use a command similar to this. 

UPDATE [egdb name].[unm].[WATERJUNCTION] SET GLOBALID=NEWID()

WHERE GLOBALID = '(your GID(s) here)'

 

Lastly you'll have to delete the duplicated items manually in ArcPro. 

0 Kudos
LindseyStone
Occasional Contributor III

Thanks @EC1 , that did the trick!!!