I have been using the copy-paste function of the smart editor widget to copy points from a shapefile into a point layer that is in a geodatabase. The web map that I created for this is in ArcGIS Online. Our database is an sql database 10.5.1. In the past I could select several points at a time and I could paste them in the geodatabase point layer with the help of smart editor but this is no longer possible. When I now try to copy-paste several points at a time I get the following message: “Cannot copy multiple features using the same value for unique value fields, please select only one feature”
I don’t quite understand what the message says. I tried with several other layers with the same result. Then I thought that it might has to do with my database version (10.5.1). I tried with another database that is in 10.7.1 with also the same result.
We have been struggling to get people to use web maps to do simple editing and when we just managed to achieve this, this happens. I would appreciate every help I can get on this one.
Hi @MariaAndreoudi ,
Thank you for posting your question.
Currently, if the target feature template (the one into which you are attempting to copy features) has any fields that only allow for user-defined unique values (this excludes ObjectID and GlobalID which are system generated), then you will only be able to copy one feature at the time.
This is meant to prevent writing the same value for all your new target features into the field that only allows for unique values, and so prevent data errors and inconsistencies.
If you need to copy multiple features rather than one at the time, the workaround would be to remove the "unique" restrictions for that field in your geodatabase.
The only unique constraint I have is the ObjectID but you previously said that this would not affect the copy paste function of multiple features.
When I host the layer in ArcGIS online it works but it won’t work when the layer is in the geodatabse.
As I mentioned before this used to work for us. We were able to copy paste several features from a shapefile to the geodatabase layer with no problems.
Hi @MariaAndreoudi , we believe we have found the source of the issue and it is tied to the SHAPE index having isUnique set to true for some services. This should be resolved in the next ArcGIS Online update.
Is there a timescale for when this will be fixed in ArcGIS Enterprise? I seem to be experiencing the same issue when trying to copy features into a hosted feature layer that has no fields with unique constraints published from Pro 2.9.1 to Enterprise 10.9.1.