Problem when I try to compress the geodatabase

Question

Hi, please some help, I can't compress the enterprise geodatabase,

Executing: Compress "C:\ConexionesSDE\SDE@sgtc - PRODUCCION.sde"

Start Time: Mon Mar 25 08:54:41 2019

ERROR 999999: Error executing function.

Underlying DBMS error [ORA-29876: fallo al ejecutar la rutina ODCIINDEXDELETE

ORA-00600: código de error interno, argumentos: [kcbzwfcro_2], [353594], [1], [32768], [8], [], [], [], [], [], [], []

ORA-06512: en "SYS.DBMS_SQL", línea 1825

ORA-06512: en "SDE.SPX_UTIL", línea 2081

ORA-06512: en "SDE.ST_DOMAIN_METHODS", línea 2253

] [SDE.DEFAULT]

Failed to execute (Compress).

Failed at Mon Mar 25 09:00:12 2019 (Elapsed Time: 5 minutes 30 seconds)

Some help please!!

TeresaVillena · Answer

The problem was solved, with the  content of the Direct Connect log, the problem was a lock state.

Thanks for your help, regards,

Teresa

TINAMORGAN · Answer

Right, per Asrujit's comment in reference to the other question, I was going to ask what versions you are using?

Version of Enterprise Gdb being compressed?

Version of ArcDesktop being used to run the compress?

Also, when was your last successful compress (if ever)?

Asrujit_SenGupta · Answer

Similar post on GeoNet: https://community.esri.com/thread/194772-ora-29876-while-trying-to-compress-geodatabase-in-oracle

Also check the content of the Direct Connect log file for any more details available..