topic Re: Unable to delete a version? in Geodatabase Questions

Unable to delete a version?

RyanKelso — Wed, 17 Sep 2014 16:59:06 GMT

I've ran into a couple of times where users were not able to delete their versions. Once was because they were still connected to their version, or at least ArcMap thought they were. The other time, they received some message along the lines of "unable to delete, invalid State ID". I haven't been able to find any information on this message or why they were getting it. They were able to simply try again another day and successfully delete the version. Can anybody tell me about this?

We're new to versioned editing, basically at this point people were just experimenting with creating versions, changing versions, starting edit sessions, and deleting versions. So there wasn't much going on beyond that.

Re: Unable to delete a version?

JosephSicluna — Wed, 17 Sep 2014 17:52:59 GMT

Not sure if I follow, but recently moved from 9.3 to 10.1. Had problems uninstalling 9.3. It should be removed module by module, reverse of the install. In the end had to go into the Registry and delete many, many entries. Eventually removed THE ONE that allowed the new version to install. Found the solution browsing around the web

Re: Unable to delete a version?

AsrujitSengupta — Wed, 17 Sep 2014 18:20:33 GMT

Joseph Sicluna‌ :I am not sure if your response is related to this thread.

Re: Unable to delete a version?

AsrujitSengupta — Wed, 17 Sep 2014 18:29:44 GMT

Ryan Kelso I am not sure what exactly brought up that error message along the lines of "unable to delete, invalid State ID".

The are some things that we need to keep in mind before deleting a version. The below links provide some information related to that. Have a look at them

Deleting versions:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Delete Version (Data Management):

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Next time you receive an error, take a screenshot of that and post it here as that would help.

Also please mention which version of ArcGIS Desktop you are using. Starting from 10.1, you can directly check any lock present on a version in the Geodatabase Administrator window, which helps as well.

Re: Unable to delete a version?

RyanKelso — Wed, 17 Sep 2014 19:20:19 GMT

Thanks for the reply Asrujit SenGupta‌, I asked the geodatabase users to grab a screenshot if they see the message again. I'll post it here if they do.

We're running Desktop 10.2.2 and the geodatabase is on SQL Server 2008.

Re: Unable to delete a version?

PeterKing — Thu, 18 Sep 2014 19:20:40 GMT

Ryan,

We received this error and resolved it by performing a compress on the GDB. Even though the compress did not take the DB to State 0, it still removed any reference to the "Invalid State"

Re: Unable to delete a version?

RyanKelso — Fri, 19 Sep 2014 15:18:54 GMT

I'll try this the next time we see this error. Thanks!

Re: Unable to delete a version?

ThomasKonzel — Wed, 19 Apr 2017 15:34:22 GMT

Just to share my solution - we had a version named 42" WL that neither the user or administrator could delete. I had suspicion that the special characters double-quote and space were causing an issue so I renamed the version in the SDE_VERSIONS table to 42_WL and voila!, no problem deleting the version. I suspect the only allowed characters in a version are alpha-numeric and underscores.

Re: Unable to delete a version?

JeffMcReynolds1 — Mon, 15 May 2017 14:08:14 GMT

I'm never a fan of editing directly in SQL, but I had a similar problem in 10.2 SDE. User had a name with a double quote instead of a single quote (Jeff"s edits vs. Jeff's edits).

update dbo.sde_Versions
set name = 'Jeff'
# i just picked another column that was specific to the row i wanted to change in the next line

Where status = 0

renaming the version directly in SQL fixed my problem too!