Hi,
We are still unable to resolve this issue. We have tried our best to
ensure what should be done are done.
The feature we are trying to create is from a view. What we did is to
create a view, ensure there is a record for it in the geometry_columns. We
have another very similar view to this one and everything worked out fine
for that view, thus we are really losing ideas of what could be wrong with
this.
To be more specific, here is the full stack trace:
2007-02-08 21:01:34 StandardWrapperValve[action]: Servlet.service() for
servlet action threw exception
org.geotools.data.DataSourceException: Could not count Request All Features
at
org.geotools.data.postgis.PostgisFeatureStore.bounds(PostgisFeatureStore.java:862)
at
org.geotools.data.postgis.PostgisFeatureStore.getBounds(PostgisFeatureStore.java:783)
at
org.geotools.data.postgis.PostgisFeatureStore.getBounds(PostgisFeatureStore.java:760)
at
org.vfny.geoserver.action.data.DataStoreUtils.getBoundingBoxEnvelope(DataStoreUtils.java:250)
at
org.vfny.geoserver.action.data.TypesEditorAction.executeBBox(TypesEditorAction.java:160)
at
org.vfny.geoserver.action.data.TypesEditorAction.execute(TypesEditorAction.java:107)
at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:98)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: function
extent(geometry) does not exist
at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221)
at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.postgresql.jdbc2.optional.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:392)
at $Proxy33.executeQuery(Unknown Source)
at
org.geotools.data.postgis.PostgisFeatureStore.getEnvelope(PostgisFeatureStore.java:895)
at
org.geotools.data.postgis.PostgisFeatureStore.bounds(PostgisFeatureStore.java:842)
... 36 more
We need urgent help on this, thus would appreciate some advice on what is
wrong. Thank you.
Regards,
Wai See
What kind of dataset are you using? (shapefile, postgis, oracle...).
Also, make sure you have the correct SRS value defined. If your data is
in a projection other than the SRS you defined, you probably won't get
back any features and it could cause this problem.Brent Owens
(The Open Planning Project)Sim Kim Sia wrote:
Hi,
I had the following exception when I press generate button whilst
creating a new feature type.The following exception was thrown:
/|org.geotools.data.DataSourceException: Could not count Request All
Features|/
/||/
|I tried googling, but was not exactly enlightend. Can anyone help?|
||
|Thanks|
Regards
Kim SiaExtension: 3160
[This e-mail is confidential and may be priviledged. If you are not the
intended recipient, please kindly notify us immediately and delete the
message
from your system; please do not copy or use it for any purpose, nor
disclose
its contents to any other person. Thank you.]
---ST Electronics Group---------------------------------------------------------------------------
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services,
security?
Get stuff done quickly with pre-integrated technology to make your job
easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
------------------------------------------------------------------------_______________________________________________
Geoserver-users mailing list
Geoserver-users@anonymised.com
https://lists.sourceforge.net/lists/listinfo/geoserver-users