topic Error with Incrementing ID Field and Clarification of Usage in ArcGIS Pro Questions

Error with Incrementing ID Field and Clarification of Usage

PeterKing — Mon, 10 Sep 2018 17:32:44 GMT

I am trying to add an Incrementing ID Field to a feature class using ArcGIS Pro 2.2.0 using the following tool - Add Incrementing ID Field

The summary of the tool states that:

"The Add Incrementing ID Field tool adds a database-maintained ID field to an existing table or feature class..."

The Usage Description of the tool states: "This tool can only be used with database tables, not geodatabase tables."

We are trying to add the field to and Enterprise SDE Feature Class as described in the summary but are now receiving the following error:

ERROR 000152 You cannot add an incrementing ID field to a table registered with the geodatabase.

1. Has anyone out there had experience and success using the tool ?

2. Our feature classes are enterprise FC's not tables so is the summary of the tool incorrect?

Thanks for any help and clarification in what I may be doing wrong or missing!

Re: Error with Incrementing ID Field and Clarification of Usage

George_Thompson — Mon, 10 Sep 2018 19:10:58 GMT

Hi Peter - That tool cannot be used with a feature class that is registered with the enterprise geodatabase already.

This tool can only be used with database tables, not geodatabase tables.

try it on an unregistered spatial/non-spatial table.

Re: Error with Incrementing ID Field and Clarification of Usage

PeterKing — Mon, 10 Sep 2018 19:32:07 GMT

Thanks George.

I think that there is a disconnect between the summary of the tool and usage statement.

Regardless, our issue is that we want to use the tool on a FC that exists in SDE and is registered with the DB. The FC is a utility asset and we would like this functionality within the Enterprise.

Any ideas of other tools for incrementing ID's when features are added?

I currently use DB triggers to increment ID's so I was hoping for something else, like this tool.

Regards

Re: Error with Incrementing ID Field and Clarification of Usage

George_Thompson — Mon, 10 Sep 2018 19:38:11 GMT

Sorry for the confusion on the tool documentation. I would recommend providing feedback which is linked at the bottom of the help doc.

As for something else, I think that you are doing it the best way with a DB trigger. Is this being done within the Utility Network?

Re: Error with Incrementing ID Field and Clarification of Usage

PeterKing — Mon, 10 Sep 2018 19:44:10 GMT

Thanks again! As for the utility network we are in the process of migrating to it but the feature in question is not currently in the Utility Network.

Cheers