Why is ArcGIS Pro using old data

[WillPlatt]

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.

[MichaelVolz]

What is the source for the problematic data?

Did you originally see these values that included the misspelled value in Pro and then made the change in the datasource but Pro is unable to show the edited values?

[WillPlatt]

The source is a versioned polygon layer in a Microsoft SQL database.  The version has been edited and reconciled and posted numerous times since that old data was there.  It has probably been a year since I last saw those old values in ArcMap (my primary software).

I did originally see these values in ArcGIS Pro. I tested Pro a little bit about a year ago but stayed with ArcMap for my primary software doing all of my editing with it.  I recently started testing Pro again since we recently upgraded our Microsoft SQL and ArcGis Servers. 

[MichaelVolz]

Are those values tied to domains?

[WillPlatt]

No, they are not.  It is just a Text field.

[MichaelVolz]

Did you create the aprx from an mxd by using the import mxd process?

Or did you create the aprx from scratch?  If so, are you using connection files that were created a year ago in your previous version of Pro that you were testing?  If you were using old connection files, I would create new connection files in Pro 2.2.0 and then see if the old values still show up.

[WillPlatt]

I just started a blank ArcGIS Pro document.  I add the database and then add the layer.  I am using the connections that I made to the new SQL database using ArcCatalog 10.2.1.  That connection is located in this folder C:\Users\XXXX\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog  correct?  The data is in a new database so the old connections that Pro had wouldn't work.

Thanks for the help, Michael, I really appreciate it.

[WillPlatt · Accepted solution]

OK, I figured it out!  I reconciled and posted the version of the database, then deleted the version.  When I tried to compress I got an error like "arcgis failed to compress the database error 08S01 microsoft sql server native client 11.0 tcp provider and existing connection was forcibly closed by the remote host".  I looked online and this happened to people who had upgraded to a different version of SQL server like we had done.  So the answer was to go into ArcToolbox>Data Management Tools>Geodatabase Administration>Rebuild Indexes.  However, when I tried with the DBO account the re-indexing failed.  I tried with another SQL account and it work.  I then was able to compress the database.  After the compression the data and symbology was fixed.

Hope this helps anyone else that runs into this problem.

Thanks

[MichaelVolz]

One question on your troubleshooting discovery.  Is the DBO account supposed to be able to rebuild indexes?  If this account has those privileges, then you might want to bring this item to ESRI's attention.

Can you see if the DBO account can rebuild indexes in ArcMap, so you can show ESRI that this functionality works in ArcMap but not in Pro (You have to test to determine if in fact this is the case as I don't know if the DBO account is supposed to have those privileges)?

[WillPlatt]

From what I understand about the SQL database, the DBO should be able to do anything to the database.  It is a database level account.  I am going to talk to my database admin and see why the DBO couldn't do it but a user level account could.  

I rebuilt the indexes through ArcToolbox from ArcCatalog so I would assume I would be able to do it in ArcMap as long as I chose the correct connection.

I have not attempted any kind of database administration in Pro.  I will look into how that is done and give it a try.

Thanks Michael