topic Re: Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT in Data Management Questions

Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT rout

EmadAl-Mousa — Sun, 05 Feb 2012 02:27:56 GMT

Hi,

i have a feature class that is versioned with st_geometry storage. when i try to edit it using ArcMap with an Oracle user that has the full editing privileges i receive the following error:

Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-00942: table or view does not exist
ORA-06512: at "SDE.SPX_UTIL", line 925
ORA-06512: at "SDE.SPX_UTIL", line 960
ORA-06512 at "SDE.ST_DOMAIN_METHODS", line 1906

however, when i try editing layer using the "schema owner", i don't receive this error !!! and editing works fine.

My Geodatabase environment is:

DBMS: Oracle 11g R2
ArcSDE Version: ArcSDE 10 SP2
Unix Server: IBM AIX 6.1

The layers are hosted in a "user-schema geodatbase".

Please check the attached error message.

can somebody help?

Thanks,

Re: Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT

mvisekru — Mon, 06 Feb 2012 13:43:03 GMT

Have you checked the SDE schema of the user-schema geodatabase for any invalid objects?

I have come across this issue and resolved it by recompiling the SPX_UTIL package.

Re: Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT

EmadAl-Mousa — Tue, 07 Feb 2012 02:09:18 GMT

Thanks for your feedback.

I did recompile SPX_UTIL package under "SDE" schema, and it recompiled successfully (it was not initially invalid).

However, when i try to put the layer in ArcMap again i receive the following error:

Error: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Regards,

Re: Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT

SelahattinTASPINAR — Mon, 10 Sep 2012 11:34:57 GMT

Hi,

You have some unusable spatial indexes which you can find by executing this SQL:

SQL> SELECT owner,index_name,table_name from all_indexes where domidx_status !='VALID' or domidx_opstatus!='VALID';

Then you should delete and re-create the spatial index if you can.

Otherwise delete the layer and re-create it.

Sincerely