The file is exclusively locked but is not checked out!

kurthenderson · Post by **kurthenderson** » Wed Apr 16, 2008 8:36 pm

I've been reading through several post and I still could not find a solution to my problem.

Some History:
My company contracted with a developer to work on our code. The developer used Vault as a source code respository and everything worked great. We have since moved on to another developer and the prior developer gave us a full backup of his Vault database. We got that installed and everything seems to be working except I have about a dozen files which I can not check in/check out or do anything with these files because we keep getting the error that " [our file] caused the transaction to fail: The file has been exclusively locked."

What I have Tried So Far:
(1) I've logged in on the server and cleared all checked out files and that did not help.
(2) I've cleared the local cache on the work station and that did not help.
(3) We are using the latest version of Vault which is 4.1.1.18060 on both the server and the client.
(4) These problem files show as "Edited" in the window and not checked out.

How do I clear the exclusive lock if the file is not checked out.

lbauer · Post by **lbauer** » Thu Apr 17, 2008 2:34 pm

When you said you cleared all checked out items, I assume you did an Undo Checkout from the Admin Client, is that right?

Have you tried restarting the Vault Server? Use the iisreset command.

If, after restarting the server, the problem persists, run this query on the sgvault database:

Select * from tblcheckoutlistitems

Do the paths to the files appear in the query results?

kurthenderson · Post by **kurthenderson** » Mon Apr 21, 2008 6:12 pm

Yes Linda, I was using the Admin Web Client to clear the checked out items.

I had restarted the server a few times and stopped and started the vault website. I just did the iisreset and that did not make a difference.

I ran the query and it returned 22 items. 5 of the items in the list are items that I could not check in. (Note in my original post I said there were a dozen files. 7 of these I was able to get checked in by checking them out again and then checking them in.

All of the items in the list show the full path and the paths are correct.

Any other suggestions?

kurthenderson · Post by **kurthenderson** » Mon Apr 21, 2008 7:17 pm

Hi Linda,

One more things that I noticed about the data in the "tblcheckoutlistitems" table is that all of the records have a "userid" of 3 or 4. There are only two users now, the Admin which is ID=1 and myself which is ID=2. Could this be part of the problem?

lbauer · Post by **lbauer** » Tue Apr 22, 2008 4:06 pm

Perhaps someone manually edited the tables.

I'll have our database specialist take a look at your post.

kurthenderson · Post by **kurthenderson** » Tue Apr 22, 2008 5:54 pm

Hi Linda,

I don't believe anyone would have edited the databases directly. I may have deleted users 3 and 4 after I restored the backup I got from my prior developer. Do you think adding a 3rd and 4th user back in will let me get rid of the exclusive lock on the checked out items?

lbauer · Post by **lbauer** » Thu Apr 24, 2008 5:01 pm

Could send an email to support at SourceGear.com ATTN: Dan. We'll send you a query that can fix this.

ddill · Post by **ddill** » Thu Apr 16, 2009 2:39 pm

Was there ever a resolution for this issue?

I am having the same problem. A file is locked exclusively. I do not see it locked in my client, but the other developer does. If I lock it exclusively in my client he sees two locks in his. I clear it and it clears one of the locks.

lbauer · Post by **lbauer** » Fri Apr 17, 2009 7:31 am

What version of Vault are you using? There were some checkout issues in previous versions.

SourceGear Support

The file is exclusively locked but is not checked out!

The file is exclusively locked but is not checked out!

Clearing Exclusive Lock

Clearing Exclusive Lock

Re: The file is exclusively locked but is not checked out!

Re: The file is exclusively locked but is not checked out!