Dear FME community.
I try to integrate data into ORACLE but FME say me : error was `ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
Do you know what does that mean ?
Thanks
Solved
Error with ORACLE integration
+6- Supporter
Best answer by itay
Hi @lalandexavier,
This usually means that the coordinates of the features are within the table tolerance and therefore Oracle rejects the features or cannot create the spatial index.
I suggest changing the tolerance of your table by re creating the tabel's entry in the user_sdo_geom_metadata table or making sure the coordinates are within the acceptable tolerance try the Generalizer transformer.
Hope this helps,
Itay
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.
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.
+19- Supporter
- Best Answer
Hi @lalandexavier,
This usually means that the coordinates of the features are within the table tolerance and therefore Oracle rejects the features or cannot create the spatial index.
I suggest changing the tolerance of your table by re creating the tabel's entry in the user_sdo_geom_metadata table or making sure the coordinates are within the acceptable tolerance try the Generalizer transformer.
Hope this helps,
Itay
+6- Supporter
What happens if you try inserting a GeometryRefiner just before the writer?
That doesn't work better with the GeometryRefiner
+6- Supporter
Hi @lalandexavier,
This usually means that the coordinates of the features are within the table tolerance and therefore Oracle rejects the features or cannot create the spatial index.
I suggest changing the tolerance of your table by re creating the tabel's entry in the user_sdo_geom_metadata table or making sure the coordinates are within the acceptable tolerance try the Generalizer transformer.
Hope this helps,
Itay
Thank you great !
This is my request :
DELETE FROM user_sdo_geom_metadata WHERE TABLE_NAME = 'MYTABLE';
INSERT INTO user_sdo_geom_metadata (TABLE_NAME,COLUMN_NAME,DIMINFO,SRID) VALUES ('EDTG_BATI_PARKING','GEOMETRY',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',-2147483648,2147483647,5E-5),MDSYS.SDO_DIM_ELEMENT('y',-2147483648,2147483647,5E-5),MDSYS.SDO_DIM_ELEMENT('z',-2147483648,2147483647,5E-5)),2154);
DROP INDEX EDTG_BATI_PARKING_ARCH_GMIDX;
CREATE INDEX EDTG_BATI_PARKING_ARCH_GMIDX ON EDTG_BATI_PARKING
(GEOMETRY)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
NOPARALLEL;