topic Cannot delete version in ArcGIS Enterprise Questions

Cannot delete version

CraigMark — Thu, 09 Jun 2011 16:48:43 GMT

Software
ArcSDE 9.3.1 SP1

Problem Description

I have a a two level version tree setup - Default -> Users

I have a child version (parent is default) with no dependents. I can't delete the version.

There were never any child versions created from that version. I've tried through Catalog, command line - sdeversion commands, tried changing the version name, reconciling again, start/stopping sde, rebooting the server...
________________

Error Message

From ArcCatalog (right click>versions>Delete version)

�??Unable to delete version. Operation not allowed on a version with dependent children [ownername.loc_1106]�?�

From command line - (sdeversion -o delete....)

Error: Can not delete a version that is the parent of other versions (-285).
Error: Unable to delete version.

Any help is greatly appreciated.

- Craig

Re: Cannot delete version

RickMomsen — Fri, 10 Jun 2011 02:13:08 GMT

Craig,
One possible cause of this is if one of your users created the version as 'private'. In this case, the only other user that can see this version is SDE; who can also delete it. You can also check the SDE.VERSIONS table to see all versions and their properties.

Re: Cannot delete version

CraigMark — Fri, 10 Jun 2011 13:12:17 GMT

Rick - good call... I create the versions for our users. I double checked and it is public.

Re: Cannot delete version

CraigMark — Fri, 10 Jun 2011 13:27:23 GMT

Problem Fixed - There were dependents... Someone had created a child version - I found the dependency in the sde versions table. (Thanks Rick!)

I wonder if there's an easier way to see the version dependents?

- Craig

Re: Cannot delete version

ToddMurphy — Tue, 26 Jul 2011 23:32:59 GMT

...I wonder if there's an easier way to see the version dependents?...

Right, like a model builder-type utility that draws a tree diagram out? That would rock.

Re: Cannot delete version

DerekLaw — Tue, 02 Aug 2011 17:12:45 GMT

Craig and Todd,

... I wonder if there's an easier way to see the version dependents?

Right, like a model builder-type utility that draws a tree diagram out? That would rock.

FYI, at ArcGIS 10.1, there are several new tools that make the management of ArcSDE geodatabases much easier. including an enhanced version manager dialog.

From the Jack Pre-UC 2011 Q&A:

> What are some of the enhancements to the geodatabase in ArcGIS 10.1?
> Administering my enterprise geodatabase can be difficult. Are there any tools coming that will help with this process?

Hope this helps,