topic Re: ListVersions in Geoprocessing Questions

ListVersions

TedCronin — Thu, 17 Jun 2010 00:52:27 GMT

So, is it possible to use ListVersions to list out all the versions as part of a list, have some versions removed from the list, and then proceed to process the list for say a ReconcileVersion_management. It seems like this should work.

import arcpy

versionList = arcpy.ListVersions ('Database Connections\zzzyyyxxx_tcronin@sdemapper@ACR-GIS2@TestServer.sde')

versionList.remove ('dbo.DEFAULT')
versionList.remove ('ACR_FINAL.Master')

for version in versionList:
print version

Printed Shows me:

AVATCHAR.NopeTest
MIHILLIG.Shared_AOI_Michael
ACR_GIS.bk111_Jesusa
ACR_GIS.bk222_Jesusa

If i then un comment reconcile above and then run:

RuntimeError: ERROR 087494: Object: Error in executing tool
File "C:\Documents and Settings\tcronin\Desktop\BatchVersionReconcile.py", line 11, in <module>
arcpy.ReconcileVersion_management (versionList, version, 'ACR_FINAL.Master', "BY_OBJECT", "FAVOR_TARGET_VERSION", "NO_LOCK_AQUIRED", "NO_ABORT", "NO_POST")
File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\management.py", line 9000, in ReconcileVersion
raise e

If I manually run this tool, I can not see all the versions I want to reconcile, it seems like it is sde connection version specific, but a ListVersion does show me everything, so why is that the case. Or should I be running this directly in ArcMap, instead of wing.

Wow, Management.py has 9221 lines of code, thats a lot of writing.;)

Re: ListVersions

RussellBrennan — Sat, 11 Dec 2021 18:47:18 GMT

Hi Ted,

ListVersions should return only what that user has permissions to see. Make sure that you are connecting to the same workspace both when running ListVersions as well as when running reconcile. Try setting the workspace environment at the start of your script.

import arcpy
arcpy.env.workspace = r"Database  Connections\zzzyyyxxx_tcronin@sdemapper@ACR-GIS2@TestServer.sde"
...

I did not see in your script where you referenced reconcile. However in the error message the syntax looks incorrect.

arcpy.ReconcileVersion_management (versionList, version, 'ACR_FINAL.Master', "BY_OBJECT", "FAVOR_TARGET_VERSION", "NO_LOCK_AQUIRED", "NO_ABORT", "NO_POST")

From what I am seeing above you are passing in your versionList where you should be providing a workspace. If you want to run the reconcile for each version you will need to do something like this:

import arcpy
arcpy.env.workspace = r"Database  Connections\zzzyyyxxx_tcronin@sdemapper@ACR-GIS2@TestServer.sde"
workspace = arcpy.env.workspace
versionList = arcpy.ListVersions ()

versionList.remove('dbo.DEFAULT')
versionList.remove('ACR_FINAL.Master')

for version in versionList:
    arcpy.ReconcileVersion_management (workspace, version,  'ACR_FINAL.Master', "BY_OBJECT", "FAVOR_TARGET_VERSION",  "NO_LOCK_AQUIRED", "NO_ABORT", "NO_POST") 
#this is assuming that 'ACR_FINAL.Master is the parent version to all other versions in the list.

Re: ListVersions

TedCronin — Tue, 22 Jun 2010 14:58:32 GMT

I will test this out. I agree I did not attach the reconcile piece. I totally left off the workspace, for whatever reason, perhaps I thought I could jump right in. Maybe this was a total brain fart.

Running this:

import arcpy

arcpy.env.workspace = r"Database Connections\zzzyyyxxx_tcronin@sdemapper@ACR-GIS2@TestServer.sde"

wrksp = arcpy.env.workspace

versionList = arcpy.ListVersions ()

versionList.remove ('dbo.DEFAULT')
versionList.remove ('ACR_FINAL.Master')

for version in versionList:
    print version
    #arcpy.ReconcileVersion_management (wrksp, version, 'ACR_FINAL.Master', "BY_OBJECT", "FAVOR_TARGET_VERSION", "NO_LOCK_AQUIRED", "NO_ABORT", "NO_POST")
    #print version

I am receiving a windows error, so I will play with this a bit more

Re: ListVersions

TedCronin — Thu, 08 Jul 2010 23:48:59 GMT

So, I am trying to run this as a script outside of ArcMap and Editing, so is that even possible, because the more I think, the more I come to realize that when doing reconciles I am in ArcMap and have started editing and not on the outside of both, so it seems like I should be creating a map connection and running a start edit, and then running the reconcile.

Re: ListVersions

RussellBrennan — Fri, 09 Jul 2010 14:03:09 GMT

Ted,

You can run the reconcile outside of an edit session and outside of ArcMap/ArcCatalog. The edit session will taken care of by the tool. Just be sure to choose the appropriate conflict detection method and reconcile option (favor target or favor edit) because the reconcile will be saved when the tool finishes.

Re: ListVersions

TedCronin — Fri, 09 Jul 2010 17:11:37 GMT

This is good to know because I am seeing inconsistent behavior between No Post, and No Locks in py and the doc as well as when a model is exported out with either of these optional check boxes but will revisit next week as I try and ascertain the exact behavior. BTW, the doc does make it seem like I need to be in an edit session.

Re: ListVersions

RussellBrennan — Fri, 09 Jul 2010 17:38:14 GMT

BTW, the doc does make it seem like I need to be in an edit session.

Ted,

Are you referring to this line?
"The reconcile process requires that you are the only user currently editing the version and the only user able to edit the version throughout the reconcile process until you save or post."

In this doc:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//0017000000p9000000.htm

Re: ListVersions

TedCronin — Fri, 09 Jul 2010 18:52:07 GMT

Yep, that first part makes you think you need to be editing, at least it made me think that way.

Re: ListVersions

TedCronin — Mon, 26 Jul 2010 23:42:39 GMT

So basically this runs as expected, in the python window, but for some reason, I do not have list.remove in Wing. This is the issue I am having.

Re: ListVersions

TedCronin — Tue, 27 Jul 2010 00:34:21 GMT

I am having issues with both IDLE and PyWin, too. The only thing I can come up with is I did not choose the default setup, since I do not want py to be uninstalled by ArcGIS, so basically three IDEs don't work, and 1 does (py window).

Re: ListVersions

TedCronin — Wed, 28 Jul 2010 16:03:25 GMT

So, I filed this with Support. I tested the setup with a 2003 Server with the non standard esri setup (the standard python setup), and was successful in completing everything as expected, so now I think it may be related to XP 64. It currently generates a crash with only ListVersions, so far, other lists work as expected at least a few that have been tested.

Re: ListVersions

TedCronin — Thu, 29 Jul 2010 20:30:43 GMT

Sort of related to this thread, Russell.

http://forums.arcgis.com/threads/9292-Load-script-into-Py-Window-CRASH

Re: ListVersions

RussellBrennan — Thu, 29 Jul 2010 20:37:24 GMT

Ted,

I worked with Kevin from the GP team on this and we were able to determine that this is only happening when you run this from a script. If you step through the commands it will work fine. There is definitely a bug here and we are trying to figure out the cause and another workaround besides stepping through it. I can't make any promises but I am hoping we will get this fixed for SP1.

Kevin will be taking the lead on this so I am going to go ahead and close out this thread. You can continue to discuss this in the GP forum. Kevin hopes to have a NIM number for your reference shortly.