Calculate Cluster Key - Operation was attempted on empty geometry

Question

Hello @RobertKrisher and all,

We encountered an error while running the Calculate Cluster Key tool: "Operation was attempted on empty geometry." In our case, the UNM implementation was utilising a custom coordinate system.

We then tested the tool on Water Distribution UN Foundation gdb, which uses Esri coordinate system (NAD 1983 StatePlane Illinois East FIPS 1201, US Feet), and the tool functioned as expected. However, after we changed the spatial reference of the Water Distribution UN Foundation gdb to the same custom coordinate system, it hit the same error.

Was wondering if this tool does not support the UNM implementation in custom coordinate system or if there is something i missed?

Our goal is to improve UNM performance in any way possible as it is noticeable that UNM tends to render slower in web app level. Any suggestion on how to improve UNM performance is very much appreciate as well!

Thanks in advance!

RobertKrisher · Answer

@AmberY also, can you please provide repro steps (and ideally log a case with support) that shows how you're getting a 999999 error when enabling cluster keys? You shouldn't be getting an error.

GIS_kiwi4 · Answer

The numbers and the logic looks sensible but there are too many variables in these kind of problems to find a smoking gun. It could be the number of users, you might need to check SQL logs to see if there are queries slowing down the performance. The problem could exist anywhere from the webadapter -> server -> DB

@RobertKrisher has linked the reference architecture and it would be good to compare your setup against it.

One other thing to try is tweaking values on the Parameter on the server.

Do you run DB maintenance scripts to recreate spatial indexes? This can increase performance if you do a lot of spatial changes in the data or you do sizable data loads regularly.

It can be quite frustrating not having a quick solution but work your way through the possibilities.

RobertKrisher · Answer

You can find an example test study that discusses the number of instances to consider here: Test Study for a Network Information Management System Electric Utility (PostgreSQL) | ArcGIS Architecture Center