[mapserver-users] Problems with MapServer and Oracle Spatial

Jorge Bellido Diez jbellido at ikt.es
Fri Sep 10 05:46:03 PDT 2010


Hi,
I'm working with Oracle Spatial 10g and the ms4w package with MapServer
5.6.1 
I configure a wms service and a wfs service and when i do the getFeature
request or getFeatureInfo request, I found critical log files in my
OracleSpatial Server. This is a little portion of one of this log files
with the error code:

..
..
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17182], [0x7FF985DDC24], [],
[], [], [], [], []
Current SQL statement for this session:
SELECT gid, TER_HIST, AREA, PERIMETRO, GID, PROVINCIA, GEOMETRY FROM
(SELECT * FROM GT_PROVINCIAS_ED50) WHERE SDO_FILTER( GEOMETRY,
MDSYS.SDO_GEOMETRY(2003, :srid,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates
),'querytype=window') = 'TRUE'
----- Call Stack Trace -----
..
..

With getFeatureInfo request it seems that Oracle sends the response to
mapserver ok but with getFeature request sometimes the oracle table has
rows corrupted, even though the user has no UPDATE-GRANTS.

I read that somebody has the similar problem with Oracle 11g?
Has someOne find a solution to this problem?
Thanks, jorge

 



More information about the MapServer-users mailing list