SharePoint Configuration/Troubleshooting

Today I was working on installation & configuration of Office Web Apps for one of the SharePoint Extranet Farm, installation of OWA went successfully however while creating Office Web Apps Farm I started facing a weird issue where the certificate for OWA was available on server however it was still unable to find it:  Error Below: ------------------- PS D:\> New-OfficeWebAppsFarm –InternalUrl "https://owaserver01.domain.com/" -ExternalUrl "h ttps://owa.domain.com/" –CertificateName "owa.domain.com" –EditingEnabled New-OfficeWebAppsFarm : Office Web Apps was unable to find the specified certificate. At line:1 char:1 + New-OfficeWebAppsFarm –InternalUrl "https://owaserver01.domain.com/" -Ex ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + CategoryInfo          : ObjectNotFound: (:) [New-OfficeWebAppsFarm], ArgumentException     + FullyQualifiedErrorId : CertificateNot...

Hello All, Good Morning :) Yesterday while working on an issue I came across a situation where I misplaced URL's of some hidden lists which were shared with us in our SharePoint site collection and I really wanted to access the list to get some details.  I started looking for some PowerShell script to find hidden lists however couldn't find a good script online.  After sometime I thought of opening the site in SharePoint Designer and see if the lists can be found there.  So when I opened SP Designer and clicked on Lists and Libraries under Navigation - Site Objects hoping that the list should be seen here, however it wasn't available there as well. Here is how I was able to found that list: 1. Open your SharePoint site in SP Designer 2. Under Navigation - Click All Files 3. Under All Files you will see a folder called "Lists" 4. In this folder you will see all your lists which are hidden to all users (Administrators as well). In order to grab URL...

I came across a situation where in there were multiple SharePoint farms which had their own User Profile service application and there was a farm which was consuming User Profile Application from another farm and it was not documented from which farm it is consuming.  For some troubleshooting purpose I wanted to find out from which farm the User Profile application is consumed, I didn't find any easy way from SharePoint Central Administration.  So finally I thought Powershell should be helpful here. I used below cmdlets to find out the server farm from where UPA was consumed: 1. Get-SPServiceApplicationProxy | select TypeName, ID | Format-Table -AutoSize 2. Copy GUID of User Profile Application Proxy 3. After you have ID for the User Profile Application Connection Proxy, run below cmdlet:     $upa = Get-SPServiceApplicationProxy -Identity "Paste ID of Connection Proxy copied" 4. $upa | select ServiceEndPointURI | Format-List This above cmdlet will ha...

Issue Description: ============== You are not able to see columns associated with 'Document Set' content type when you view or edit properties of Document Sets. When you view or edit properties of Document Set you can just see the "Name" column.  Resolution ======== You can add a web part to the DispForm.aspx or Editform.aspx and then add a connection filter for the web part. 1. Open the affected site in SharePoint Designer  2. Navigate to the affected Library where you have the Document Sets.  3. Edit the Dispform.aspx and search for below line in the code: <TemplateName xmlns="http://schemas.microsoft.com/WebPart/v2/ListForm">DocumentLibraryForm</TemplateName> 4. Comment out or delete the above code of line and save the page.  5. If you see the same thing when you edit properties of Document Set then do the same thing for Editform.aspx and save the changes.

Issue Description: ================ You configure the App Management Service in the farm but while trying to add any app you receive the following error: Sorry, apps are turned off. If you know who runs the server, tell them to enable apps. Cause ======= The server was running out of memory.  Steps to Resolution ================ 1. We tried to add an app using a non-system account, however we received the following error: Sorry, apps are turned off. If you know who runs the server, tell them to enable apps. 2. We tried to browse SharePoint Central Admin - Apps - Configure App URL's and got below error:  Sorry, something went wrong Settings or services required to complete this request are not currently available. Try this operation again later. If the problem persists, contact your administrator.  Technical Details  Troubleshoot issues with Microsoft SharePoint Foundation.  Correlation ID: 6379209c-5068-40f4-5407-6ef37b5fe7a3  Date a...

Issue: ======== "A system restart from a previous installation or update is pending . Restart your computer and run setup to continue." Steps to Resolution: ==================== 1. Open the registry from Start > Run > regedit 2. Go to " HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager " 3. Rename the key "PendingFileRenameOperations" to someting like PendingFileRenameOperations_OLD 4. Close the registy editor. Now run the PSConfig wizard to complete the setup. NOTE : Before you make any changes to the registry use the EXPORT option to take a backup of the registry