AnsweredAssumed Answered

version reconcile error

Question asked by sibghatullah86 on Apr 17, 2016
Latest reply on Jul 5, 2016 by ppapadopoulosmarathondata-gr-esridist

Like • Show 0 Likes0
Comment • 5

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.

No one else has this question

Outcomes

5 Replies

asengupta-esristaff Apr 17, 2016 11:43 AM
Mark Correct
Correct Answer
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.
Like • Show 0 Likes0
Actions
- sibghatullah86 @ asengupta-esristaff on Apr 17, 2016 8:27 PM
  Mark Correct
  Correct Answer
  Dear Asrujit,
  
  No i haven't added any field in version data.One thing i came to know is that our GIS administrator have updated arcgis 10.3 to 10.4.
  Like • Show 0 Likes0
  Actions
sibghatullah86 Apr 30, 2016 8:48 PM
Mark Correct
Correct Answer
Any suggestions to resolve this error?
Like • Show 0 Likes0
Actions
Alexander_Brown-esristaff Jun 28, 2016 11:06 AM
Mark Correct
Correct Answer
Sibghat,

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”.
1. Make a copy of your original parent version feature class (with the data that was not updated) in the same database, call it "_backup" at the end of the name.
  Use arcpy.TruncateTable_management() to truncate your original feature class. This will delete all your data in the feature class (why step one is essential in backing up your original Parent version content).
  Utilize arcpy.Append_management() to load the data from your child version (Dataset_xxx_child_edits) backup to the parent feature class.
  Append will indicate if you have a schema issue, you will not be able to append the new data if there was a schema change.
  If this runs successfully, you have applied your new edited data changes to the original parent. Check this manually (geometries, attributes).
  If this tool runs unsuccessfully without a schema issue, please post.
  After verification that new data is in original parent feature class
  Delete your child backup (Dataset_xxx_child_edits).
  Delete your copied original parent dataset "_backup"
  Create a new child version of your geodatabase.
Please post any follow up information or questions.

Regards,

Alex
1 person found this helpful
Like • Show 1 Like1
Actions
ppapadopoulosmarathondata-gr-esridist Jul 5, 2016 1:46 AM
Mark Correct
Correct Answer
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.
1 person found this helpful
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

version reconcile error

Outcomes

Related Content

Recommended Content