Juan,
First off: I'd suggest keeping 'geoserver-users@lists.sourceforge.net' on your emails, because other geoserver folks can probably help too, and also because we'd like to keep a record of our solution to your problem...so others in the future can find the answers via Google!
Ok, now about your problem:
When ArcSDE says 'database level error occurred' that means that ArcSDE is unable/unwilling to provide any information about what's wrong at the Java level. You'll need to look at your ArcSDE server logs to see what's going wrong...generally some bad SQL or something has gotten into the ArcSDE query.
The ArcSDE logfile should be at:
$SDEHOME/etc/sde_xxx_esri_sde.log (where xxx differs depending on your backend data format/instance name)
Try watching that file and seeing if something shows up that's instructive when you try and do the getmap.
Gabriel: Do you know if oracle SDO_GEOM columns have any issues that would cause something weird like this to happen? We store all our stuff as SDE_LOB...
--saul
________________________________
From: Paco Flores [mailto:arevaco90@anonymised.com]
Sent: Mon 6/18/2007 11:33 AM
To: Farber, Saul (EEA)
Subject: RE: [Geoserver-users] ArcSDE connection
Hi Saul,
I followed your advice and installed the latest version of Geoserver, this bug is now fixed in the latest version, however I came across with a new problem when trying to get the feature, the new error is:
INFO] org.geotools.arcsde.data.ArcSDEQuery - No FID attribute was contained in your query. Appending the discovered one to the list of columns to be fetched.
559143 [GRAVE] org.geotools.arcsde.data.ArcSDEAttributeReader - DATABASE LEVEL ERROR OCCURRED.
org.geotools.data.DataSourceException: DATABASE LEVEL ERROR OCCURRED.
I read your post about this issue but it wasn´t clear enough for me. I have tried with two different tables and none of them worked.
As an example I have a table with different columns: OBJECTID (Integer) which is my Primary Key, COD_LITO (number), CODIGO (number), SIMBOLO (varchar2), SHAPE (SDO_GEOMETRY) ..The Oracle connection works fine for the table but our organization in Spain needs to do the connection through ArcSDE 9.0.
Thanks for your help!!
Juan Arévalo.
"Farber, Saul (EEA)" <Saul.Farber@anonymised.com> escribió:
Juan,
Geoserver has just released a new version of both the server and the ArcSDE extension.
My first suggestion is to download the latest GeoServer release (1.5.1) and the latest GeoServer ArcSDE Extension (also 1.5.1)
You've done exactly correct in the 1.5.0 installation of the extension, but if you feel like reading about it, there are also instructions for 1.5.1 which you can find here:
http://docs.codehaus.org/display/GEOSDOC/ArcSDE+DataStore
All of the above advice aside, looking at your error makes me a little scared! I've seen exactly the issues you've just described, and they usually have to do with ArcSDE connections getting corrupted and then the ArcSDE extension never figuring out that somethings gone wrong and aborting.
I know this issue is fixed in an experimental version of geoserver, and it's quite likely that it's fixed in the latest 1.5.1 version as well, but if it's not then let us know when you get 1.5.1 installed and I'll try and track it down.
None of which addresses the actual problem that an ArcSDE connection is getting corrupted and causing the "FUNCTION CALLED OUT OF SEQUENCE" error. I'm not entirely sure what causes that, but I'm guessing it's something much more specific, and that the actual initial cause is getting buried under all the verbose errors afterwards.
So give 1.5.1 a shot and see if it resolves your issues. If it doesn't then we'll get more debugging tools involved.
--saul
________________________________
From: geoserver-users-bounces@lists.sourceforge.net on behalf of Juan Arévalo
Sent: Thu 6/14/2007 8:05 AM
To: geoserver-users@lists.sourceforge.net
Subject: [Geoserver-users] ArcSDE connection
Hi everyone!
I´m trying to set up the WAR version of Geoserver 1.5.0 through ArcSDE 9.0.
I downloaded the jars from ESRI: jsde90_sdk and jpe90_sdk and concurrent,
and the plugin for arcsde "geoserver-1.5.0-RC4-arcsde-plugin" which contains
two jars: gt2-arcsde and commons-pool-1.3. I placed all the jars under the
directory: "Apache Software Foundation\Tomcat
5.5\webapps\geoserver\WEB-INF\lib".
Then I added a new arcsde data store and it went fine.I set the featuretype
section without problems but now when I tried to preview the map or get the
feature, the log file gets bigger and bigger, with the following error:
604195 [GRAVE] org.geotools.renderer.lite.StreamingRenderer - FUNCTION
CALLED OUT OF SEQUENCE.
org.geotools.data.DataSourceException: FUNCTION CALLED OUT OF SEQUENCE.
at org.geotools.data.arcsde.ArcSDEQuery.fetch(ArcSDEQuery.java:845)
at
org.geotools.data.arcsde.ArcSDEAttributeReader.hasNext(ArcSDEAttributeReader.java:169)
at
org.geotools.data.DefaultFeatureReader.hasNext(DefaultFeatureReader.java:106)
at
org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1559)
at
org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:714)
at
org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:436)
at
org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:250)
at
org.vfny.geoserver.wms.responses.GetMapResponse.execute(GetMapResponse.java:307)
at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:516)
at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
at
org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEng ineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:534)
Caused by: com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.j.a(Unknown Source)
at com.esri.sde.sdk.client.j.d(Unknown Source)
at com.esri.sde.sdk.client.SeQuery.fetch(Unknown Source)
at org.geotools.data.arcsde.ArcSDEQuery.fetch(ArcSDEQuery.java:843)
the same error over and over again...
Please, any ideas on how to solve it??
Thanks!!!
Juan Arévalo.
--
View this message in context: http://www.nabble.com/ArcSDE-connection-tf3921354.html#a11118815
Sent from the GeoServer - User mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
________________________________
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com <http://us.rd.yahoo.com/mail/es/tagline/messenger/*http://es.voice.yahoo.com/>
