Hi, Error comes from Oracle. It is about impossible to guess what happens without knowing little bit more about the Oracle object that you are using as source data and the SQL that Geoserver is generating for database query. You can capture the latter by changing Geoserver logging profile into GEOTOOLS_DEVELOPER_LOGGING.
-Jukka Rahkonen- SamHen wrote: > > Hello, > > We are facing the same issue. > GeoServer : 2.0.2 > Oracle : 11gR2 Enterprise Edition > > Functionaly, one tile looks blank with a text error. Not > often. Many layers > may be concerned. > > Two consecutive errors are traced out by GeoServer (Oracle messages in > French) : > ERROR [geotools.rendering] - java.io.IOException > ... > Caused by: java.sql.SQLException: ORA-00604: une erreur s'est > produite au > niveau SQL récursif 1 > ORA-06550: Ligne 6, colonne 13 : > PLS-00306: numéro ou types d'arguments erronés dans appel à > 'ODCISTATSFUNCTIONCOST' > ORA-06550: Ligne 6, colonne 7 : > PL/SQL: Statement ignored > > ERROR [geoserver.ows] - > org.vfny.geoserver.wms.WmsException: > org.vfny.geoserver.wms.WmsException: > Rendering process failed > ... > java.lang.Exception: Exception rendering layer > FeatureCollectionMapLayer[ > LAYERXXX, VISIBLE, UNSELECTED, style=StyleImpl[ name=STYLEXXX], > data=org.vfny.geoserver.global.GeoServerFeatureLocking@16c006e > , query=Query: > feature type: LAYERXXX > filter: [Filter.INCLUDE AND Filter.INCLUDE] > [properties: ALL ]] > ... > same SQLException... > > -- > View this message in context: > http://osgeo-org.1803224.n2.nabble.com/ORA-00604-error-on-Geos erver2-0-2-Oracle10g2-0-1-0-and-Tomcat6-x-tp6102577p6260442.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > -------------------------------------------------------------- > ---------------- > Xperia(TM) PLAY > It's a major breakthrough. An authentic gaming > smartphone on the nation's most reliable network. > And it wants your games. > http://p.sf.net/sfu/verizon-sfdev > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
