GMSC Discussions

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Frequent Contributor
Posts: 130
Registered: ‎11-10-2015

Displaying PostgIS text geometries generated by GeoMedia

Hi all,

I used the Labeling functionalities to generate some labels on a network. I have exported the result in a PostGIS database, and... GeoMedia Smart Client raises an error when trying to configure the Feature

The Test Settings button raises an 'Unexpected Error', and the Administrator logfile indicates

 

05.02.2019 16:59:23 ERROR - Cannot convert to MapLayer 525c5360-87ae-4462-9fb9-7d56819c0c31.
Intergraph.Emea.GeoSpatial.InvalidGeometryException: Invalid Geometry.
   at Intergraph.Emea.Data.PostgreSqlProvider.ConvertEwkbToGeometry(Byte[] wkb)
   at Intergraph.Emea.Data.PostgreSqlProvider.GetValue(IDataReader reader, String columnName, Type conversionType)
   at Intergraph.Emea.Data.PostgreSqlProvider.GetValue[T](IDataReader reader, String columnName)
   at Intergraph.Emea.Data.PostgreSqlProvider.GetSpatialMetadata(String tableName, String columnName, DbConnection connection, DbTransaction transaction)
   at Intergraph.Emea.Maps.MapLayer.Initialize(Dictionary`2 entityDataTypes, Boolean queryMetadataFromDataSource, String[] additionalAttributes)
   at Intergraph.Emea.Maps.MetadataConverter.ToLayer(DataRow layerDefinition, DataRow[] displayRuleDefinition, String siteName, Boolean queryMetadataFromDataSource, Boolean forceCoordinateTransform)
   at Intergraph.Emea.Maps.MetadataConverter.ToLayers(DataTable layers, String siteName, Boolean queryMetadataFromDataSource, Boolean forceCoordinateTransform)
   --- Inner exception ---
System.FormatException: 24115: The well-known binary (WKB) input is not valid.
   at Microsoft.SqlServer.Types.WellKnownBinaryReader.ParseWkb(OpenGisType type)
   at Microsoft.SqlServer.Types.WellKnownBinaryReader.ParseWkbGeometryCollectionWithoutHeader(ByteOrder byteOrder)
   at Microsoft.SqlServer.Types.WellKnownBinaryReader.ParseWkb(OpenGisType type)
   at Microsoft.SqlServer.Types.WellKnownBinaryReader.Read(OpenGisType type, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromBinary(OpenGisType type, SqlBytes binary, Int32 srid)
   at Intergraph.Emea.GeoSpatial.GeometryBuilder.STGeomFromWKB(Byte[] wkbGeometry, Int32 srid)
   at Intergraph.Emea.Data.PostgreSqlProvider.ConvertEwkbToGeometry(Byte[] wkb)

 Is it possible to display in GeoMedia Smart Client text data (PostGIS format) produced by GeoMedia?

 

Regards

Benoît