topic Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool in Python Questions

Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

NathanHeick — Fri, 25 May 2012 22:54:07 GMT

I am trying to create relationship classes using the geoprocessing tool Create Relationship Class in Python and in ArcCatalog. I am using an origin primary key that is a GLOBALID and an origin foreign key that is GUID. The error I receive in Python is:

Failed to execute. Parameters are not valid.
ERROR 000800: The value is not a member of GLOBALID.
Failed to execute (CreateRelationshipClass).

In ArcCatalog, when accessing the GP tool from ArcToolbox, once I select the origina primary key as a GLOBALID, it will only let me choose from the GLOBALID in the destination table as valid foreign keys.

To me, it seems like the GP tool is too restrictive and only lets you make relationship classes between GLOBALIDs and GLOBALIDs, not GLOBALIDs and GUIDs.

If I choose New -> Relationship Class in ArcCatalog, it allows me to choose from the GLOBALID field and the GUID field in the destination table. It allows relationships between GLOBALIDs and GUIDs.

Does anyone have a workaround for this or an explanation? I have to drop and recreate 180 relationship classes in an automated fashion and I would prefer to use Python.

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

NathanHeick — Mon, 02 Jul 2012 15:52:46 GMT

I followed up with Esri Technical Support on this issue. They reported it as a bug and said that it won't be corrected until a later release of ArcGIS 10.1.

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

IB1 — Wed, 07 Nov 2012 11:32:15 GMT

Any word on this ESRI?

Can't this be an easy fix?

I really need this to work with Python.

I'm using 10.0 and am having the same issue.

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

IB1 — Wed, 07 Nov 2012 17:37:52 GMT

Bump it up

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

IB1 — Thu, 08 Nov 2012 11:25:42 GMT

Bump it up

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

IB1 — Fri, 09 Nov 2012 14:46:46 GMT

Bump, bump ... bump it up.

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

IB1 — Mon, 12 Nov 2012 18:56:45 GMT

Bump, bump ... bump it up.

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

JakeSkinner — Mon, 12 Nov 2012 19:03:10 GMT

The bug that was logged for this is NIM082537. You can follow the status of it here.

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

IB1 — Mon, 12 Nov 2012 19:35:46 GMT

The bug that was logged for this is NIM082537. You can follow the status of it here.

Thanks! You the man. I'll shut up now.

Hopefully it gets fixed soon.

BTW- the Version found should be 10.0 and 10.1, not just 10.1

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

NathanHeick — Sun, 18 Nov 2012 22:32:34 GMT

I can confirm that as well. It still does not work.

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

IB1 — Mon, 19 Nov 2012 01:07:33 GMT

I can confirm that as well. It still does not work.

Did you ever find a workaround for it? Or did you have to create all 180 of them manually?

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

NathanHeick — Tue, 08 Jan 2013 15:47:38 GMT

The only solution I see is learning ArcObjects or waiting for Esri to fix the bug. Out of the 180, I have 19 relationship classes that use GUIDs that I have to create manually on a regular basis. It also keeps our ETL process from being fully automated.

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

MarkReidy — Wed, 30 Jan 2013 20:33:37 GMT

Still no work around?

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

JoeJung — Wed, 17 Dec 2014 22:10:34 GMT

Almost 2.5 years and this has not been fixed.

Has anyone figured out how to work around this?

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

KenSam — Mon, 23 Mar 2015 21:11:11 GMT

This issue is still not addressed in 10.3. That's after close to 3 years when this msg was posted. Bump up doesn't seem to work. Need a megaphone!

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

JoeJung — Thu, 23 Apr 2015 14:01:56 GMT

I can't seem to "follow the status" of the bug any more, I just get stuck in an endless loop of signing in to my esri global account.

Seriously, this needs to be addressed. Every month I come across a situation where this would save me a tremendous amount of time.

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

KyleMattison — Thu, 07 May 2015 18:56:30 GMT

I had to search the number manually to actually find it. You can see the status here: NIM082537

It actually looks like there is an even older bug report about the same issue for ArcGIS 10.0: NIM072002

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

BillDaigle — Tue, 09 Feb 2016 18:14:43 GMT

Seriously, there is still no fix for this???

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

JoeBorgione — Tue, 09 Feb 2016 18:55:08 GMT

The only thing I use Global IDs for is database replication. For relationships, I use a field called... (wait for it) JoinItem or something along those lines. Make a Long Int and calc it to equal the feature's OID. That way if you move data to a different db the joinitem remains static and unique.

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

BillDaigle — Tue, 09 Feb 2016 19:19:46 GMT

I thought about that too. But I’m trying to set up a cross-platform (ArcMap and Web) editing work flow. I don’t want the users to maintain the key fields.