List

A few days ago I ran into a problem where, when attempting to delete a document or list item or when attempting to modify a web part view, SharePoint redirected to a white page with nothing on it. After banging my head, checking every setting and combing through each result on the first 10-pages of Google search results, I was still left empty handed. Finally, it came to me! There was a problem with the web application! To verify, I created a new web application on the same server, created a site collection based on the Team Site template and tested. I was able to delete items and change web part views. What came next is always the scary part.

Before going into the solution, I warn you dear reader, please please PLEASE make backups! If your SharePoint environment is virtual, snapshot the SharePoint, SQL and Office web apps server. otherwise, create fresh backups of all the SharePoint databases and make sure they are quickly accessible.

Now on to the solution.

  1. Run the SharePoint 2013 Management Shell as an administrator.
  2. Dismount the database from the web application
    1. Get-SPContentDatabase (to find the exact name)
    2. Dismount-SPContentDatabase <ContentDatabase_Name>
      1. Answer Yes
  3. Run SharePoint 2013 Central Administration Console as an Administrator
  4. Click Manage Web Applications
    1. Click to select the Web Application that has the problem.
      1. Mouse over the delete icon on the ribbon bar and click the lower half of the button.
      2. Click Delete Web Application
        1. Delete content databases = NO
        2. Delete IIS websites = Yes
        3. Click Delete
        4. Wait
        5. The page will refresh when the process has completed
    2. Click New on the ribbon bar
      1. Enter all information exactly as it was before with one exception
        1. Under Database Name, enter the name of the content database that was dismounted in step 2 above
        2. Click OK to create the new Web Application using the existing content database
        3. The screen will refresh once the process has completed
  5. If you had any Alternate Access Mappings, recreate them properly. (How to properly change the Host Header URL of a web application in SharePoint 2010)
  6. You’re all set!

  Posts

December 4th, 2019

SQL Puzzle

In my endless search for the end of the internet, I stumbled across a fun SQL Puzzle.  Link: https://www.itprotoday.com/sql-server/t-sql-puzzle-challenge-grouping-connected-items  

October 25th, 2019

New Power BI Calendar Table

While the old one still works, it doesn’t exactly follow Power BI and DAX best practices. Much like everything in […]

March 5th, 2019

Power BI Report Last Data Refresh Date & Time Tile

With all the data flowing within companies, we needed a way to track the last time Power BI reports were […]

December 3rd, 2018

Date Table and Extras for Power BI

When dealing with incomplete date sets in Power BI, I often add in a quick and dirty Data table to […]

February 14th, 2018

Invincible workflows

Today I encountered a list item that had two instances of the same workflow, both stuck on the first step. […]

May 17th, 2017

The case of the missing App Launcher

Today I deleted and recreated a SharePoint 2016 Web application and recreated it, without issue. Well, except that the new […]

March 10th, 2017

The server failed to process the request. Aka, the SharePoint version of PCLoadLetter

It’s Friday so I’ll keep this short The ongoing power struggle between SharePoint and it’s tamers continues. Today we’re faces […]

March 3rd, 2017

Search, search, search, all the day long…

So, I just rolled SharePoint 2016 into a test environment and launch Central Admin, and the first thing my eyes […]

May 5th, 2016

Oh, happy day!

SharePoint 2016 has been released to MSDN! Time to practice different upgrade strategies and see what this baby can do! […]

March 29th, 2016

Branding Gone Wild

Today I ran into a problematic sub-site in my SharePoint 2013 farm. This sub-site, named “Test”, was where I had […]