WebGIS Discussions

Need a push in the right direction when configuring WebMap, Portal or SDI services? Looking for hints and tips, or just looking for Ideas and information? The WebGIS discussion board is where you start those discussions, connect and share information.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Frequent Contributor
Posts: 152
Registered: ‎04-29-2016

Portal Search Support Through MSSQL

Hi, 

 

I recieved the attached error message while trying to load search configurations tab

Is search not supported at MSSQL??

is it supported only by use of Oracle?? 

 

Regards,

Maha

Maha Kamal
Highlighted
Technical Evangelist
Posts: 401
Registered: ‎02-04-2016
Highlighted
Frequent Contributor
Posts: 152
Registered: ‎04-29-2016

Re: Portal Search Support Through MSSQL

Hi Frank,

 

Thanks but I'm asking about the standard geospatial portal not the consumer portal.

I know that catalog search is supported at both MSSQL & Oracle.

But here i'm asking about Geographic Names (WFS-G) search which is configured from admin console 

 

Regards,

Maha

Maha Kamal
Highlighted
Technical Evangelist
Posts: 401
Registered: ‎02-04-2016

Re: Portal Search Support Through MSSQL

[ Edited ]

Hi Maha,

 

The Search Configuration section shown on your previous screenshot is for CP Search:

https://hexagongeospatial.fluidtopics.net/reader/YS8lbCzq66les82OrxFhTg/Cgriezot6mQMCPPTl4Miew

 

Please check out the WFS-G section of the "GeoMedia WebMap Administrator Guide" here:

https://hexagongeospatial.fluidtopics.net/reader/nnybR~tZxbDITXWj2GgNxQ/XeSUIjgTpC6HTUIePnP_JQ

 

Thanks

 

Frank

 

Highlighted
Frequent Contributor
Posts: 152
Registered: ‎04-29-2016

Re: Portal Search Support Through MSSQL

Thanks Frank,

I need to implement a search based on WFS-G like the attached printscreen from geospatial portal demo.

based on the 2nd url that you shared. it's OK at MSSQL, Oracle, Access

is it supported also at PostgreSQL/PostGIS??

 

Regards,

Maha

 

 

Maha Kamal
Highlighted
Technical Evangelist
Posts: 401
Registered: ‎02-04-2016

Re: Portal Search Support Through MSSQL

Highlighted
Frequent Contributor
Posts: 152
Registered: ‎04-29-2016

Re: Portal Search Support Through MSSQL

Hi Frank,

 

Thanks, WFS-G search worked correctly.

but at click feature info. icon at item from result list>> it returns the attached error

 

Regards,

Maha

Maha Kamal
Highlighted
Technical Evangelist
Posts: 401
Registered: ‎02-04-2016

Re: Portal Search Support Through MSSQL

Hi Maha,

 

Please turn on the wfs-g log (log4net) to see if there is any clue on the error.

 

I suspect it may be related to featurename (i.e. somehow the request is invalid or contains syntrax error, perhaps due to special characters in the input parameter).

 

A good test is to clone a record and replace the name with "ABC", if you can find "ABC" in this WFS-G, then test the GFI tool to see if it fail the same way.

 

Thanks

 

Frank