issacszc

The problem of Reconcile:ORA-00604, ORA-13236,ORA-29400,ORA-06512

Discussion created by issacszc on Feb 12, 2011
I develop a GIS Edit system in ArcEngine, supporting versioned editing. At present, there are

about 25 versions which inherit from a Parent verion in common. There is a problem of the method

Reconcile4. After calling Reconcile4 and StopEditing??then StartEditing again, the method of

StartEditing return FDO_E_VERSION_UNEDITABLE. The data is lost between last reconcile and this reconcile.

Then I try reconciling in ArcMap, the result is the same as our system.

SDE Log:
S_set_logdata_insert() USER Transaction Logfile INSERT - No Commit on Insert
[Tue Jan 25 14:27:47 2011] [488935] [golden-optest]
db_log_add_user_ids_sql() USER Transaction Logfile INSERT - No Commit on Insert
[Tue Jan 25 14:27:47 2011] [488935] [golden-optest]
db_log_add_user_ids_sql() USER Transaction Logfile INSERT - No Commit on Insert
[Tue Jan 25 14:27:48 2011] [488935] [golden-optest]
db_log_add_user_ids_sql() USER Transaction Logfile INSERT - No Commit on Insert
[Tue Jan 25 14:27:49 2011] [488935] [golden-optest]

Our environment??
Sever??
Operate System?? AS 5.4(64 bit)
Database?? Oracle 10.2.0.3
ArcSDE?? oracle_linux for sde 64bit 9.3.1
ArcSDE Server Build?? for Oracle10g Build 1632 Thu Feb 26 12:05:37 2009

Client??
ArcGIS Engine SDK for CPP 9.3
ArcMap 9.3


After this problem, we upgrade ArcGIS in server and client, environment after upgrading as

follows:
Sever??
Operate System?? AS 5.4(64 bit)
Database?? Oracle 10.2.0.3
ArcSDE?? oracle_linux for sde 64bit 9.3.1 sp2

Client??
ArcMap 9.3.1 sp2


Then I reconcile in ArcMap, the Arcmap pop this clue:
Reconcile against USER_20101015.Parent:An unexpected failure occurred.
Underlying DBMS error[ORA-00604:error occurred at recursive SQL level 1
ORA-13236:internal error in R-tree processing: [reading node(mdrbin_mem_ins_rt)]
ORA-29400:data cartridge error
Error - OCI_NODATA
ORA-06512: at "MDSYS.SDO_IDX", line 142
ORA-06512: at line 1
]

How to solve this problem?

Outcomes