<html><body bgcolor="#FFFFFF"><div>One thing that I find particularly strange about these errors (ORA-0600) is that when you look them up they say "internal error - call Oracle". So while MapServer is probably doing something strange, the database is still failing in an unexpected way. I would expect it to return something from the OCI library or a more specific db error like invalid handle or invalid statement or something similar.</div><div><br></div><div>Jim K<br><br><div><br></div></div><div><br>On May 26, 2010, at 6:22 AM, <a href="mailto:umn-ms@hydrotec.de">umn-ms@hydrotec.de</a> wrote:<br><br></div><div></div><blockquote type="cite"><div><font size="2" face="sans-serif">Hi</font>
<br>
<br><font size="2" face="sans-serif">I'm facing similar/also strange problems.</font>
<br>
<br><font size="2" face="sans-serif">I use </font>
<br><font size="2" face="sans-serif">* mapserver 5.6.3, </font>
<br><font size="2" face="sans-serif">* Linux-Redhat (Version ?)</font>
<br><font size="2" face="sans-serif">* 64-Bit</font>
<br><font size="2" face="sans-serif">* Oracle 11g on the DB-client</font>
<br><font size="2" face="sans-serif">* Sun-Java 1.6</font>
<br>
<br><font size="2" face="sans-serif">When creating some maps with a selection
I get:</font>
<br><font size="2" face="sans-serif">java.lang.UnknownError: msOracleSpatialLayerWhichShapes():
OracleSpatial error. Error: ORA-00600: Interner Fehlercode, Argumente:
[kokeaai5], [18], [2], [], [], [], [], [], [], [], [], []</font>
<br><font size="2" face="sans-serif"> . Query statement: SELECT GEWAESSER_ID,
NAME, GEWAESSER_ID, DARSTELLUNGSSTUFE, shape FROM (select <a href="http://WWI.GEWAESSER.NAME">WWI.GEWAESSER.NAME</a>,
WWI.GEWAESSER.SHAPE, WWI.GEWAESSER.GEWAESSER_ID,WWI.GEWAESSER.DARSTELLUNGSSTUFE
FROM WWI.GEWAESSER) WHERE SDO_FILTER( shape, MDSYS.SDO_GEOMETRY(2003, :srid,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window')
= 'TRUE' . Check your data statement.</font>
<br><font size="2" face="sans-serif"> at
edu.umn.gis.mapscript.mapscriptJNI.layerObj_queryByRect(Native Method)</font>
<br><font size="2" face="sans-serif"> at
edu.umn.gis.mapscript.layerObj.queryByRect(layerObj.java:513)</font>
<br><font size="2" face="sans-serif"> at
de.hydrotec.ims.umn.MapMetaInfoImpl.configureSelection(MapMetaInfoImpl.java:216)</font>
<br>
<br><font size="2" face="sans-serif">* Problem occurs in most cases after
making three selections</font>
<br><font size="2" face="sans-serif">* Problem occurs on a 11g and a 10g
databaseserver.</font>
<br><font size="2" face="sans-serif">* What's *really* strange: A record
in the queried table GEWAESSER is corrupted!</font>
<br><font size="2" face="sans-serif"> Even though the mapserver-user
has no UPDATE-GRANTS.</font>
<br><font size="2" face="sans-serif">* No problems with mapserver 5.4.2.
(This is my fallback for the current project...)</font>
<br>
<br><font size="2" face="sans-serif">Sorry for not being more specific. </font>
<br><font size="2" face="sans-serif">But it's not easy to describe this strange
behaviour. Never found something like this.</font>
<br>
<br><font size="2" face="sans-serif">I saw, that maporaclespatial in the
SVN-trunk has some important fixes.</font>
<br>
<br><font size="2" face="sans-serif">Question: </font>
<br><font size="2" face="sans-serif">* Can I use the most current maporaclespatial
from the trunk? Will it be compatible with the rest of</font>
<br><font size="2" face="sans-serif"> mapserver5.6.3?</font>
<br><font size="2" face="sans-serif">* Is there any hope, that this may help?
</font>
<br>
<br><font size="2" face="sans-serif">Benedikt</font>
<br>
<br><tt><font size="2"><a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a> schrieb am
26.05.2010 00:00:48:<br>
<br>
> Agostino <<a href="mailto:acsviluppo@yahoo.it">acsviluppo@yahoo.it</a>> </font></tt>
<br><tt><font size="2">> Gesendet von: <a href="mailto:mapserver-users-bounces@lists.osgeo.org"><a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a></a><br>
> </font></tt>
<br><tt><font size="2">> 26.05.2010 00:01</font></tt>
<br><tt><font size="2">> <br>
> An</font></tt>
<br><tt><font size="2">> <br>
> <a href="mailto:mapserver-users@lists.osgeo.org"><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a></a></font></tt>
<br><tt><font size="2">> <br>
> Kopie</font></tt>
<br><tt><font size="2">> <br>
> Thema</font></tt>
<br><tt><font size="2">> <br>
> [mapserver-users] Re: msOracleSpatialLayerWhichShapes(): OracleSpatial
error</font></tt>
<br><tt><font size="2">> <br>
> <br>
> Thank you Tamas. <br>
> I think that the new 5.6 functions does not work properly with oracle<br>
> spatial. <br>
> Also with the last build from </font></tt><a href="http://vbkto.dyndns.org/sdk/"><tt><font size="2">http://vbkto.dyndns.org/sdk/</font></tt></a><tt><font size="2">
i have error.<br>
> <br>
> The following code works:<br>
> layerObj lo = map.getLayer(i);<br>
> ...<br>
> res = lo.queryByAttributes(map, null, strQuery.ToString(),<br>
> mapscript.MS_MULTIPLE);<br>
> ...<br>
> resultCacheObj results = lo.getResults();<br>
> int numres = results.numresults;<br>
> for (int j = 0; j < numres; j++)<br>
> {<br>
> int shapeInd = results.getResult(j).shapeindex;<br>
> shapeObj shp = lo.getFeature(shapeInd, -1);<br>
> layerObj loSel = GetSelectionLayer(map, lo.type);<br>
> shp.draw(map, loSel, img);<br>
> }<br>
> <br>
> but if i write this using new functions:<br>
> <br>
> layerObj lo = map.getLayer(i);<br>
> ...<br>
> res = lo.queryByAttributes(map, null, strQuery.ToString(),<br>
> mapscript.MS_MULTIPLE);<br>
> ...<br>
> int numres = lo.getNumResults();<br>
> for (int j = 0; j < numres; j++)<br>
> {<br>
> resultCacheMemberObj reso = lo.getResult(j);<br>
> shapeObj shp = new shapeObj((int)lo.type);<br>
> lo.resultsGetShape(shp, reso.shapeindex, reso.tileindex);<br>
> layerObj loSel = GetSelectionLayer(map, lo.type);<br>
> shp.draw(map, loSel, img);<br>
> }<br>
> <br>
> i have the exception <br>
> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-00600:
<br>
> codice di errore interno, argomenti: [17182], [0x2581CE802], [], [],
[], [], <br>
> [], [] <br>
> after call drawmap().<br>
> <br>
> Agostino.<br>
> -- <br>
> View this message in context: </font></tt><a href="http://osgeo-org/"><tt><font size="2">http://osgeo-org</font></tt></a><tt><font size="2">.<br>
> <a href="http://1803224.n2.nabble.com/msOracleSpatialLayerWhichShapes-OracleSpatial-"><a href="http://1803224.n2.nabble.com/msOracleSpatialLayerWhichShapes-OracleSpatial-">1803224.n2.nabble.com/msOracleSpatialLayerWhichShapes-OracleSpatial-</a></a><br>
> error-tp5048929p5100718.html<br>
> Sent from the Mapserver - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>
> _______________________________________________<br>
> mapserver-users mailing list<br>
> <a href="mailto:mapserver-users@lists.osgeo.org"><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a></a><br>
> </font></tt><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"><tt><font size="2">http://lists.osgeo.org/mailman/listinfo/mapserver-users</font></tt></a><tt><font size="2"><br>
</font></tt></div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>mapserver-users mailing list</span><br><span><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a></span><br><span><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></span><br></div></blockquote></body></html>