Mind the Site Locks when Move-SPSite Fails

Recently I was working on a migration of a couple of big sites moving them to their own content databases and it didn’t exactly turn out as I planned.

So more than anything, I wanted to use this post to describe what happened and mention some tips and other things that may help others out in the future if you ever run into trouble when trying to break out sites into their own databases.

Here are the major events that happened in the migration process:

  1. Created DB under central admin
  2. Used Move-SPSite to move one site from another content database
  3. Content stuck on Move-SPSite, never finished
  4. Restarted all servers
  5. When came back up, new destination database was in recovery
  6. Recovery process used all SQL resources, major slow down of farm (sad time)
  7. Looked into SQL logs to check status of recovery thinking new destination database would come back up
  8. Actually after recovery finished, I still had no access to content created in new content database
  9. Checked and under central admin checked site locks and quotas
  10. Turns out entire site still on old source DB
  11. Hadn’t been copied over, even though SQL showed a populated database
  12. Site lock had been switched on all the way to no access
  13. Users going to site would get a 403 forbidden message when trying to access
  14. Went under site locks and cleared the lock
  15. Once this was done, content access returned to normal
  16. Original content and under Central admin still said content was on source DB
  17. New destination content DB under still showed also that it contained no content

So in the end, the big lesson learned here was that even though I could check SQL and see that the new DB contained information, SharePoint hadn’t moved the site over to the new content database.

I did some research and there are timer jobs that run gradual site deletions, but I don’t think they applied here. Either that or I switched back to the original database before anything else was allowed to happen.

In the future, I may just use Backup-SPSite  along with Restore-SPSite because that command also has the ability to specify a new database to put the site into when the backup is restored.

I hope these tips save you some time and headaches in the future.

Enjoy!

Edit Form People Picker Empty – Fixed with Workaround

Happy Friday everyone,

I wanted to let you know of a current issue that we are seeing in our SharePoint Foundations 2013 farms. Right now as far as I can tell this shows up if you have the July, August, or September 2014 CU added to your SharePoint Farm

You can read about it here:

http://social.technet.microsoft.com/Forums/sharepoint/en-US/17db4d9a-590f-4d4d-ab83-9d7d50cf6e31/sharepoint-2013-july-2014-cu-people-picker-fields-empty-in-edit-forms?forum=sharepointadmin

The TL:DR version is the people picker is blank when you go and open an existing item in a list using the edit form. This is kind of a pain because we use this type of field EVERYWHERE in our farms.

I want to get the word out to as many people as possible at this point and my next plan is to open a support ticket with MS support.

Feel free to post more comments below and let me know what your experience is with this. As I have more details and a fix, I will post it here.

Thanks,

BJ

Update here is the workaround that I got from MS Support:

  • Went to the tasks list “Tasks”
  • Selected an existing item >> edit item
  • We were not able to edit the form
  • Went to site contents >> tasks >> settings
  • Went to library settings >> Advanced settings
  • Selected “NO” to Launch Forms in a dialog option
  • Went to tasks list “BI Tasks”
  • Selected an existing item >> edit item
  • We were able to edit the form
  • Went to site actions >> edit page >> web part >> Web Part Properties -> Activate Server Render option
  • Click Apply-> OK -> Stop Editing
  • Checked the item by editing it
  • We were able to see the name in Assigned to field.

Hope this helps, but would like to see it fixed so we don’t have to correct this all over the place…

Create search in SharePoint Foundations 2013 without GUID

When SharePoint Server 2013 was first released, I was curious what new things I could do with it. I saw the new search capabilities, a different look and feel, a similar management interface, and several other BI things that made me happy. I then also realized that I support SharePoint Server and also the free version SharePoint Foundations. In SharePoint Foundations you get SOME of the things that makes SharePoint great (like Search for example), but with Foundations there are usually strings attached to that functionality.

In SharePoint, if you create your farm by clicking on all the defaults and using the wizards your databases look like this:

clip_image001

With SharePoint Foundations 2013, we don’t really have the option to create search by scripting with PowerShell… or do we?

Originally my research pointed me to Gary LaPointe’s blog here.

Which is great because this is in PowerShell and I can understand this, but it still doesn’t give us what we are wanting in the end like this:

clip_image002

Fortunately I found the following post by Jasjit Chopra’s blog here.

Finally!!! What we have been searching for all along! One thing to note at this time is that I have tried this myself on two different farm configurations (a three tier farm and a single box farm) and in both cases the search service and databases were created with the clean names and the service functions just fine.

I’m doing my happy dance now… enjoy!

-BJ

Grid View Issue Reappears with Performance Point 2013 post June 2013 CU

Hello again SharePointers!

I wanted to get the word out on another bug that seems to have reappeared in Performance Point in SharePoint Server 2013. Originally this issue popped up as a problem with the grid view being cut off towards the top. Example below:

clip_image001

This issue was corrected in the June 2013 CU for SharePoint Server here

But after testing both before SP1 (August 2013 CU) and after SP1 in my farms, I see the following issue pop up when multiple pages exist in the web part. This is referred to pagination I believe and causes a behavior that we see in our farm like the screenshot below:

clip_image002

For us it’s more of an issue about our users not being able to view the proper info they need. I have filed a case with Microsoft support and will keep everyone up to date on how it progresses.

Fortunately as I was typing out this post I got a message from someone that this is an official bug and will be submitted to the product group to be fixed.

So I am glad that it is not just my farms that see this issue… 🙂 But I also hope that this provides some help for those of you seeing this issue as well. As soon as I get word on which CU this new fix will be in, I will let everyone know.

Thanks for visiting!

BJ

Fix for KB2825647 released and verified

In my previous two posts I focused on a problem created by the install of the October 2013 CU for SharePoint 2013 Server. It basically disabled the ability of your users to launch dashboard designer (DD) after installing the cumulative update.

In December 2013 another CU was released, but didn’t do anything to address the problem of not being able to launch DD. If anyone of you have a SharePoint 2013 farm and use BI, this is kind of important. It’s kind of like owning a cheese factory and someone comes along and disables all of your cows from giving milk.

Good news though! After checking the MSDN forums I came across the following article:

http://blogs.technet.com/b/office_web_apps_server_2013_support_blog/archive/2013/11/19/performancepoint-2013-dashboard-designer-fails-to-start-after-october-2013-cu.aspx

Originally this article listed 3 files that needed to be replaced in all of your SharePoint farms to correct the CU issue, but initially I tried this and it did not resolve the problem. But after a few days two more files were added to be replaced as well.

The great news is that I confirmed that this does fix the original issue brought on by KB2825647 and now we can launch DD with the October 2013 and December 2013 CU applied to my SharePoint 2013 farm! Oh happy day!! Smile

Maybe this will get integrated into the February 2014 CU, but secretly I hope we get to see SP1 for SharePoint 2013 before that.

We’ll just have to wait and see. Happy SharePointing everyone!

-BJ

December 2013 CU for SharePoint 2013 still has Dashboard Designer problem

KB2850024

Happy Friday again SharePoint folks! I bring you good tidings of joy in this holiday season, but all of this doesn’t come without a lump of coal from the world of SharePoint 2013.

According to this article put out:

http://blogs.technet.com/b/stefan_gossner/archive/2013/12/20/december-2013-cu-for-sharepoint-2013-has-been-released.aspx

The December 2013 CU for SharePoint 2013 has been released, but unfortunately for those of us looking for this CU to fix the broken Dashboard Designer that was a result from the October 2013 CU for SharePoint 2013, it isn’t going to happen.

I guess we all must still dream of Service Pack 1 coming hopefully next year. I hope this does get fixed eventually because if you are like me and have a Business Intelligence effort going on at your company and you use SharePoint 2013 for it, Dashboard Designer is kind of critical in this effort.

So if you are going to update your farms, feel free to, but be warned that DD is not going to function after you install it.

Everyone have a Merry Christmas and a Happy New Year! Smile

-BJ

KB2775353 fixed with KB2817570 for SP2010 Server

 

Hello again from SharePoint land!

It’s been a while since we talked about KB2775353 and how it made our SharePoint 2010 servers where I work extremely sad and kept them from correctly displaying our BI dashboards in 2010 (see here).

I was originally told when I found this bug that the fix would be put into a patch around the August 2013 CU timeframe, and sure enough with the newest round of patches released I went and got my grubby little hands on it. It took a few days for us to properly test it here, but I can confirm from our internal testing here that this patch corrects our display issue with our dashboards! Yay!!!!

Just to be clear, this is my personal scenario of how things went, YMMV.

We originally patched our farm to the April 2013 CU for SharePoint Server 2010 due to an incorrectly applied patch that came in from windows update, so we were originally forced to move to the April 2013 CU. For the meantime we have been working around this issue by displaying our dashboard items in a different way. We notified MS support of our issue and verified it was indeed a bug and they went to work on correcting it.

So when the August 2013 CU for SP2010 came out a few days ago, I had a couple of options on how to bring my farm up to the latest patch level. What I ended up doing was patching my farm with SP2 and then after checking to make sure everything applied correctly from this patch, applied the August 2013 CU for 2010.

After this, we had to redeploy our dashboards back to how they were before the April 2013 CU mess and verified that everything looks good and is back to normal.

Now I can put all of this mess behind me and work towards upgrading everything to SharePoint 2013. I hope this helps anyone else who runs across this scenario with their BI setup in SharePoint 2010.

Thanks for all the twitter questions and replies to my previous post everyone! I think with 2013, I will be more conservative in my patching going forward…

-BJ