topic Re: Attribute Assistant : Duplicate ID's created using Generate_ID method in State & Local Government Questions

Attribute Assistant : Duplicate ID's created using Generate_ID method

SandraLuken — Mon, 24 Mar 2014 12:59:38 GMT

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

Re: Attribute Assistant : Duplicate ID's created using Generate_ID method

MikeMillerGIS — Mon, 31 Mar 2014 22:04:56 GMT

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.

Re: Attribute Assistant : Duplicate ID's created using Generate_ID method

SandraLuken — Tue, 01 Apr 2014 11:10:30 GMT

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

Re: Attribute Assistant : Duplicate ID's created using Generate_ID method

MikeMillerGIS — Tue, 01 Apr 2014 11:41:07 GMT

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?

Re: Attribute Assistant : Duplicate ID's created using Generate_ID method

SandraLuken — Fri, 11 Apr 2014 12:14:59 GMT

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