topic Re: Relationship class is read only in ArcGIS Pro Questions

Relationship class is read only

MartinBertrand — Mon, 01 Aug 2022 12:40:37 GMT

I created a relationship class that is attributed and I can't edit it via Argis Desktop nor via sdk?

Re: Relationship class is read only

Aashis — Mon, 01 Aug 2022 13:32:13 GMT

Currently, there is no way to update the relationship class via the Pro SDK.

You should use Geo Processing tools to update relationship class' relationship rules, split policy, migration , etc.

I am curious to know what you are editing.

Re: Relationship class is read only

PierreMasson — Mon, 01 Aug 2022 14:18:15 GMT

I've created 2 simple stand alone tables. Clients & Orders.
Clients: ObjectId, Name, FirstName, Email
Orders: ObjectId, ClientId, OrderDate

Then I created an attributed Relationship Class between the 2. Like many client can have many orders.And added a IsShipped (short) field to it.

I add a client manually, then I do the same for the Orders table where I set the apporiate ClientId.

Now I want to manually add an entry in the relationship class, but it's read-only.

I don't understand why. We were doing this easily a few months ago and it was working great. Of course we were doing it programatically in a more complexe data model than that but we hit that problem and we are trying to isolate the problem. This is the smaller we came up with. Why can't we add relationship data? Why is it read only??

Please help

Re: Relationship class is read only

Aashis — Mon, 01 Aug 2022 14:18:55 GMT

What is the version of Pro and the geodatabase type, to see if we can reproduce the issue for investigation?

Re: Relationship class is read only

PierreMasson — Mon, 01 Aug 2022 14:20:20 GMT

ArcGIS Pro 2.9.2
Enterprise GeoDatabase on MS SQL.

Re: Relationship class is read only

Aashis — Mon, 01 Aug 2022 17:02:01 GMT

Moved to the Pro forum, not related to the Pro SDK.

Re: Relationship class is read only

BarryNorthey — Mon, 01 Aug 2022 17:34:40 GMT

You had to be using a Standard or Advanced license to create the relationship class but a reminder for those who might not know that relationship classes are read-only and cannot be edited when using a Basic license. While citing the version of AGP is important, the license level can sometimes be more important.

Re: Relationship class is read only

PierreMasson — Mon, 01 Aug 2022 17:40:26 GMT

Using Standard

Re: Relationship class is read only

PierreMasson — Mon, 01 Aug 2022 18:01:48 GMT

Just run this script (replace the 3rd line by your database sde file. Then add data in both tables and try to add a record in rel_Cars_CarColors. It's read only..

import arcpy import sys gdb = 'YOUR SDE PATH FILE HERE' arcpy.env.workspace = gdb resObj = arcpy.CreateTable_management(gdb, 'Cars') tbl = resObj.getOutput(0) arcpy.AddField_management('Cars', 'Make', 'TEXT', field_length=250, field_alias='Make', field_is_nullable='NON_NULLABLE', field_is_required='REQUIRED') arcpy.AddField_management('Cars', 'Model', 'TEXT', field_length=250, field_alias='Model', field_is_nullable='NON_NULLABLE', field_is_required='REQUIRED') arcpy.AddField_management('Cars', 'Year', 'LONG', field_alias='Year', field_is_nullable='NON_NULLABLE', field_is_required='REQUIRED') resObj = arcpy.CreateTable_management(gdb, 'CarColors') tbl = resObj.getOutput(0) arcpy.AddField_management('CarColors', 'ColorName', 'TEXT', field_length=250, field_alias='Color Name', field_is_nullable='NON_NULLABLE', field_is_required='REQUIRED') arcpy.AddField_management('CarColors', 'ColorCodesRGB', 'TEXT', field_length=6, field_alias='RGB', field_is_nullable='NON_NULLABLE', field_is_required='REQUIRED') arcpy.CreateRelationshipClass_management(origin_table='Cars', destination_table='CarColors', out_relationship_class='rel_Cars_CarColors', relationship_type='SIMPLE', forward_label='AvailableColors', backward_label='Cars', message_direction='Both', cardinality='MANY_TO_MANY', attributed='ATTRIBUTED', origin_primary_key='OBJECTID', origin_foreign_key='CarId', destination_primary_key='OBJECTID', destination_foreign_key='CarColorId') tbl = 'rel_Cars_CarColors' arcpy.AddField_management('rel_Cars_CarColors', 'Status', 'SHORT', field_is_nullable='NON_NULLABLE', field_is_required='REQUIRED')

Re: Relationship class is read only

PierreMasson — Fri, 09 Sep 2022 12:03:55 GMT

Nobody as a solution? I think it's a bug

Re: Relationship class is read only

PierreMasson — Mon, 29 May 2023 15:38:34 GMT

Relationship classes are still read only! Come on! Nobody has a solution to that simple problem and essential feature??