Issues Reconciling and Posting version using Python in ArcGIS Desktop 10

Discussion created by ksendhil on Oct 23, 2012
Latest reply on Oct 24, 2012 by ksendhil

We are running into an issue while reconciling and posting the updated version to the parent (DEFAULT) version, in a script that updates features in a feature class (W_HYDRANT), using Update Cursors.

The script uses two workspaces (.sde connection files) - one for editing the data using the Update Cursor, and the other for Reconciling and Posting the version.  These wokspaces are named inWorkspace and postWorkspace respectively.  The inWorkspace connection file uses the editor credentials, while the postWorkspace uses the Schema Owner credentials (DEFAULT version is protected).  Both versions point to a named version "MX_UPDATES", which is a child of default.

arcpy.ReconcileVersion_management(postWorkspace, editVersion, parentVersion,
                                  "BY_ATTRIBUTE", "FAVOR_EDIT_VERSION",
                                  "LOCK_AQUIRED", "ABORT_CONFLICTS", "NO_POST")

Here is the error message I get:

Traceback (most recent call last):
  File "P:\workareas\dus\repo\programs\python\maximo\Update_Hydrant_from_Maximo.py", line 201, in <module>
  File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\management.py", line 9271, in ReconcileVersion
    raise e
ExecuteError: ERROR 000084: Conflicts detected, aborting the reconcile.
Failed to execute (ReconcileVersion).

I tried other variations with "NO_LOCK_AQUIRED" and "NO_ABORT", and am still unable to Reconcile.

Interestingly, I am able to manually reconcile and post this version without any issues - no conflicts.

I am able to see the updates in the 'A' table.

Key Points:

  • Using ArcGIS Desktop 10, SP5

  • Windows 7, 64-bit OS

  • ArcSDE (ArcGIS Server 9.3) running on Oracle 11g

  • Each Department have their own schema owned GDBS, ours is UTIL_SDE.

  • Default version is protected, so have to use the schema owner credentials to Post to it.

Any help or insights would be greatly appreciated!