0

I am using Geoserver to create a WMS service to serve data out of an SQL Server database. Everything works fine (WMS & WFS) untill I create an SQLView in Geoserver.

The SQLView:

SELECT *
FROM rmaster

I have defined the CRS and geometry column. The WFS service of the SQLView works properly and serves the data, however the WMS serves empty images. Does anyone have any idea what's causing this?

closed as off-topic by user30184, Paul, Andre Silva, Mapperz Apr 7 '16 at 18:14

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This problem cannot or can no longer be reproduced. Changes to the system or to the asker's circumstances may have rendered the question obsolete, or the question does not include a procedure to enable potential answerers to reproduce the same symptoms. Such questions are off-topic as they are unlikely to help future readers, but editing them to include more details can lead to re-opening." – user30184, Paul, Andre Silva, Mapperz
If this question can be reworded to fit the rules in the help center, please edit the question.

  • probably your style is broken – Ian Turton Apr 7 '16 at 10:02
  • When I'm serving the original data (no sqlview) as wms, the style is working properly – Titsjmen Apr 7 '16 at 10:25
1

Problem solved.

There was a wrong row in the "spatial_ref_sys" table of the SQL Server database, which was referring to an unexisting SRS. I've replaced it with the following row for WGS84 SRS.

srid:4326   auth_name:EPSG auth_srid:4326   srtext:GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9108"]],AUTHORITY["EPSG","4326"]]  proj4text: +proj=longlat +ellps=WGS84 +towgs84=0,0,0,0,0,0,0 +no_defs

Not the answer you're looking for? Browse other questions tagged or ask your own question.