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
Staff
Posts: 1
Registered: ‎01-07-2019

GMSC Search queries on postgres

[ Edited ]

Hi Team,

 

Working on GMSC version 16.5.316.4 with Postgres.

 

I am not able to execute search query "SELECT * FROM SHEETS_25K WHERE MAP_SHEET_NO= {ENTITY.MAP_SHEET_NO};"

 

Below is the log from SmartClientService.log

10.01.2019 11:18:22 ERROR - Search execution failed for query 8c89563c-0bbf-4920-a476-fe4e4a605430 - (Search Map Sheet No).
	SqlText: 
	Select * from sheets_25k where map_sheet_no = @MAP_SHEET_NO
Npgsql.NpgsqlException: Unknown message code: 0
   at Npgsql.PGUtil.ValidateBackendMessageCode(BackendMessageCode code)
   at Npgsql.NpgsqlConnector.DoReadMessage(DataRowLoadingMode dataRowLoadingMode, Boolean isPrependedMessage)
   at Npgsql.NpgsqlConnector.ReadMessageWithPrepended(DataRowLoadingMode dataRowLoadingMode)
   at Npgsql.NpgsqlConnector.SkipUntil(BackendMessageCode stopAt1, BackendMessageCode stopAt2)
   at Npgsql.NpgsqlDataReader.Consume()
   at Npgsql.NpgsqlDataReader.Close(Boolean connectionClosing)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Intergraph.Emea.Data.PostgreSqlProvider.CreateDataTable(String sqlCommand, DbConnection connection, IEnumerable`1 parameters, DbTransaction transaction, String[] spatialColumns)
   at Intergraph.Emea.SmartClient.Services.Dal.SearchAdapter._GetSearchResult(Object[] ids, Dictionary`2 criteria)

Thanks,

Jai Ram Gaur

Highlighted
Technical Evangelist
Posts: 1,131
Registered: ‎09-11-2015

Re: GMSC Search queries on postgres

Hi Jai Ram Gaur,

 

Can you enable logging on the Postgres database and see how does the actual query look like in the database? Some hints how to quickly enable SQL logging can be found here: https://stackoverflow.com/questions/722221/how-to-log-postgresql-queries

 

Thanks,

Jan

Jan Neumann
Post Sales Engineer Web Applications
Hexagon Geospatial