Attribute Assistant : Duplicate ID's created using Generate_ID method

3082
4
03-24-2014 05:59 AM
Labels (1)
SandraLuken
Occasional Contributor
We have been able to successfully reproduce two editors working in the same sde geodatabase creating new features with the same ID as generated by Attribute Assistant and the GENERATE_ID method. This has been confirmed looking through the log files from the individual PC's.

The DynamicValue and GenerateID tables are not registered as versioned and actually the DynamicValue table is not editable by the editors, only the GenerateID table. The editors are editing against default and not using their own explicit versions.

ArcGIS 10.1 SP1 (build 3143)
SDE 10.0 SP5
Oracle 10g

Sandra
0 Kudos
4 Replies
MikeMillerGIS
Esri Frequent Contributor
Sandra,
   Can you add the table to ArcMap, uncheck the option to perform a versioned edit and see if you can edit that table manually using one of the editors logins?  The tools perform an unversioned edit to the table to increment the IDs.
0 Kudos
SandraLuken
Occasional Contributor
Hi Mike,

The GenerateID table is not registered as versioned, so yes I can perform an unversioned edit on this table as an editor.

Sandra
0 Kudos
MikeMillerGIS
Esri Frequent Contributor
When the editors perform an edit, does the sequence in the Generate ID increment? If the other editor refreshes the table, does the new value show up?  Is there any messaging in the Attribute Assistant logs?
0 Kudos
SandraLuken
Occasional Contributor
For anyone following this forum thread, two NIM's have been submitted regarding the creation of duplicate ID's during multiple simultaneous editing using either GENERATE_ID or GENERATE_ID_BY_INTERSECT with data and configuration tables stored in Oracle.

NIM100667 and NIM100535
0 Kudos