topic Re: Python script to reconcile enterprise database version to default is not working in Python Questions

Python script to reconcile enterprise database version to default is not working

GeorgeJonesRIGOV — Fri, 18 Oct 2024 16:57:10 GMT

Hi all, I'm trying to reconcile a checked out enterprise database to the default database version. Here is the code I have so far but does not work.

import arcpy
from arcpy import env
arcpy.env.overwriteOutput = True
arcpy.env.workspace =r'S:\PW\GIS\Map Requests\2023_07_YardWasteAprxProjectAndRefuseRoutes\xxxxxx03_PW_Edit.sde'
arcpy.ReconcileVersions_management (arcpy.env.workspace, "ALL_VERSIONS", "DBO.DEFAULT", "versionlist", "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_EDIT_VERSION", "POST", "KEEP_VERSION", "reconcileLog")
fc = r'S:\PW\GIS\Map Requests\2023_07_YardWasteAprxProjectAndRefuseRoutes\xyzxyzx.sde\xyzxy.DBO.Routes\xyzxy.DBO.YardWasteRoutesBest2024'
arcpy.management.MakeFeatureLayer(fc, 'YardWasteStops','','')
arcpy.ChangeVersion_management('YardWasteStops','TRANSACTIONAL', 'DBO.xxEdit','')
arcpy.conversion.FeatureClassToFeatureClass('YardWasteStops',r'S:\xy\GIS\Map Requests\2023_07_YardWasteAprxProjectAndRefuseRoutes\YardwasteAprx.gdb','YardWasteStops')
print('done')

As a result, I keep getting a log file saying "Warning: The reconcile process was not performed. The specified target version (dbo.DEFAULT) has no edit versions to reconcile with". This should not be the case. The dbo.DEFAULT is the parent version and the PW_Edit is the child version of this. I am stumped as why is that the case.

Note i replaced the file path names with xyxyx for privacy.

Re: Python script to reconcile enterprise database version to default is not working

TonyAlmeida — Fri, 18 Oct 2024 21:30:57 GMT

Make sure DBO.PW_Edit exists. Also, make sure that the child version you are attempting to reconcile with DBO.DEFAULT is correct. Try this.

import arcpy # Set workspace to the geodatabase arcpy.env.workspace = r'S:\PW\GIS\Map Requests\2023_07_YardWasteAprxProjectAndRefuseRoutes\xxxxxx03_PW_Edit.sde' arcpy.env.overwriteOutput = True # List all versions to verify the child version exists versions = arcpy.da.ListVersions(arcpy.env.workspace) for version in versions: print(version.name) # Reconcile the child version "PW_Edit" with the parent "DBO.DEFAULT" child_version = "PW_Edit" try: arcpy.ReconcileVersions_management( arcpy.env.workspace, "ALL_VERSIONS", "DBO.DEFAULT", child_version, # Ensure the correct child version name is provided "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_EDIT_VERSION", "POST", "KEEP_VERSION", r'S:\PW\GIS\Map Requests\2023_07_YardWasteAprxProjectAndRefuseRoutes\reconcileLog.txt' # Log file path ) print("Reconciliation successful.") except Exception as e: print(f"Reconciliation failed: {e}") # After reconciliation fc = r'S:\PW\GIS\Map Requests\2023_07_YardWasteAprxProjectAndRefuseRoutes\xyzxyzx.sde\xyzxy.DBO.Routes\xyzxy.DBO.YardWasteRoutesBest2024' arcpy.management.MakeFeatureLayer(fc, 'YardWasteStops', '', '') arcpy.ChangeVersion_management('YardWasteStops', 'TRANSACTIONAL', 'DBO.PW_Edit', '') arcpy.conversion.FeatureClassToFeatureClass( 'YardWasteStops', r'S:\xy\GIS\Map Requests\2023_07_YardWasteAprxProjectAndRefuseRoutes\YardwasteAprx.gdb', 'YardWasteStops' ) print('done')

Re: Python script to reconcile enterprise database version to default is not working

GeorgeJonesRIGOV — Mon, 21 Oct 2024 13:09:50 GMT

thank you ! That worked! Saves me a lot of time.

Re: Python script to reconcile enterprise database version to default is not working

TonyAlmeida — Mon, 28 Oct 2024 14:29:34 GMT

Glad it worked for you!