#checkinout

[asmm-brett]

For the next 10 days..... Nothing, not a thing to be concerned about. #thatsgoodliving #family #friends #checkinout #chelanigans https://www.instagram.com/p/BzzXvFDp8kf/?igshid=134ntrextjvix

[chrisryanspeaks]

#checkinout of #stockholmsweden and headed to #copenhagen🇩🇰 next! #eurotripping #eurotrip #scandinavianstyle #gaytravelers #adventuresofchrisandjesse #Travel #Traveling #Travelers #Traveler #Explore #Exploring #Explorer #Wander #Wanderer #Wanderlust (at Östermalm, Stockholms Län, Sweden)

[missypapageorge]

#checkinout #goodnight #nyc

[anitreyu]

Heart Shaped Box ist heute 1 geworden!

[lukebryanofficial]

Luke's final "Spring Break...‪Checkin Out"‬ album is available to pre-order now. Get it here: http://umgn.us/LBSBCO

[lukebryanofficial]

Good times hanging at SiriusXM The Highway today. 

[livinghitech]

SharePoint 2010: Document Checked Out and Locked

The typical resolution to a locked document that is checked out is to wait. You could be waiting for the document expiration to reset in the database. This could be 10 min. It could be the next day.  You could be waiting for the server to recognize that the user is no longer working with the file - if I remember correctly, the server checks for a temp file on the user's machine (even if you are not opening to local folder) and if it finds it, it still reads the doc as checked out.  The time it takes to clear varies, as well.

Then there are some different scenarios I've come across. 

Different Scenario #1:

Cause: (1) Document Checked Out

and

(2) Settings changed to not require check-outs for edits and not track the version history

Any user who tried to open a document in this library after the change received an error..including the person who supposedly locked the file!

FIX?

Change settings back, check in document, and then edit the settings (if you still want to disable features).

Different Scenario #2:

Identify File ID in the db and unlock. Yes, this is drastic. I've never had to do this, but it's good to share knowledge.

This PowerShell Script will ask you some information to identify the file on SharePoint and will output the connection string to the database and the ID of the file in the database.

The ID of the file in the Document Library / List you will find by enabling the ID field in the Default View of the Library / List.

#Check for SharePoint PowerShell Snap-In, load it if its not present if ((Get-PSSnapin | where { $_.Name -eq "Microsoft.SharePoint.PowerShell"}) -eq $null) { Add-PSSnapin Microsoft.SharePoint.PowerShell; #Check if the load worked and throw exception on error if ((Get-PSSnapin | where { $_.Name -eq "Microsoft.SharePoint.PowerShell"}) -eq $null) {throw "SharePoint PowerShell Module is required."} } # Get required variables$SiteURL = Read-Host "Please enter the URL of the Site"$ListName = Read-Host "Please enter the Name of the Document Library / List"$itemID = Read-Host "Please enter the ID of the Item in the Document Library / List"# Get information from SharePoint$SPsite = Get-SPweb "$SiteURL"$SPlist = $SPsite.lists["$ListName"]$SPitem = $SPlist.GetItemById("$itemID")$SQLconn = $SPitem.Web.Site.ContentDatabase.DatabaseConnectionString$SQLfileID = $SPitem.UniqueId# OutputWrite-Host "Connection string to the database" $SQLconnWrite-Host "File ID in the database" $SQLfileID

Once you have the connection string and the ID you can run this SQL statement against the DB, to receive the information about the file:

SELECT * from dbo.AllDocs WHERE Id = '20e2d50e-79e0-4eed-b54c-45d63faa5dda'

And then you can run this SQL statement to reset the CheckoutExpires value

UPDATE dbo.AllDocs SET CheckoutExpires = '2000-01-22 13:24:47.000' WHERE Id = '20e2d50e-79e0-4eed-b54c-45d63faa5dda'

 ~Finito!