Cannot delete version

Question

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

DerekLaw · Answer

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,

ToddMurphy · Answer

...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.

CraigMark · Answer

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