A client lost some data, or so they thought, because the Microsoft SQL Server Spatial features were not displaying in Bentley Map. Looking at the database, the feature was actually in the table when viewing the Spatial results. Unfortunately this is not the only table that has this problem where random features are not displaying.
So what could be the problem?
In this case, the table was a 'polygon' table and some of the polygons are in fact “multi-polygons”. In the GSA schema file, the definition is set to a single polygon type. They may not look multi-polygon on the screen but some of them are. Re-register the feature and set the Type to Polygon Collection in the GSA Schema file.
The “missing” features now query correctly.