ArcGIS Desktop 9.1 Reconcile and Post Patch

Custom reconcile and post applications written using ArcObjects are vulnerable to a defect that can create duplicate rows within a versioned table when a second session attempts to reconcile against the same version before the first process has exited (committed). This defect has been identified as being responsible for incidents where customers have experienced problems in opening geometric networks.

Esri announces the ArcGIS Desktop 9.1 Reconcile and Post Patch. We recommend that all ArcFM customers and all customers working with versioned databases and running applications that perform custom Reconcile and Post install this patch at their earliest convenience. It deals specifically with the issues listed below under Issues Addressed with this Patch.

IMPORTANT NOTE: The server side patch to address this behavior is now available as an SDE patch ArcSDE 9.1 Reconcile and Post Patch and will protect the geodatabase from desktop clients which have not installed the ArcGIS Desktop patch.

• NIM007147 - Using custom ArcObjects to reconcile/post within an edit operation may cause data inconsistencies.

Applications that start an Edit Operation, perform a Reconcile and then call Post or Stop Editing without explicitly stopping the Edit Operation are vulnerable to this defect. An example is when the version being reconciled transfers data to the result state, the changes are not committed to the database and a following post operation which relabels the source and target versions to reference the result state is committed. If another session reconciles against the same version during the time window when the data changes have not been committed, the transactional inconsistency can lead to duplicate rows.

{Applications that stop any pending Edit Operations and call Reconcile and Post outside of an edit operation are not vulnerable to this defect. Applications that call Reconcile within an Edit Operation but explicitly stop the Edit Operation before calling Reconcile are not vulnerable to this defect.}

The problem is specific to ArcGIS 9.0, 9.1 with Oracle and has been addressed in ArcGIS 9.2.

This issue can not be encountered when using the out-of-the-box ArcGIS tools.

• Under the C:\Program Files\ArcGIS\Bin folder:
  • SdeFDB.dll

ArcGIS Desktop 9.1 Service Pack 2 must be installed before you can install this Patch.

1. Make sure you have write access to your ArcGIS Desktop installation location, and that no one is using ArcGIS Desktop.
2. Download ArcGIS-91sp2-Reconcile-Patch.exe to a location other than your ArcGIS Desktop installation location.
3. Double-click the setup file to start the install process.
4. When Setup starts, follow the instructions on your screen.

NOTE: If you have installed client setups from a shared Network Administrative ArcGIS Desktop setup, this Patch must be applied to all client installations.

Check Online Support Center periodically for the availability of additional patches. New information about this Patch will be posted here.

To check for the presence of a Patch, for each file examine the unique identification information provided (right click, properties, version tab, item name, QFE Version). With only a few exceptions, all files modified as part of a Patch distribution can be uniquely identified in this manner. The identification string for this Patch should read:

• QFE-DT-91-CQ00304268

Domestic sites, please contact ESRI Technical Support at 1-888-377-4575, if you have any difficulty installing this Patch. International sites, please contact your local ESRI software distributor.

Download ID:1253