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.