topic Attribute Assistant and Versioning in State & Local Government Questions

Attribute Assistant and Versioning

deleted-user-sxViYNIAAUFF — Mon, 21 May 2012 13:00:13 GMT

Is there an issue with the attribute assistant and versioning?
It appears that the attribuite assistant only works when I do not edit a version.
I must be directly editing the SDE tables.

Re: Attribute Assistant and Versioning

MikeMillerGIS — Thu, 24 May 2012 10:20:56 GMT

The Attribute Assistant does work in a versioning environment. The only layer/table that cannot be versioned is the GenerateID table. What errors are you experiencing? What is not working? Have you enabled the debug log file and review it for configuration issues? Have you logged a tech support call?

Re: Attribute Assistant and Versioning

deleted-user-sxViYNIAAUFF — Thu, 24 May 2012 15:09:11 GMT

How does the Generateid table get updated if it is not versioned? I am editing a versioned database, but the generateid table is not part of the versioned database.

ERROR: GENERATE_ID: Objects in this class cannot be updated outside an edit session [sde.SDE.GenerateId]

Re: Attribute Assistant and Versioning

MikeMillerGIS — Tue, 05 Jun 2012 12:33:30 GMT

Rodney,
Internally, the code is making an unversioned edit. If the table is versioned, you will get duplicate IDs.

Re: Attribute Assistant and Versioning

JustinStangl — Thu, 30 Aug 2012 17:13:14 GMT

Mike,
We have our Attribute Assistant Add-in functioning properly within our MXD (Dynamic.gdb). However, in our versioned environment workflow, the Autonumber / Generate ID functions will end up posting duplicate ID's to our SDE feature class tables. Multiple editors throughout our version tree will create new featues in their versions (from the same feature class in different areas of the map document). When i reconcile and post these versions, the ID's created from 'editor A' are the exact same as the ID's created from 'editor B' for that particular feature, as they are are set to auto-number based on the last number in sequence.

We like the attribute assistant, but the ID fields are linked to our mobile software and we cannot have duplicate ID's.
Is there a way to set the starting points for each editors Dynamic.gdb (10000, 20000, 30000, and so on) so each editor will have enough unique ID's ???

Thanks,
-JS

Re: Attribute Assistant and Versioning

MikeMillerGIS — Thu, 30 Aug 2012 17:29:36 GMT

You need to not version the Generate ID table. If the table is versioned you will get dup ids.

Re: Attribute Assistant and Versioning

JustinStangl — Thu, 11 Oct 2012 17:54:35 GMT

Mike, thanks for the input. Actually our GenerateID tables are not versioned, each editor has their own seperate Dynamic/GenerateID tables linked in their MXD with different 'sequence' values in each table (1, 7, 10, 11), in order to reduce the number of duplicate ID's generated.
However the sequence counter is not taking these numbers into account, its just going with the next number in sequence (1,2,3) instead of (7,14,21). How can i get it to use the sequence numbers from the GenerateID table when generating ID's??

Re: Attribute Assistant and Versioning

MikeMillerGIS — Thu, 11 Oct 2012 18:49:18 GMT

This rule always grabs the last ID and increments it by 1. What you are trying to do is not supported.

Re: Attribute Assistant and Versioning

JustinStangl — Fri, 12 Oct 2012 13:08:29 GMT

OK that makes sense, thanks for help!

Re: Attribute Assistant and Versioning

TiffanyPuett — Mon, 13 Mar 2017 18:21:29 GMT

Can you elaborate a little more on this? I get that the GenID table should not be versioned. However, in a versioned environment, how does this avoid dup ID's? Should all users editing featureclass be working in the same version so that they get an implicit reconcile and thus update that last increment? Or will this work if all users have their own/separate version?

I hate to assume.

Re: Attribute Assistant and Versioning

MikeMillerGIS — Mon, 13 Mar 2017 18:46:54 GMT

The attribute assistant code makes an unversioned edit to the table.

Re: Attribute Assistant and Versioning

TiffanyPuett — Thu, 20 Apr 2017 13:26:45 GMT

...that doesn't really answer my question. Can someone else perhaps answer my question? I'm trying to understand so that I may trouble-shoot an issue.

Re: Attribute Assistant and Versioning

JustinConnerWR — Thu, 03 Aug 2017 17:50:38 GMT

This is supported as of November 2012 per Configure GenerateID table - Attribute Assistant | ArcGIS Solutions