Question

oracle Query execution error

Forum|Forum|12 years ago
November 20, 2013
3 replies
97 views

+12

farfar
Contributor

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 : []

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

ORA-13234: échec de l'accès à la table d'index R-tree [MDRT 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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

+21

fmelizard
Safer
Forum|Forum|12 years ago
November 20, 2013

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