[Gvsig_english] new problems with an oracle layer

[Juan Lucas Dominguez Rubio]

Hello, Wolfgang.
 
I am assuming that your version of gvSIG is using this Java code:
 
http://subversion.gvsig.org/gvSIG/tags/v1_9_Build_1253/
 
(maybe somebody from OA can confirm this)
 
It's a strange error. According to your log file, there is a geometry in your Oracle Spatial table where the first metadata component (called SDO_GTYPE) is NULL, which is not listed as a valid value in Oracle Spatial documentation:
 
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96630/sdo_objrelschema.htm#i1004087
 
So the only explanation I have is that there is a corrupt geometry in that table.
 
These are two attempts to identify the row that caused the problem:
 
(1) Execute this SQL sentence (the table was PLAN.GRUEN_POLY, no?):
 
select * from PLAN.GRUEN_POLY t where  t.SHAPE.SDO_GTYPE = NULL
 
If that SQL returns one or more rows, you must decide what toi do with it because its geometry is not valid.
 
If that returns no row, try this:
 
(2) Execute these SQL sentences:
 
================
CREATE TABLE validate_results(sdo_rowid ROWID, status VARCHAR2(2000));
BEGIN
SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT('PLAN.GRUEN_POLY', 'SHAPE', 'validate_results');
END;
SELECT * FROM validate_results ORDER BY status;
================
 
And check how many different values (numbers) you have in the 'status' column. Please write the codes and send them to the list.
 
 
 
Regards,
Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_internacional-bounces at listserv.gva.es en nombre de Wolfgang Qual
Enviado el: jue 17/06/2010 14:51
Para: Users and Developers mailing list
Asunto: [Gvsig_english] new problems with an oracle layer



Dear list,

I got an error message while saving an oracle spatial layer as
shapefile. The process of writing the shapefile stopps at a certain
moment and
the error message appears. Logfile attached. I fear that it has to do
with the layer itself, as other layers caused no problem. Nevertheless,
I would be
very happy to know the reason for this. Therefore: all comments are
welcome! ;)

Best,
Wolfgang

ps: gvsig OADE was used on a linux machine

--
Wolfgang Qual

Landeshauptstadt München
Referat für Gesundheit und Umwelt
Umweltschutz, Umweltvorsorge
RGU-UW 11
Team Klimaschutz, Energie

Bayerstraße 28a
80335 München

Telefon:  +49 - 89 - 233 - 4 77 17
Telefax:  +49 - 89 - 233 - 4 77 05
E-Mail:   wolfgang.qual at muenchen.de
Internet: http://www.muenchen.de/rgu

Bitte beachten Sie die Hinweise zur elektronischen
Kommunikation mit der Landeshauptstadt München:
http://www.muenchen.de/ekomm



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100617/ad7e545a/attachment.htm