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

Reply via email to