search

Esri / local-government-desktop-addins

A series of ArcGIS Desktop Add-ins used in the ArcGIS for Local Government editing maps.
Apache License 2.0
61 stars 57 forks source link

BUG-000109908 When working in a Multi-editor environment with enterprise databases, Attribute Assistant can occasionally produce duplicate unique IDs. #270

Closed MikeMillerGIS closed 5 years ago

MikeMillerGIS commented 6 years ago
Salesforce ID: BUG-000109908
Salesforce Submitter: Andy Shoemaker
Salesforce Submit Date: 12/01/2017 8:22 AM
Salesforce Bug Type: Usability
Salesforce Severity: Medium
Repro Data: (n/a)
Work Around: Only have one editor load large amounts of data into a feature class at a time.
Product: ArcGIS for Desktop
Functional Category: ArcGIS for Local Government
Client Platform: (n/a)
Version Found: 10.2.1
Planned Version Fixed: (n/a)
Comment: (n/a)
MikeMillerGIS commented 6 years ago

We have narrowed this down to concurrent processes all calling the same sequence with in a small window(microsecond). We have added code to enhance the performance to narrow this gap. There is still very small chance for this to occur.

MikeMillerGIS commented 6 years ago

To ensure that a unquie ID is generated, we added support for calling a stored procedure. A new configuration tag to the AA config file to specify the name of the Storeprocedure.

MikeMillerGIS commented 6 years ago

First version of Store Proc code here - https://github.com/Esri/local-government-desktop-addins/commit/eaa8b0f0f811da744744a96d20ec48173cd7bfaf

MikeMillerGIS commented 6 years ago

Linking to and closing - https://github.com/Esri/local-government-desktop-addins/issues/268

MikeMillerGIS commented 6 years ago

related to stored proc issue, beta capability, not fully vetted