ArcGIS Professional 2.2 Labelling
I am having an issue labelling polygons in a query layer from SQL Server 2008 R2.
No labels seem to be drawing.
I have checked the data and all columns are populated.
Could someone please point me in the right direction. I have tried the polygon labelling in SQL Server 2008 R2 and 2016 without luck.
Solved! Go to Solution.
No worries, Wendy. I figured it was worth a try. 🙂
Yes, I have provided the Support team with the data that they need. Yet, they are unable to replicate. It is being escalated, so, hopefully, we will have a resolution soon.
I will send an update once we figure it out.
Just an update here...after months and months of troubleshooting, we were able to determine that there was a bug -- BUG-000121886. Hopefully, we will have a resolution soon.
Hi Shane - it is probably something to do with the ring ordering. Still trying to get to the bottom of it. A few more questions...
What storage type (geometry or geography) are you using in SQL Server?
Where did the data come from? was it created in ArcGIS?
wendy, appreciate the help.
Hope this helps
We used to use the extension but reverted back to uploading a OGC well known binary. I have also tried using the GDAL libraries to upload to a SQL geometry data type directly and still have the same labelling issue.
I think i know this particular issue, and believe it may be something we have recently fixed in the software which was related to ring order. You mentioned that you are using ArcGIS Pro 2.2, and ArcMap as well... can you confirm the version of ArcMap? I suspect it is 10.6.1 because that is when the issue I am thinking about would have been introduced.
The reason you wouldn't see the issue with data created by ArcGIS is because we will always follow our ring order requirements when inserting the data into a feature class. I suspect the method used to insert directly into the spatial table where you see this issue is not following our required ring order direction. SQL Server really does not care about this when the data is stored in the geometry spatial type so STIsValid would return the shape as valid no matter which way you inserted.
In 10.6.1 we made some changes to our validation method which improved performance, but also resulted in problems when reading shapes that have this reversed ring ordering.
What is the possibility that you could log a case with technical support so that we can get you hooked up with a defect?