SharePoint 2013 Web Application Creation Stuck at "This shouldn't take long"

December 30, 2013    , , ,
Problem: Create new web application from SharePoint 2013 Central Administration site got stuck at "This shouldn't take long" message for long time. Root cause: Insufficient Server memory! Solution: Try closing any open application in the server and free-up server memory. Increase the "Shutdown Time Limit" value of Central Administration's Application Pool in IIS! Here is how: Login to your SharePoint server which hosts Central Administration Open IIS manager >> Expand the server name and click on Application Pools. Locate the SharePoint Central Administration v4 application pool. Right click on it and choose Advanced Settings. In the Process Model section, set the Shutdown Time Limit to a greater value. E.g 900. Restart IIS. This could also happen when your SharePoint servers running out of disk space, database auto-growth setting isn't enabled or your server antivirus preventing certain processes. Related post: "Internet Ex
Read More
SharePoint 2013 Web Application Creation Stuck at "This shouldn't take long" SharePoint 2013 Web Application Creation Stuck at "This shouldn't take long" Reviewed by Salaudeen Rajack on December 30, 2013 Rating: 5

SharePoint 2013 Maintenance Window Notifications

December 29, 2013    , ,
In continuation to my earlier post: Site Under Maintenance Page for SharePoint , While the solution serves the purpose perfectly by displaying a typical "Site under maintenance" page during occasions like SharePoint patching, upgrade, etc. wouldn't it be nice to intimate end-users about the planned maintenance window in advance? Well, SharePoint 2013 brings a new class SPMaintenanceWindow to support planned maintenance windows. Here is how it works: Prior to planned maintenance window schedules, You set the maintenance window on SharePoint content databases to display a notification to end users about the Planned maintenance window. Once user hit SharePoint sites they'll see a notification banner on SharePoint 2013 sites notification area (On Top).  Here is the PowerShell script to set maintenance window notification in SharePoint 2013: How to Create SharePoint 2013 maintenance window notifications: Add-PSSnapin Microsoft.sharepoint.powershell -ErrorAction S
Read More
SharePoint 2013 Maintenance Window Notifications SharePoint 2013 Maintenance Window Notifications Reviewed by Salaudeen Rajack on December 29, 2013 Rating: 5

Create Clickable Image Maps with SharePoint Designer

December 22, 2013    , , , ,
Image Maps in HTML defines clickable areas in Images. You can specify a list of areas (or hot spots) that will be used as the links within an image. We can create an image map for any classifications such as frequently accessed items/region/department, etc. Lets see how to create an Image map using SharePoint designer 2010. Open you SharePoint site in SharePoint Designer, Create a new HTML page. Insert >> Picture >> Choose your image from SharePoint site for Image map. Click on the picture. Now from the ribbon, Click on Format tab, Click on Hotspot Icon and choose the relevant Shape for your clickable region in the image. Select the clickable region by drawing the shape on the image. Once done, you'll get the prompt to enter Link URL.  Once done with all clickable regions, Go to "Code View" of SharePoint designer and copy the code from <P> tag to <P> tag as in the below image Go to your SharePoint page, Edit and Insert a Content Edit
Read More
Create Clickable Image Maps with SharePoint Designer Create Clickable Image Maps with SharePoint Designer Reviewed by Salaudeen Rajack on December 22, 2013 Rating: 5

Get / Set Lookup Field Values in SharePoint List using PowerShell

December 21, 2013    , , , , ,
Here is my PowerShell code snippets to read/write lookup field values in SharePoint lists. Scenario: Consider you have a parent list called "Parent Projects" and child list "Project Milestones". The "Parent Project Name" field from child list is being looked up from the parent list's "Project Name" field. Get lookup field value from SharePoint list using PowerShell: Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue #Variables $WebURL="http://projects.crescent.com" $ListName="Project Milestones" $LookupFieldName="Parent Project" #Get Web and List objects $Web = Get-SPWeb $WebURL $List = $Web.Lists.tryGetList($ListName) if($List -ne $null) { #Get a Row from list $Item = $List.Items[0] #Get Lookup Field Value $Lookup = New-Object Microsoft.SharePoint.SPFieldLookupValue($Item[$LookupFieldName]) #Send the output to screen write-host $Lookup.LookupVal
Read More
Get / Set Lookup Field Values in SharePoint List using PowerShell Get / Set Lookup Field Values in SharePoint List using PowerShell Reviewed by Salaudeen Rajack on December 21, 2013 Rating: 5

Enable/Disable Custom Error by editing Web.Config using PowerShell

December 19, 2013    , , , , , , ,
To reveal actual errors in SharePoint, we used to turn off custom error page by editing web.config file, located in the root of SharePoint virtual directory. Open the web.config in Notepad Search for "CallStack", Change it from "false" to "true" Search for "CustomErrors mode", Change its value from "On" to "Off" Save and Close. Warning: Web.config file is highly sensitive! even a small typo may result your SharePoint site Crash!! Typical SharePoint 2007 "Unknown Error"  and SharePoint 2010's "An unexpected error has occurred" Alright, Wouldn't it be a good idea to make these changes by PowerShell Scripts? Sure, Here is the PowerShell script to enable or disable SharePoint custom error page and reveal actual error by editing Web.Config file: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue Function ConfigureCustomError() { Param( [Parameter(Mandatory=$tr
Read More
Enable/Disable Custom Error by editing Web.Config using PowerShell Enable/Disable Custom Error by editing Web.Config using PowerShell Reviewed by Salaudeen Rajack on December 19, 2013 Rating: 5

jQuery Rotating Banner (Carousel/Image Slider) for SharePoint

December 18, 2013    , , , ,
In continuation to my earlier post Rotating Banner for SharePoint using jQuery , one enhancement requested by people is: The ability to dynamically fetch images from SharePoint library, so that new banner images can be easily added, existing banners can be modified with out touching the banner code. So, I've made changes to fulfill these requirement. Now the new rotating banner code dynamically fetches banner images from a specified library using SharePoint web Services and renders the rotating banner on SharePoint. Also the target URL is now editable from SharePoint UI. Steps to implement jQuery Rotating Banner for SharePoint Step 1: Download the  jQuery-Rotating-Banner.zip ! (Go to File >> Download from Google drive) This zip file contains all scripts, style sheets and sample images for the banner. Extract them to your local folder. Step 2: Create a new picture library (or even document library can do!), name it as " banner ", Open the library in explorer v
Read More
jQuery Rotating Banner (Carousel/Image Slider) for SharePoint jQuery Rotating Banner (Carousel/Image Slider) for SharePoint Reviewed by Salaudeen Rajack on December 18, 2013 Rating: 5

Find and Delete Orphaned Alerts in SharePoint

December 17, 2013    , , , , , ,
Problem Description : In Short - When users leave your organization and removed from Active Directory (AD) they become orphans in SharePoint! Also their alerts!! Why we care about them: To keep SharePoint clean, we've to remove em' from all SharePoint sites. So, I've written a PowerShell script to scan all site collections of the web application, find and remove orphaned users from SharePoint here: Find and Delete Orphaned Users in SharePoint with PowerShell Well, that solves the problem? kind of, but we have one more orphan to clean-up: SharePoint alerts created for orphaned users! Alright, Not a difficult task, Lets make use of the existing script, modify it little, run it before deleting orphaned users! Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Function to Check if a User exists in AD function CheckUserExistsInAD() { Param( [Parameter(Mandatory=$true)] [string]$UserLoginID ) #Search the User in AD $forest = [System.Dire
Read More
Find and Delete Orphaned Alerts in SharePoint Find and Delete Orphaned Alerts in SharePoint Reviewed by Salaudeen Rajack on December 17, 2013 Rating: 5

How to Delete Site with Its Subsites in SharePoint - Quick Way!

December 15, 2013    , , , , , ,
Problem:  SharePoint doesn't allow you to delete a site with its sub-sites. In other words You cannot delete SharePoint Subsite which has one or more child subsites. You'll have to individually remove each and every child subsite prior removing parent subsite. Can't delete subsite in SharePoint 2013: You'll end up in these error s if you try to delete a site with its subsites. Sorry, something went wrong There was a problem deleting Web site "/Subsite". Sites that have subsites or certain apps can't be deleted. Please try again after deleting all subsites and removing the apps. SharePoint 2007 Error: Error deleting web site "/subsiteurl". You can't delete a site that has subsites. So, to delete a site with subsites in SharePoint, first we have to delete all child subsites and then delete the parent site. What if you have large number of subsites? Solution: Use "Content and Structure Manager". Here is the qu
Read More
How to Delete Site with Its Subsites in SharePoint - Quick Way! How to Delete Site with Its Subsites in SharePoint - Quick Way! Reviewed by Unknown on December 15, 2013 Rating: 5

Blocked File Types in SharePoint 2013

December 14, 2013    , , , , ,
Getting " Error: Sorry, something went wrong. The following file(s) has been blocked by the administrator." in SharePoint 2013? Well, This is due to Blocked File Types configuration in SharePoint 2013! What is Blocked File Types in SharePoint 2013: Blocked file types is a security mechanism in SharePoint to restrict files based on its extension. Obviously, You want to protect your environment from potential threats via Malicious scripts and executable. Or as part of your governance policies, You don't want your users to upload MP3 files to SharePoint, isn't it? So, blocked file types restrict specific file types from uploading to SharePoint. Users cannot upload these blocked file types to SharePoint list (as a attachment!) or a library. Please note, SharePoint checks for blocked files ONLY based on file's extension but not actual file type. In other words, You can rename a blocked file (say: EXE file to Doc) to something else to allow SharePoint to upload
Read More
Blocked File Types in SharePoint 2013 Blocked File Types in SharePoint 2013 Reviewed by Salaudeen Rajack on December 14, 2013 Rating: 5

How to Add Promoted Search Results using Query Rules in SharePoint 2013?

December 13, 2013    , , ,
We can promote search results based on specific search phrase entered by end-users in SharePoint 2013. The promoted results will appear on the top of the search results. As best bets/visual best bets are replaced with "Query Rules" in SharePoint 2013, this is a powerful way to promote search results within SharePoint 2013 to brought forward specific results to the users. Scenario: Say, We've a dedicated site for HR Policies with all Human Resources related content and want to bring this site on top of Search results when user types search query as "HR Policies" or "HR Policy". How to Add Promoted Search Results in SharePoint 2013 (AKA - Best Bets) : Assuming Search Service Application is configured up and running, Navigate to SharePoint 2013 Central Administration Site: Central Administration >> Application Management >> Manage Service Applications Click on the "Search Service Application" link, Which takes you to Search
Read More
How to Add Promoted Search Results using Query Rules in SharePoint 2013? How to Add Promoted Search Results using Query Rules in SharePoint 2013? Reviewed by Salaudeen Rajack on December 13, 2013 Rating: 5

Create SSRS Report from SharePoint 2013 List using Report Builder 3.0

December 12, 2013    , ,
Reporting Service integrated with SharePoint provides a rich reporting platform. Lets see how we can create SQL Server reporting services report from SharePoint list data: Create a Library for Reports and add Report Content Type To start with, Lets create a Document Library,  Add Report Builder Report content type to create a new report. Go to Library Setting >> Advance Settings >> Select Yes for “Allow management of content types” and click on Yes. This Navigates to library settings again. Scroll down and Click on “Add from existing site content types” under “Content Types” Add “Report Builder Report” content type, and click on “OK”. Create Report using Report Builder Tool Go to Files Tab >> Click on drop down on "New Document" Ribbon button >> Choose "Report Builder Report" This launches “Report Builder Client 3.0” installation for the first time. Wait for the ClickOnce installation to complete.  Make sure your SharePoi
Read More
Create SSRS Report from SharePoint 2013 List using Report Builder 3.0 Create SSRS Report from SharePoint 2013 List using Report Builder 3.0 Reviewed by Salaudeen Rajack on December 12, 2013 Rating: 5

How to Create and Deploy SSRS 2012 Reports to SharePoint 2013?

December 11, 2013    , , , ,
Reporting Services integrated with SharePoint 2013 gives you Rich enterprise reporting features. We've our SQL Server 2012 Reporting services integrated with SharePoint 2013 already. So now we can create reports for SharePoint 2013 using both SQL Server Report Builder 3.0 and using Visual Studio. Lets create a SQL Server Reporting Services Report using Visual studio and publish to SharePoint 2013 site: Open Visual Studio 2010 Shell which comes with SQL Server 2012 (formerly “BIDS”), Choose New Project >> "Report Server Project Wizard" type, Give it a name. This opens Report Project Wizard. Click Next We've to create a Data source for our report. Choose "New data source", Give it a name and choose Type. In my case, data is in SQL Server. Click on "Edit" button to specify SQL Server database From the connection Properties dialog box, Specify the Server Name and Database in which our required data live Now, We get the connection string
Read More
How to Create and Deploy SSRS 2012 Reports to SharePoint 2013? How to Create and Deploy SSRS 2012 Reports to SharePoint 2013? Reviewed by Salaudeen Rajack on December 11, 2013 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.