[mapserver-users] OCI-22053: overflow error with CONNECTIONTYPEoraclespatial

[Stefan Schantz]

Hi Tim,
with Georaptor I could draw all the point from the table without any 
error messages. But if I use the geom-validator, I get an error 
"ORA-13000: dimension number is out of range". After I corrected the 
dimension number, the error message from the UMN disappeared.
Thank you!
Stefan

Nolte, Tim schrieb:
> Stefan,
>
> Do you have the Georaptor extension installed in SQL Dev? Have you tried to run the verification on all of the geom data in that table?
>
> - Tim
>
> ----
> Timothy J Nolte - tnolte at ilpcs.com
> Network Planning Engineer
>
> 4717 Broadmoor Ave, Suite G
> Kentwood, MI 49512
>
> Office:  616-656-5163
> PCS:     616-706-2438
> Support: 616-929-0289
> Fax:     616-554-6484
>
>
> -----Original Message-----
> From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Stefan Schantz
> Sent: Wednesday, February 03, 2010 7:55 AM
> To: mapserver-users at lists.osgeo.org
> Subject: [mapserver-users] OCI-22053: overflow error with CONNECTIONTYPEoraclespatial
>
> Hello,
> I am trying to visualize some points from a oracle database (10.2) :
> I am using
> MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP 
> OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV 
> SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER 
> SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=GEOS INPUT=EPPL7 
> INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
>
> My layer description is
> ----
> LAYER
>   NAME "tra_punkte"
>   TYPE POINT
>   STATUS ON
>   DEBUG ON
>   #DUMP TRUE
>   CONNECTIONTYPE oraclespatial
>   CONNECTION 
> "***/***@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT= 
> 1521)))(CONNECT_DATA=(SID=***)))"
>   DATA "GEOM
>         from
>             (select geom, HOEHE, AUSGANGSHOEHE, ID
>             FROM imis_geo.trapkt_6222
>             )
>         USING UNIQUE ID SRID 4326"
> -------
>
> and the following statement is written in the log-file
> ------
> [Wed Feb  3 12:54:00 2010].603594 msOracleSpatialLayerWhichShapes. Using 
> this Sql to retrieve the data: SELECT ID, GEOM FROM (select geom, HOEHE, 
> AUSGANGSHOEHE, ID
>             FROM imis_geo.trapkt_6222
>             ) WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, 4326, 
> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-70.5721827,29.3243683,69.9787827,79.1709317) 
> ),'querytype=window') = 'TRUE'
> [Wed Feb  3 12:54:00 2010].823525 osGetOrdinates(): OracleSpatial error. 
> OCI-22053: overflow error
> ------
>
> But if I try the sql in SQL-Developer, i get the result without any errors?
>
> The connection between UMN and oracle database is working fine in 
> several different layers, but not in this one. Is there anything I can do?
>
> Best Regards,
> Stefan
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>