Hello everyone,
I'm experiencing an unusual issue with an Enterprise Geodatabase hosted on SQL Server. Specifically, I'm unable to delete a feature class within a dataset from ArcGIS Pro. When I attempt to delete the feature class, the process appears to complete successfully without any errors. However, after refreshing the feature dataset, the feature class still appears intact. Furthermore, I can add it back to the map without encountering any issues, and the data remains unaffected.
Some other information
Environment information
Has anyone else encountered this problem or have any suggestions on how to resolve it?
Thank you!
Solved! Go to Solution.
Thanks for the update on your testing. I am not aware of any specific permission required between SQL / Windows logins.
We usually do not recommend that Windows logins own data due to naming and when the person leaves. This is the first time I have come across this difference.
I've almost figured out what is happening with the issue. I created a new SQL user named 'gisadmin' and mapped it to the existing Windows login 'domain\gisadmin'. After doing this, I was able to successfully create and delete a feature class inside a feature dataset without any problems. It seems that the issue was related to the naming convention of the domain\username causing conflicts. This mapping resolved the problem.
Thank you for your assistance.
Thanks for that update. We usually want the username / login name to match exactly for best outcomes and less issues.
@George_ThompsonIf you have a time and found that suitable for you could you try to reproduce the issue using a windows login that equal the sql user name? just to report this to Esri.
I do appreciate your help and time.
Thanks
This is where I recommend working with technical support on this. They have the mechanism to reproduce the issue and the process for logging potential issues.
@MarlonAmaya any thoughts on getting this investigated?
Thank you for your recommendation. Unfortunately, our client is currently out of the service contract, so we are unable to reach out to technical support.
Roger, I am not sure how to report an issue outside of support.
Yes, the data owner account is OS (windows) user
I created a sample feature dataset that is owned by OS user , created FC, deleted FC - FC is deleted successfully.
Marlon