version difference

2738
9
08-16-2017 08:37 AM
Naveen_KMahato
New Contributor II

I have 500+ versions in my production GIS database. As a regular maintenance, I need to run the version difference tool to check what versions are posted and what are not and generate a report every month so the posted versions (those with no edits in it) can be deleted safely. Using version difference tool in ArcMap is tedious work. Does anyone know if a geoprocess tool is available which can be used as script or model builder tool to automate this process? If this does not exist, if anyone can suggest a workaround to script/automate this, it will be highly appreciated. 

Thank you.

0 Kudos
9 Replies
JoeBorgione
MVP Emeritus

I have 500+ versions in my production GIS database...

Holy smokes!  That's a whole lot of reconciling and posting.  If I may ask, why so many versions in a production database?

That should just about do it....
Naveen_KMahato
New Contributor II

Because users not always delete their versions after posting them. and they keep stacking up. that is why need a way to identify which versions are posted. 

Thanks!

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

Automate the process, so that even if the users don't....it will automatically Reconcile\Post\Delete the versions unless there is conflicts at the end of the day\week.

Naveen_KMahato
New Contributor II

I cannot automate the Reconcile/post/delete or any of these because of the workflow the business has adopted. Even though as an admin, I can just recommend but cannot post or delete the versions. 

0 Kudos
JoeBorgione
MVP Emeritus

I see.  When I first started in the SDE/versioned environment, I had a dozen or so versions; one for each user.  That got out of hand in a hurray as I was forced to make the decision on which way to resolve conflicts; if I reconciled and posted user A's version, I might get a conflict sometime later when reconciling and posting user J's version.  That lasted about 6 months and was back in the SDE 8.x days.  Since then I've only had sde.default and one 'edits' version.

That should just about do it....
Asrujit_SenGupta
MVP Regular Contributor

Giving the scenario a second thought, the "Reconcile Versions" tool should do the needed for you.

If you select the options of 'Abort if Conflict Detected' and 'Delete Version after post" combo, then only those versions will be deleted which have been Reconciled\Posted successfully to the Target Version selected (this part is IMPORTANT to consider) and do not have a child version of their own.

So, if you kind off just need a Report or the log details, it will have something like below in case of a conflict:

Naveen_KMahato
New Contributor II

Thanks Asrujit.

I did review the links you suggested and I have been though most of them already. In fact tried the python script to extract edits before reconcile/post but the problem with that script is that it fails with larger feature classes with a memory error. I am looking into how I can use the reconcile gptool as you have suggested. Again, I cannot post or delete the version nor even reconcile them without user's consent. 

0 Kudos
Naveen_KMahato
New Contributor II

I am trying this option but not sure how would it tell if there are any edits in the version. There can be some edits but still no conflicts  against the default.

0 Kudos