[Geoserver-users] Valid PostGIS layers fail in Geoserver (EPSG:404000)

[severin.menard via Geoserver-users]

Hi,
This issue has been already documented in forums including this discussion 
list, but seems without being solved so far:
https://sourceforge.net/p/geoserver/mailman/geoserver-users/thread/1517311305541-0.post%40n6.nabble.com/#msg36209816

https://gis.stackexchange.com/questions/354395/problem-with-adding-new-layers-with-epsg404000-in-geoserver

I cannot create GeoServer layers from PostGIS layers created in QGIS3 with DB 
Manager from a shapefile: while these pg layers are fully operational both in 
QGIS (see below the import settings + the connection info to Pg) and PgAdmin 
(see below the geometry_columns view), GeoServer (v2.12.5-georchestra) is 
unable to identify the SRS (I tested several ones) and add EPSG:404000 as 
Declared SRS and the list from Native SRS is not accessible and the box cannot 
be filled.
When clicking on Bounding Boxes>Compute from data, either with Declared 
SRS=EPSG:404000 or Declared SRS=EPSG:4326, the process crashes with this error 
message (while I have other pg layers in the same schema that work perfectly in 
GeoServer, but have been created though a imposm process):

Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor475.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:258)
... 111 more
Caused by: java.lang.RuntimeException: java.io.IOException: Error occured 
calculating bounds for CI_Bouake_Cohesion_4_quartiers_enquetes_EPSG4326
at 
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:519)
at 
org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:414)
at 
org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:352)
at 
org.vfny.geoserver.global.GeoServerFeatureSource.getBounds(GeoServerFeatureSource.java:637)
at org.geoserver.catalog.CatalogBuilder.getNativeBounds(CatalogBuilder.java:555)
at org.geoserver.catalog.CatalogBuilder.getNativeBounds(CatalogBuilder.java:538)
at 
org.geoserver.web.data.resource.BasicResourceConfig$1.onSubmit(BasicResourceConfig.java:138)
at 
org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:111)
at 
org.apache.wicket.ajax.form.AjaxFormSubmitBehavior$AjaxFormSubmitter.onSubmit(AjaxFormSubmitBehavior.java:215)
at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:787)
at 
org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:171)
at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:155)
at 
org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:601)
... 115 more
Caused by: java.io.IOException: Error occured calculating bounds for 
CI_Bouake_Cohesion_4_quartiers_enquetes_EPSG4326
at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1336)
at 
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:513)
... 127 more
Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for 
relation CI_Bouake_Cohesion_4_quartiers_enquetes_EPSG4326
at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
at 
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at 
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1311)

Any clue?

Sincerely,

Severin

[url=https://postimg.cc/RNgfdY6t][img]https://i.postimg.cc/RNgfdY6t/Geo-Server-SRS-404000-error.png[/img][/url]

[url=https://postimg.cc/G91kmGn4][img]https://i.postimg.cc/G91kmGn4/Geo-Server-SRS-404000-error-geometry-columns.png[/img][/url]

[url=https://postimg.cc/3WC24N3n][img]https://i.postimg.cc/3WC24N3n/Geo-Server-SRS-404000-error-pg-layers-in-QGIS3.png[/img][/url]

[url=https://postimg.cc/2Vkh4Y6m][img]https://i.postimg.cc/2Vkh4Y6m/Geo-Server-SRS-404000-import-db-QGIS3.png[/img][/url]

_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users