[Geoserver-users] SLD works on production server not on test server, same settings

Hi all!! :confused:

We have a working setup on our production server:
- GeoServer 1.6.3
- PostgreSQL Database Server 8.1

Our test server has the exact same configuration, using same database,
schema and tables names, Geoserver configuration also the same: Data Storage
name, etc., and same SLD, but test server doesn't work, WMS requests (to
view in openlayers or .kml file) instead of displaying the map (as the live
server does) the server sends a file download request (opens a file download
dialog screen asking if we want to save or open the file named: wms).

Im going nuts because Im using evertything the same, and the problem is with
the SLD, because if I use another SLD then it works, displays the map both
in OpenLayers and .kml works fine in Google Earth.

I saved the wms file, opened and this is what it says:

<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE
ServiceExceptionReport SYSTEM
"http://schemas.opengis.net/wms/1.1.1/WMS_exception_1_1_1.dtd&quot;&gt;
<ServiceExceptionReport version="1.1.1" > <ServiceException>
      The requested Style can not be used with this layer. The style
specifies an attribute of clasificac_vias and the layer is: topp:callesnac
</ServiceException></ServiceExceptionReport>

Again, the same SLD is working on our production server, same database,
tables, schemas, etc.

Any suggestions?

Thanks!
--
View this message in context: http://www.nabble.com/SLD-works-on-production-server-not-on-test-server%2C-same-settings-tp17634691p17634691.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

SenTnel ha scritto:

Hi all!! :confused:

We have a working setup on our production server:
- GeoServer 1.6.3
- PostgreSQL Database Server 8.1

Our test server has the exact same configuration, using same database,
schema and tables names, Geoserver configuration also the same: Data Storage
name, etc., and same SLD, but test server doesn't work, WMS requests (to
view in openlayers or .kml file) instead of displaying the map (as the live
server does) the server sends a file download request (opens a file download
dialog screen asking if we want to save or open the file named: wms). Im going nuts because Im using evertything the same, and the problem is with
the SLD, because if I use another SLD then it works, displays the map both
in OpenLayers and .kml works fine in Google Earth.

I saved the wms file, opened and this is what it says:

<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE
ServiceExceptionReport SYSTEM
"http://schemas.opengis.net/wms/1.1.1/WMS_exception_1_1_1.dtd&quot;&gt;
<ServiceExceptionReport version="1.1.1" > <ServiceException>
      The requested Style can not be used with this layer. The style
specifies an attribute of clasificac_vias and the layer is: topp:callesnac
</ServiceException></ServiceExceptionReport>

Again, the same SLD is working on our production server, same database,
tables, schemas, etc.

Any suggestions?

There must be some difference.... The server reporting the error is telling you it cannot find the clasificac_vias attribute in topp:callesnac layer. Can you double check it?
Can it be a permission issue, maybe on some metadata table like
geometry_columns?

Cheers
Andrea

Hi! Thanks Aaime!

I took special care recreating the test server, I deleted datastores, styles
and entities. As far as the postgres database I restored a production
server's backup. All columns and columns names are fine, the data (row
count) is the same, and like I said other SLD works. The clasificac_vias
attribute is fine, but Im not sure of the permission issue, what can I do, I
mean, what do I have to check?

Thanks!

aaime wrote:

SenTnel ha scritto:

Hi all!! :confused:

We have a working setup on our production server:
- GeoServer 1.6.3
- PostgreSQL Database Server 8.1

Our test server has the exact same configuration, using same database,
schema and tables names, Geoserver configuration also the same: Data
Storage
name, etc., and same SLD, but test server doesn't work, WMS requests (to
view in openlayers or .kml file) instead of displaying the map (as the
live
server does) the server sends a file download request (opens a file
download
dialog screen asking if we want to save or open the file named: wms).
Im going nuts because Im using evertything the same, and the problem is
with
the SLD, because if I use another SLD then it works, displays the map
both
in OpenLayers and .kml works fine in Google Earth.

I saved the wms file, opened and this is what it says:

<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE
ServiceExceptionReport SYSTEM
"http://schemas.opengis.net/wms/1.1.1/WMS_exception_1_1_1.dtd&quot;&gt;
<ServiceExceptionReport version="1.1.1" > <ServiceException>
      The requested Style can not be used with this layer. The style
specifies an attribute of clasificac_vias and the layer is:
topp:callesnac
</ServiceException></ServiceExceptionReport>

Again, the same SLD is working on our production server, same database,
tables, schemas, etc.

Any suggestions?

There must be some difference.... The server reporting the error is
telling you it cannot find the clasificac_vias attribute in
topp:callesnac layer. Can you double check it?
Can it be a permission issue, maybe on some metadata table like
geometry_columns?

Cheers
Andrea

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://www.nabble.com/SLD-works-on-production-server-not-on-test-server%2C-same-settings-tp17634691p17657718.html
Sent from the GeoServer - User mailing list archive at Nabble.com.