<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<span id="result_box" class="long_text" lang="en"><span
title="Speicherzugriffsfehler bei Zugriff auf Oracle-Datenbank"></span><span
title="Hi,">Hi,<br>
</span><span title="ich versuche, mit dem Mapserver 6.2.0-rc1
Daten aus einer Oracle-Datenbank anzuzeigen.">I try to use
MapServer 6.2.0-rc1 to display data from an Oracle database.<br>
<br>
</span><span title="mapserv -v"><b>mapserv -v</b><br>
</span><span title="MapServer version 6.2.0-rc1 OUTPUT=GIF
OUTPUT=PNG OUTPUT=JPEG SUPPORTS=PROJ SUPPORTS=GD SUPPORTS=AGG
SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER
SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT
SUPPORTS=WCS_SERVER SUPPORTS=FASTCGI SUPPORTS">MapServer version
6.2.0-rc1 OUTPUT = GIF OUTPUT = PNG OUTPUT = JPEG SUPPORTS =
PROJ SUPPORTS = AGG SUPPORTS SUPPORTS = DG = FREETYPE SUPPORTS =
ICONV SUPPORTS = WMS_SERVER SUPPORTS = WMS_CLIENT SUPPORTS =
WFS_SERVER SUPPORTS = WFS_CLIENT SUPPORTS = WCS_SERVER SUPPORTS
= FastCGI SUPPORTS </span><span title="=THREADS SUPPORTS=GEOS
INPUT=JPEG INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL
INPUT=SHAPEFILE">= THREADS SUPPORTS = GEOS INPUT = JPEG INPUT =
ORACLESPATIAL INPUT = OGR INPUT = GDAL INPUT = SHAPEFILE<br>
<br>
<b>Error message:</b><br>
</span><span title="shp2img -m ./oracle.map -i png -o ./output.png
-s 500 500 -all_debug 5 -l test">shp2img-m. / png
oracle.map-i-o. / output.png s 500-500-5-l test all_debug<br>
<br>
</span><span title="msLoadMap(): 0.011s">msLoadMap (): 0.011s<br>
</span><span title="msDrawMap(): rendering using outputformat
named png (AGG/PNG).">msDrawMap (): rendering using outputFormat
named png (AGG / PNG).<br>
</span><span title="msDrawMap(): WMS/WFS set-up and query, 0.000s">msDrawMap
(): WMS / WFS set-up and query, 0.000s<br>
</span><span title="msOracleSpatialLayerOpen called with: GEOM
FROM IMIS_GEO.TRAPKT_16386 USING NONE (Layer pointer 0x14dbad0)">msOracleSpatialLayerOpen
called with: GEOM FROM USING IMIS_GEO.TRAPKT_16386 NONE (Layer
pointer 0x14dbad0)<br>
</span><span title="msOracleSpatialLayerOpen.">msOracleSpatialLayerOpen.
</span><span title="Shared connection not available.">Shared
connection not available. </span><span title="Creating one.">Creating
one.<br>
</span><span
title="msConnPoolRegister(test,imis_geo/xxxxx@IMISXENT,0x1523f50)">msConnPoolRegister
(test, imis_geo / xxxxx @ IMISXENT, 0x1523f50)<br>
</span><span title="msOracleSpatialLayerFreeItemInfo was called.">msOracleSpatialLayerFreeItemInfo
was called.<br>
</span><span title="msOracleSpatialLayerWhichShapes was called.">msOracleSpatialLayerWhichShapes
was called.<br>
</span><span title="msOracleSpatialLayerWhichShapes.">msOracleSpatialLayerWhichShapes.
</span><span title="Using this Sql to retrieve the data: SELECT
rownum, GEOM FROM IMIS_GEO.TRAPKT_16386">Using this Sql to
retrieve the data: SELECT rownum, GEOM FROM
IMIS_GEO.TRAPKT_16386<br>
</span><span title="msOracleSpatialLayerWhichShapes.">msOracleSpatialLayerWhichShapes.
</span><span title="Bind values: srid:-1 minx:-90.000000
miny:-90.000000 maxx:90.000000 maxy:90.000000">Bind values:
srid: -1 minx: -90.000000 miny: -90.000000 maxx: 90.000000 maxy:
90.000000<br>
</span><span title="msOracleSpatialLayerWhichShapes getting
ordinate definition.">msOracleSpatialLayerWhichShapes getting
ordinate definition.<br>
</span><span title="msOracleSpatialLayerWhichShapes converting to
OCIColl.">msOracleSpatialLayerWhichShapes converting to OCIColl.<br>
</span><span title="msOracleSpatialLayerWhichShapes bind by name
and object.">msOracleSpatialLayerWhichShapes bind by name and
object.<br>
</span><span title="msOracleSpatialLayerWhichShapes name and
object now bound.">msOracleSpatialLayerWhichShapes name and
object now bound.<br>
</span><span title="msOracleSpatialLayerNextShape on layer
0x14dbad0, row_num: 0">msOracleSpatialLayerNextShape on layer
0x14dbad0 row_num,: 0<br>
</span><span title="Speicherzugriffsfehler">Segfaulting<br>
<br>
</span><span title="Mein Mapfile:"><b>My mapfile:</b><br>
</span><span title="...">...<br>
</span><span title="LAYER">LAYER<br>
</span><span title="NAME "test"">NAME "test"<br>
</span><span title="TYPE POINT">TYPE POINT<br>
</span><span title="STATUS ON">STATUS ON<br>
</span><span title="CONNECTIONTYPE oraclespatial">CONNECTIONTYPE
oraclespatial<br>
</span><span title="CONNECTION
"imis_geo/xxxxxxx@IMISXENT"">CONNECTION "imis_geo /
xxxxxxx @ IMISXENT"<br>
</span><span title="DATA "GEOM FROM
IMIS_GEO.TRAPKT_16386 USING NONE"">DATA "GEOM FROM USING
IMIS_GEO.TRAPKT_16386 NONE"<br>
</span><span title="#CONNECTIONTYPE OGR"># CONNECTIONTYPE
OGR<br>
</span><span title="#CONNECTION
"OCI:imis_geo/xxxxxx@IMISXENT:imis_geo.TRAPKT_16386"">#
CONNECTION "OCI: imis_geo / xxxxxx @ IMISXENT:
imis_geo.TRAPKT_16386"<br>
</span><span title="#DATA
"IMIS_GEO.TRAPKT_16386""># DATA
"IMIS_GEO.TRAPKT_16386"<br>
<br>
</span><span title="PROJECTION">PROJECTION<br>
</span><span title=""init=epsg:4326"">"Init
= epsg: 4326"<br>
</span><span title="END">END<br>
</span><span title="...">...<br>
<br>
</span><span title="Wenn ich den Connectiontype OGR verwende
erhalte ich einen anderen Fehler:">When I use the Connectiontype
OGR I get a <b>different error</b>:<br>
</span><span title="shp2img -m ./oracle.map -i png -o ./output.png
-s 500 500 -all_debug 5 -l test"><br>
shp2img-m. / png oracle.map-i-o. / output.png s 500-500-5-l test
all_debug<br>
</span><span title="msLoadMap(): 0.020s">msLoadMap (): 0.020s<br>
</span><span title="msDrawMap(): rendering using outputformat
named png (AGG/PNG).">msDrawMap (): rendering using outputFormat
named png (AGG / PNG).<br>
</span><span title="msDrawMap(): WMS/WFS set-up and query, 0.000s">msDrawMap
(): WMS / WFS set-up and query, 0.000s<br>
</span><span
title="msOGRFileOpen(OCI:imis_geo/xxxxx@IMISXENT:imis_geo.TRAPKT_16386)...">msOGRFileOpen
(OCI: imis_geo / xxxxx @ IMISXENT: imis_geo.TRAPKT_16386) ...<br>
</span><span
title="OGROPen(OCI:imis_geo/xxxxx@IMISXENT:imis_geo.TRAPKT_16386)">OGROPen
(OCI: imis_geo / xxxxx @ IMISXENT: imis_geo.TRAPKT_16386)<br>
</span><span
title="msConnPoolRegister(test,OCI:imis_geo/xxxxx@IMISXENT:imis_geo.TRAPKT_16386,0x1c09c40)">(test,
OCI: imis_geo / xxxxx @ IMISXENT: imis_geo.TRAPKT_16386,
0x1c09c40) msConnPoolRegister<br>
</span><span title="msOGRFileWhichShapes: Setting spatial filter
to -90.000000 -90.000000 90.000000 90.000000">msOGRFileWhichShapes:
Setting spatial filter to -90.000000 -90.000000 90.000000
90.000000<br>
</span><span title="msOGRFileNextShape: Returning shape=0, tile=0">msOGRFileNextShape:
Returning shape tile = 0, = 0<br>
</span><span title="msOGRFileNextShape: Returning shape=1, tile=0">msOGRFileNextShape:
Returning shape tile = 1, = 0<br>
</span><span title="msOGRFileNextShape: Returning shape=2, tile=0">msOGRFileNextShape:
Returning shape tile = 2, = 0<br>
</span><span title="msOGRFileNextShape: Returning shape=3, tile=0">msOGRFileNextShape:
Returning shape tile = 3, = 0<br>
</span><span title="msOGRFileNextShape: Returning shape=4, tile=0">msOGRFileNextShape:
Returning shape tile = 4, = 0<br>
</span><span title="msOGRFileNextShape: Returning shape=5, tile=0">msOGRFileNextShape:
Returning shape tile = 5, = 0<br>
</span><span title="msOGRFileNextShape: Returning shape=6, tile=0">msOGRFileNextShape:
Returning shape tile = 6, = 0<br>
</span><span title="msOGRFileNextShape(): OGR error.">msOGRFileNextShape
(): OGR error. </span><span title="ORA-29902: Fehler bei der
Ausfuhrung von Routine ODCIIndexStart()">ORA-29902: error during
execution of routine ODCIIndexStart ()<br>
</span><span title="ORA-13208: Interner Fehler beim Auswerten von
Operator [window SRID does not match layer SRID]">ORA-13208:
Internal error when parsing operator [window SRID does not match
layer SRID]<br>
</span><span title="ORA-06512: in
"MDSYS.SDO_INDEX_METHOD_10I", Zeile 333">ORA-06512: at
"MDSYS.SDO_INDEX_METHOD_10I", line 333<br>
in SELECT COUNT(*) FROM imis_geo.TRAPKT_16386 WHERE
sdo_filter(GEOM,
MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-90.00000000000001,-90.00000000000001,90.00000000000001,-90.00000000000001,90.00000000000001,90.00000000000001,-90.00000000000001,90.00000000000001,-90.00000000000001,-90.00000000000001)),
'querytype=window') = 'TRUE' </span><span
title="'querytype=window') = 'TRUE'"><br>
</span><span
title="msOGRLayerClose(OCI:imis_geo/UdvdW0ee@IMISXENT:imis_geo.TRAPKT_16386).">msOGRLayerClose
(OCI: @ imis_geo/xxxxIMISXENT: imis_geo.TRAPKT_16386).<br>
</span><span
title="msOGRFileClose(OCI:imis_geo/xxxxx@IMISXENT:imis_geo.TRAPKT_16386,0).">msOGRFileClose
(OCI: imis_geo / xxxxx @ IMISXENT: imis_geo.TRAPKT_16386, 0).<br>
</span><span
title="msConnPoolRelease(test,OCI:imis_geo/xxxxx@IMISXENT:imis_geo.TRAPKT_16386,0x1c09c40)">msConnPoolRelease
(test, OCI: imis_geo / xxxxx @ IMISXENT: imis_geo.TRAPKT_16386,
0x1c09c40)<br>
</span><span
title="msConnPoolClose(OCI:imis_geo/xxxxx@IMISXENT:imis_geo.TRAPKT_16386,0x1c09c40)">msConnPoolClose
(OCI: imis_geo / xxxxx @ IMISXENT: imis_geo.TRAPKT_16386,
0x1c09c40)<br>
</span><span title="msDrawMap(): Image handling error.">msDrawMap
(): Image handling error. </span><span title="Failed to draw
layer named 'test'.">Failed to draw layer named 'test'.<br>
</span><span title="msDrawMap(): Image handling error.">msDrawMap
(): Image handling error. </span><span title="Failed to draw
layer named 'test'.">Failed to draw layer named 'test'. </span><span
title="<br>"><br><br>
</span><span title="msOGRFileNextShape(): OGR error.">msOGRFileNextShape
(): OGR error. </span><span title="ORA-29902: Fehler bei der
Ausfuhrung von Routine ODCIIndexStart()">ORA-29902: error during
execution of routine ODCIIndexStart ()<br>
</span><span title="ORA-13208: Interner Fehler beim Auswerten von
Operator [window SRID does not match layer SRID]">ORA-13208:
Internal error when parsing operator [window SRID does not match
layer SRID]<br>
</span><span title="ORA-06512: in
"MDSYS.SDO_INDEX_METHOD_10I", Zeile 333">ORA-06512: at
"MDSYS.SDO_INDEX_METHOD_10I", line 333<br>
in SELECT COUNT(*) FROM imis_geo.TRAPKT_16386 WHERE
sdo_filter(GEOM,
MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-90.00000000000001,-90.00000000000001,90.00000000000001,-90.00000000000001,90.00000000000001,90.00000000000001,-90.00000000000001,90.00000000000001,-90.00000000000001,-90.00000000000001)),
'querytype=window') = 'TRUE' <br></span><span
title="'querytype=window') = 'TRUE' <br>"><br>
</span><span title="msFreeMap(): freeing map at 0x1bbb400.">msFreeMap
(): freeing map at 0x1bbb400.<br>
</span><span title="freeLayer(): freeing layer at 0x1bc3ad0.">free
layer (): freeing layer at 0x1bc3ad0.<br>
</span><span title="freeLayer(): freeing layer at 0x1bc56d0.">free
layer (): freeing layer at 0x1bc56d0.<br>
<br>
</span><span title="So weit ich es sehe, liegt das Problem am
fehlenden SRID (null anstatt 4326)">As far as I see it, the
problem is the lack of SRID (zero instead of 4326)<br>
<br>
<br>
</span><span title="Die Daten aus der Datenbank:"><b>The data from
the database:</b><br>
</span><span title="ogrinfo
OCI:imis/xxxxx@imisxent:IMIS_GEO.TRAPKT_16386 -al -ro">ogrinfo
OCI: imis / xxxxx @ imisxent: IMIS_GEO.TRAPKT_16386 -al -ro<br>
<br>
</span><span title="INFO: Open of
`OCI:imis/xxxxx@imisxent:IMIS_GEO.TRAPKT_16386'">INFO: Open of
`OCI: imis / xxxxx @ imisxent: IMIS_GEO.TRAPKT_16386 '<br>
</span><span title="using driver `OCI' successful.">using
driver `OCI 'successful.<br>
<br>
</span><span title="Layer name: IMIS_GEO.TRAPKT_16386">Layer name:
IMIS_GEO.TRAPKT_16386<br>
</span><span title="Geometry: 3D Unknown (any)">Geometry: 3D
Unknown (any)<br>
</span><span title="Feature Count: 7">Feature Count: 7<br>
</span><span title="Extent: (8.000000, 50.000000) - (16.000000,
56.000000)">Extent: (8.000000, 50.000000) - (16.000000,
56.000000)<br>
</span><span title="Layer SRS WKT:">Layer SRS WKT:<br>
</span><span title="GEOGCS["WGS 84",">GEOGCS ["WGS 84",<br>
</span><span title="DATUM["World Geodetic System 1984
(EPSG ID 6326)",">DATUM ["World Geodetic System 1984 (EPSG
ID 6326)",<br>
</span><span title="SPHEROID["WGS 84 (EPSG ID
7030)",6378137.0,298.257223563]],">SPHEROID ["WGS 84 (EPSG
ID 7030)", 6378137.0,298.257223563]]<br>
</span><span title="PRIMEM["Greenwich",0.000000],">PRIMEM
["Greenwich", 0.000000],<br>
</span><span title="UNIT["Decimal
Degree",0.0174532925199433],">UNIT ["Decimal Degree",
0.0174532925199433],<br>
</span><span title="AUTHORITY["EPSG. See 3D CRS for
original information source.","4326"]]">AUTHORITY
["EPSG. See 3D CRS for original information source.", "4326"]]<br>
</span><span title="Geometry Column = GEOM">Geometry Column = GEOM<br>
</span><span title="ID: Real (0.0)">ID: Real (0.0)<br>
</span><span title="TRAJEKTORIE: Real (0.0)">Trajectory: Real
(0.0)<br>
</span><span title="AUSGANGSZEIT: Date (0.0)">STARTING TIME: Date
(0.0)<br>
</span><span title="STUNDEN: Real (0.0)">HOURS: Real (0.0)<br>
</span><span title="AUSGANGSHOEHE: Real (0.0)">OUTPUT HEIGHT: Real
(0.0)<br>
</span><span title="HOEHE: Real (0.0)">HEIGHT: Real (0.0)<br>
</span><span title="OGRFeature(IMIS_GEO.TRAPKT_16386):0">OGRFeature
(IMIS_GEO.TRAPKT_16386): 0<br>
</span><span title="ID (Real) = 1">ID (Real) = 1<br>
</span><span title="TRAJEKTORIE (Real) = 1">Trajectory (Real)
= 1<br>
</span><span title="AUSGANGSZEIT (Date) = 2012/10/17">TIME OUT
(Date) = 17/10/2012<br>
</span><span title="STUNDEN (Real) = 0">HOURS (Real) = 0<br>
</span><span title="AUSGANGSHOEHE (Real) = 632">OUTPUT HEIGHT
(Real) = 632<br>
</span><span title="HOEHE (Real) = 632">HEIGHT (Real) = 632<br>
</span><span title="POINT (8.73333 50.11667 0)">POINT (8.73333
50.11667 0)<br>
<br>
</span><span title="OGRFeature(IMIS_GEO.TRAPKT_16386):1">OGRFeature
(IMIS_GEO.TRAPKT_16386): 1<br>
</span><span title="ID (Real) = 2">ID (Real) = 2<br>
</span><span title="TRAJEKTORIE (Real) = 1">Trajectory (Real)
= 1<br>
</span><span title="AUSGANGSZEIT (Date) = 2012/10/17">TIME OUT
(Date) = 17/10/2012<br>
</span><span title="STUNDEN (Real) = 12">HOURS (Real) = 12<br>
</span><span title="AUSGANGSHOEHE (Real) = 632">OUTPUT HEIGHT
(Real) = 632<br>
</span><span title="HOEHE (Real) = 584">HEIGHT (Real) = 584<br>
</span><span title="POINT (12.7 56.15 0)">POINT (12.7 56.15 0)<br>
<br>
</span><span title="OGRFeature(IMIS_GEO.TRAPKT_16386):2">OGRFeature
(IMIS_GEO.TRAPKT_16386): 2<br>
</span><span title="ID (Real) = 3">ID (Real) = 3<br>
</span><span title="TRAJEKTORIE (Real) = 2">Trajectory (Real)
= 2<br>
</span><span title="AUSGANGSZEIT (Date) = 2012/10/17">TIME OUT
(Date) = 17/10/2012<br>
</span><span title="STUNDEN (Real) = 0">HOURS (Real) = 0<br>
</span><span title="AUSGANGSHOEHE (Real) = 1632">OUTPUT HEIGHT
(Real) = 1632<br>
</span><span title="HOEHE (Real) = 1632">HEIGHT (Real) = 1632<br>
</span><span title="POINT (8.73333 50.11667 0)">POINT (8.73333
50.11667 0)<br>
<br>
</span><span title="OGRFeature(IMIS_GEO.TRAPKT_16386):3">OGRFeature
(IMIS_GEO.TRAPKT_16386): 3<br>
</span><span title="ID (Real) = 4">ID (Real) = 4<br>
</span><span title="TRAJEKTORIE (Real) = 2">Trajectory (Real)
= 2<br>
</span><span title="AUSGANGSZEIT (Date) = 2012/10/17">TIME OUT
(Date) = 17/10/2012<br>
</span><span title="STUNDEN (Real) = 12">HOURS (Real) = 12<br>
</span><span title="AUSGANGSHOEHE (Real) = 1632">OUTPUT HEIGHT
(Real) = 1632<br>
</span><span title="HOEHE (Real) = 1400">HEIGHT (Real) = 1400<br>
</span><span title="POINT (15.6 54.0 0)">POINT (15.6 54.0 0)<br>
<br>
</span><span title="OGRFeature(IMIS_GEO.TRAPKT_16386):4">OGRFeature
(IMIS_GEO.TRAPKT_16386): 4<br>
</span><span title="ID (Real) = 5">ID (Real) = 5<br>
</span><span title="TRAJEKTORIE (Real) = 3">Trajectory (Real)
= 3<br>
</span><span title="AUSGANGSZEIT (Date) = 2012/10/17">TIME OUT
(Date) = 17/10/2012<br>
</span><span title="STUNDEN (Real) = 0">HOURS (Real) = 0<br>
</span><span title="AUSGANGSHOEHE (Real) = 3132">OUTPUT HEIGHT
(Real) = 3132<br>
</span><span title="HOEHE (Real) = 3132">HEIGHT (Real) = 3132<br>
</span><span title="POINT (8.73333 50.11667 0)">POINT (8.73333
50.11667 0)<br>
<br>
</span><span title="OGRFeature(IMIS_GEO.TRAPKT_16386):5">OGRFeature
(IMIS_GEO.TRAPKT_16386): 5<br>
</span><span title="ID (Real) = 6">ID (Real) = 6<br>
</span><span title="TRAJEKTORIE (Real) = 3">Trajectory (Real)
= 3<br>
</span><span title="AUSGANGSZEIT (Date) = 2012/10/17">TIME OUT
(Date) = 17/10/2012<br>
</span><span title="STUNDEN (Real) = 12">HOURS (Real) = 12<br>
</span><span title="AUSGANGSHOEHE (Real) = 3132">OUTPUT HEIGHT
(Real) = 3132<br>
</span><span title="HOEHE (Real) = 3036">HEIGHT (Real) = 3036<br>
</span><span title="POINT (16.86667 53.7 0)">POINT (16.86667
53.7 0)<br>
<br>
</span><span title="OGRFeature(IMIS_GEO.TRAPKT_16386):6">OGRFeature
(IMIS_GEO.TRAPKT_16386): 6<br>
</span><span title="ID (Real) = 7">ID (Real) = 7<br>
</span><span title="TRAJEKTORIE (Real) = 4">Trajectory (Real)
= 4<br>
</span><span title="AUSGANGSZEIT (Date) = 2012/10/17">TIME OUT
(Date) = 17/10/2012<br>
</span><span title="STUNDEN (Real) = 0">HOURS (Real) = 0<br>
</span><span title="AUSGANGSHOEHE (Real) = 5132">OUTPUT HEIGHT
(Real) = 5132<br>
</span><span title="HOEHE (Real) = 5132">HEIGHT (Real) = 5132<br>
</span><span title="POINT (8.73333 50.11667 0)">POINT (8.73333
50.11667 0)<br>
<br>
May anybody help me?<br>
<br>
Regards,<br>
<br>
Stefan<br>
</span></span>
<pre class="moz-signature" cols="72">--
Mit freundlichen Grüßen
Stefan Schantz
</pre>
</body>
</html>