I have a problem with import data with fme and arcsde.
I have a loop of import data in the same arcsde table.
I have a problem with index :
Error while executing stream insert operation for table
'VLORA1A.TEST'.:SDE_ERROR_CODE(-51) Underlying DBMS error.
SDE_EXT_ERROR(29861) SDE_ERROR_MSG1(ORA-29861: l'index de domaine est
à l'état LOADING/FAILED/UNUSABLE ) SDE_EXT_ERROR_MSG2()
I drop the index and i register the table with sdelayer.
I think FME alter the spatial index.
Have you a solution ?
Thanks
Best Answer
The documentation for that error - http://ora-29861.ora-code.com/ states:
So you have a bad spatial index.
Your question isn't clear, however you can specify whether or not FME alters the spatial index in the Oracle writer properties.
You can use SQL to
REBUILD
the index after the fact using the Advanced Oracle writer parameter SQL statement to execute after Translation. (although the index is updated with updates and insertions so this may not be necessary).You could also
DROP
the index prior to the transaction using the SQL statement to execute before translation parameter.