When I try to change the symbology for a polygon layer, ArcGIS Pro 2.2.0 is using old values that don't exist anymore and ignoring new values. In the attached screen show, when I add all the Values for the field called "Type" it is symbolizing values like "Overhead Fiber" and "Road" and the misspelled "Tranmsission". These values no longer exist in the data. Also, in the data there are values "Access" and "Commitment" that ArcGIS Pro does show as a value. It seems like ArcGIS Pro is using using some old cached version of the data. I have tried deleting all the cache files in C:\Users\XXXXX\AppData\Local\ESRI\Local Caches. That didn't work. I'm stuck. It works perfectly fine in ArcMap.
Thanks for any help you can give.
Solved! Go to Solution.
Hi Will,
Esri's best practices for geodatabase administration are to have the SDE user (or the user that your organization has dubbed the Geodatabase Administrator user) perform these tasks. This is assuming that your geodatabase is an SDE schema geodatabase. Is that the case here?
If you are working with a DBO schema geodatabase, then you can use a database user that is a member of the DBO schema to perform these tasks. That being said, a database user that is a member of the DBO schema, even in an SDE geodatabase, has the privileges to administer the geodatabase should you choose to do that.
Here is a look at Geodatabase owners in SQL Server and the Pros and Cons: A comparison of geodatabase owners in SQL Server—Help | ArcGIS Desktop
We will always recommend that you guys use the least privileges principle when working with the geodatabase. At the top is the Database Administrator user (the SA user or member of the sysadmin fixed server role in SQL Server). They can do everything but really should be limited to 1 or 2 people in your organization and not used for geodatabase administration tasks. Then there is the Geodatabase Administrator user (the SDE user) which handles all the admin tasks such as what you are doing here. Then Data Owner roles which can create and own new data. Then Data Editor roles which can edit existing data. The Data Viewer roles which can only view data.
Hope that helps a little. Let me know if I can clarify anything.
Jonathan