Skip to main content
  • EN
Hi all,

 

I have this error with executing spatial query with FeatureReader : 

 

2013-11-20 17:11:55| 1.0| 0.0|ERROR |Execution of statement `SELECT "PDL_SIG_GAZ".* FROM ( SELECT * FROM "AMR"."PDL_SIG_GAZ" A WHERE (MDSYS.SDO_RELATE( A.PDL_GEO, :bindingQueryGeom,'mask=ANYINTERACT ') = 'TRUE') ) "PDL_SIG_GAZ" WHERE 1 = 1' did not succeed; error was `ORA-29903: erreur d'exécution de la routine ODCIIndexFetch()

ORA-13236: erreur interne dans le traitement R-tree : e]

ORA-13236: erreur interne dans le traitement R-tree : eSnapshot too old or Recursive fetch error]

ORA-13234: échec de l'accès à la table d'index R-tree RMDRT Table]

ORA-29400: erreur de cartouche de données

ORA-00942: Table ou vue inexistante'. (serverType=`ORACLE8i', serverName=`CEDRE', userName=`AMR', password=`***', dbname=`')

2013-11-20 17:11:55| 1.0| 0.0|ERROR |Execution of statement `%5' did not succeed; error was `%6'. (serverType=`%0', serverName=`%1', userName=`%2', password=`***', dbname=`%4')

2013-11-20 17:11:55| 1.0| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details.

 

 

Any idea ?

 

Thanks an advance.

 

FarFar 

 

 
Hi Farfar,

 

 

I am sure you can find the details of this error online,  from my experience it usually has to do with geometry validation and metedata (or lack of it).

 

Hope this helps,

 

 

Itay
Hi,

 

 

I'm with Itay, this is purely an Oracle error.

 

 

You could try to drop and re-create the spatial index on the table, in case they are corrupt.

 

 

David
Hi David & Itay,

 

Thank you for your help. Effectively, the problem was the spatial index. I drop and re-create it and it works. 

 

 

Farfar

Reply


Community Stats

30,102
Posts
114,261
Replies
37,734
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.