The error message "Error: Failed to open table" is returned when opening an attribute table in ArcGIS Pro from a table or feature class created in SQL Server.

Workaround

Updating the shape using the following queries makes feature 2 visible on the map. The attribute table also opens successfully.

geometry::STGeomFromText(SHAPE.STAsText(), 4148)

Update [dbo].[TEST_GEOMETRY] set Shape = geometry::STGeomFromText(SHAPE.STAsText(), 4148)

where [OBJECTID] =2

Schritte zur Reproduzierung