topic Re: Enterprise GDB features repeat symbology in ArcGIS Pro Questions

Enterprise GDB features repeat symbology

JoeBorgione — Tue, 20 Jul 2021 15:42:30 GMT

Some time back I created a project where I assigned a specific Unique Values symbology scheme to a feature class in our enterprise gdb (aka SDE). Now when ever I add that feature class to a new project, I get that symbology. It seems to be a property at the EGDB level as a coworker confirmed when he adds the feature class he gets the same symbology.

What causes this and how do I suppress it?

Edited moments later: I added the same feature class to a new project and changed the Unique Values symbology. But when I now create a new project, that new symbology does not show up, the other one does...

(My apologies if this is a repeat post: I thought I asked about this already but could not find any mention.)

Re: Enterprise GDB features repeat symbology

DavidPike — Tue, 20 Jul 2021 15:46:35 GMT

sounds funky. would be interested to know also.

Re: Enterprise GDB features repeat symbology

JoeBorgione — Tue, 20 Jul 2021 16:59:35 GMT

Yep. Funky indeed. I went through 3 tech support analysts at ESRI; the last one is as stymied as the first two...

Re: Enterprise GDB features repeat symbology

Asrujit_SenGupta — Tue, 20 Jul 2021 19:24:25 GMT

By any chance, did you use Representations?

What are representations?

Re: Enterprise GDB features repeat symbology

JoeBorgione — Tue, 20 Jul 2021 19:39:53 GMT

@Asrujit_SenGupta I've never used them in my life; not knowingly anyway. It's so weird: I can export the feature class to a fgb and the symbology comes with it.

Edited to add: The arcgis pro help page on representations suggests that they are an ArcMap thing. I haven't used ArcMap in 2 years....

Re: Enterprise GDB features repeat symbology

Asrujit_SenGupta — Tue, 20 Jul 2021 19:41:47 GMT

Would suggest checking the Properties of that Feature class to make sure. Just in case...

Re: Enterprise GDB features repeat symbology

JoeBorgione — Tue, 20 Jul 2021 19:46:07 GMT

@Asrujit_SenGupta - I don't see anything in the properties that points to symbology, and I don't see anything in the Symbology menu as suggested in the the Pro Help page I linked above.

Re: Enterprise GDB features repeat symbology

DavidPike — Thu, 05 Aug 2021 11:21:10 GMT

did you get to the bottom of this @JoeBorgione ?

Re: Enterprise GDB features repeat symbology

JoeBorgione — Thu, 05 Aug 2021 11:26:47 GMT

@DavidPike Not yet. I took some time off to walk along a beautiful river with fly rod in hand so the case was on pause.

Just yesterday though I sent some sample data to ESRI tech support. Haven’t heard anything so far but I’ll keep this updated.

Re: Enterprise GDB features repeat symbology

KeithOlson — Thu, 05 Aug 2021 19:24:05 GMT

My work group is experiencing the same thing. One person sets symbology and makes edits to the feature class. Then a second person adds that feature class to a totally different project and the symbology comes right along with it!!!

I have a separate thread going on now. We should merge the two maybe.

https://community.esri.com/t5/arcgis-pro-questions/automatically-created-representations/m-p/1086249#M44093

Re: Enterprise GDB features repeat symbology

JoeBorgione — Thu, 05 Aug 2021 19:27:17 GMT

I'll forward this thread to the tech support analyst working on my case.

Re: Enterprise GDB features repeat symbology

JoeBorgione — Tue, 10 Aug 2021 16:00:10 GMT

@KeithOlson @DavidPike @Asrujit_SenGupta

I've been working with ESRI Tech support on this and at the moment, have a work around:

If you recalculate the spatial index of the feature class, the symbology behaves itself. I have no idea why but I just tried it on a test feature class, and then on my production feature class. I'm not a fan of work arounds.

However, from an email conversation with the support analyst, I was offered this pearl of wisdom:

...It seems like we are running into some strange buggy behavior here...

All I can think of is:

Re: Enterprise GDB features repeat symbology

KeithOlson — Thu, 12 Aug 2021 13:57:44 GMT

Joe, thanks for the advice. Our DBA recalculated the spatial index on one of our culprit feature classes as a test and it seems to have worked. Adding that fc to a map uses the normal (ugly pastel) default symbology again. We have several other fc's with this issue, so she will have to tackle each one, but it looks like this is the solution for now. Hopefully esri will have a permanent fix before the issue rears it's head again. Thanks much!

Re: Enterprise GDB features repeat symbology

JoeBorgione — Thu, 12 Aug 2021 14:18:26 GMT

@KeithOlson Other options:

..such as renaming the feature class, removing a coded value domain, disabling attribute rules, or recalculating spatial index. After performing each change and undoing said change, the issue would not persist.

The spatial index option seems to me as the least invasive. Unfortunately I don't see a way automate calculating the spatial index. There are tools (and subsequently a pythonic automation approach) for Adding indexes and Removing them, but not (re)calculating them...

In my case we use attribute rules, and there is a python approach to Disabling them as wells (re) Enabling them that I may look into.

Re: Enterprise GDB features repeat symbology

KeithOlson — Thu, 12 Aug 2021 14:21:12 GMT

Definitely good to have options. We will experiment with those and see which ones are quickest / take the least amount of valuable DBA effort.

Re: Enterprise GDB features repeat symbology

JoeBorgione — Thu, 12 Aug 2021 21:26:54 GMT

@KeithOlson et al-

I just got off the phone with ESRI Tech support. This problem is fixed at version 2.8 and above. I'm seeing the problem at 2.7.4 but apparently it started at 2.7 and I just never noticed it.

There is a definite ying and yang tp updates. As a python user I have been hesitant to upgrade to 2.8 as I've heard of python environment bug. Apparently that problem exists at 2.8.1 and above; development is aware of it and it is supposed to be fixed at 2.9. Ironically, if all goes well I'll be retired by the time 2.9 is released. I'm not sure if I'll upgrade to 2.8.x; there are a number of work arounds for the python bug...