Este explorador ya no se admite.
Actualice a Microsoft Edge para aprovechar las características y actualizaciones de seguridad más recientes, y disponer de soporte técnico.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 49%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Consultando datos geograficos y haciendo click a la pestaña "Spatial Results" me da el error. He probado con versiones anteriores y continúa. Se da solo en ciertas geometrías. Este es un equipo nuevo, funciona correctamente en otros equipos. Actualicé Sql server types.
One of the identified items was in an invalid format. (Microsoft.SqlServer.Types)
Program Location:
at Microsoft.SqlServer.Types.SqlGeometry.Read(BinaryReader r)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.LoadDataForGeometry.ReadAndValidateSpatialData(BinaryReader binaryReader)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.LoadDataForSpatialDataType.LoadData(LoadDataObject loadDataObject)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.MapPanel.LoadDataToDataTable(LoadDataObject loadDataObject)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.MapPanel.LoadData()
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 35%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
It works OK in Management Studio v18.12.1
But the errormessage "One of the identified items was in an invalid format" occurs when using Management Studio v20.2 for the same SQL-query.
It looks like it can be MULTIPOLYGON geometries that is causing the error message in v20.2.
I don't think that's the case; I have tested with POLYGON and MULTIPOLYGON and have encountered errors with both
I don't think that's the case; I have tested with POLYGON and MULTIPOLYGON and have encountered errors with both
Yes, that looks correct.
I tested for one MULTIPOLYGON geometry (French Guiana).
And that worked OK in v20.2.
But for example MULTIPOLYGON geometries for Sweden, Denmark, Norway and Finland does get the error in v.20.2. The main difference is maybe that there is many more small islands in the geometries for those MULTIPOLYGONS than for the one for: French Guiana. I don't know if that is the reason.
But anyway it should work for all the geometries in v20.2 too.
As it is no problem to view all of them in v.18.12.1.
It's look like there is some kind of bug in the Spatial Results tab in v.20.2.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 98%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
I discovered a similar issue after upgrading to SQL Server Management Studio 19.3.4 earlier this year and guessed it is a bug in SSMS, as the error was not there in previous versions.
The error appears when attempting to display spatial data in the "Spatial" tab of SSMS when there is a geography/geometry with over 4000 points in it.
I logged it on the page at https://feedback.azure.com/d365community/idea/76a0d1bc-7307-ef11-a73c-000d3a012948. If it is the same issue for you (which you may need to test to confirm), feel free to vote for the post.
That's exactly the problem! I hadn't noticed it before because I never had a geometry with so many points.