I have one Edit child version and one default parent SDE version. when i try to reconcile from Edit version to SDE default version attached error is coming.I am using arcgis 10.4 and Oracle
The edit version data has almost 20 thousand records.Please help me in reconciling to Default SDE parent.
Did you by any chance add fields from the database end, one of them named 'TYPE', for that Feature Class in the error message?
If yes, A and D tables are not aware of these new columns since they were added from database side.
You can always try to export your child version feature class to a file geodatabase; this will ensure you have a copy of your 20,000 edits. Name the export something obvious (Dataset_xxx_child_edits).
Is this the only feature class you have edits in? If there are additional feature classes, then you might want to back them up as well.
Now, if there are hundreds or more feature classes with edits in them, please let me know before continuing with this suggestion:
I would recommend trying:
After you have backed up all your edits, delete your child version. Compress your database to ensure it returns state “0”.
Please post any follow up information or questions.
Try to Run Diagnose Version Metadata and Diagnose Version Tables in order to identify inconsistencies in the delta (A and D) tables of a versioned geodatabase or inconsistencies within the system tables used to manage versions and states in a versioned geodatabase.
If any errors arise try to run Repair Version Metadata and Repair Version Tables.