Queue Job Status shows "Waiting to be processed" and then never completes

We may get this issue while checkin the project. We can't do anything when we got this message. Project sever will allow you to edit the task once the project checked in. 

Solution for this issue:

• Goto Services
• Restart Microsoft Project Server Queue Service 2013 

Check in process will work once you refresh it.

Create Custom Page Layout in SharePoint 2013

Introduction

As well know about page layout in SharePoint. Now i am going to give steps to create custom page layout.

Design Manager

We will use design manager to create page layout.  Here is the steps

• Site Settings -> Design Manager
• Click Edit Page Layouts
• Click Create a page Layout

• Give name for page layout ,masterpage to inherit and content type of page

• Click Ok
• New page layout will be displayed in Master Page Gallery and Edit Page Layout page

The page layout is in draft state by default. It will not display in page layout dropdown if it is in draft mode. We have to change this as publish version. Then only page will be displayed.

For making changes to page, we have to change the .html file. Download the .html file and make the changes. upload again in master gallery.

Then, Go to Pages Library. Click Pages in New Document Menu

We can find our custom page in page layout section.

Cannot rename old site on restore

Some of us may face this "Cannot rename old site on restore" error while restoring Site in SharePoint. There may several reason to get this type of error. I am going to say about one of the reason to get this error. 

That's Long URL problem with Libraries and List attachments. Some of the URL can't be restored due to long URL. Here is the steps to find those long URL items.

• Open the Content Database in SQL
• Right click the DB and select New Query
• Paste the below query

    SELECT

   CONCAT([DirName], N'/', [LeafName]) AS [FullRelativePath],

   LEN(CONCAT([DirName], N'/', [LeafName])) AS [Length]

    FROM

   [dbo].[AllDocs]

    ORDER BY

    [Length] DESC

• We will get the Long URL Libraries and List items
• Then go to that library / list
• Delete the Library / List from site. It will be in Recycle bin. No need to worry about that
• Then take new backup of your site and try to restore it
• Restore the deleted library / list from recycle bin once site has been restored successfully

To avoid Threshold for list in SharePoint 2013

Introduction

As all we know about Threshold in SharePoint. It is setting limit to view the list items. Threshold for normal user 5000 and 20000 for admins. If particular list exceeds this limit, then items will not be displayed in listview. We have 2 alternate options to resolve this. Let see one after one.

SPList.EnableThrottling

This option normally in true state for every list. If we disable this, List doesn't consider about threshold value. So List view will display items when list items exceeds threshold limit. Execute the below powershell script to disable this option. (But we have to consider about performace while running with huge amount data in list)

$web = Read-Host "Enter site URL : "

$spweb= Get-SPWeb $web

$listname = Read-Host "Enter List Name:"

$list = $spweb.Lists[$listname]

$list.EnableThrottling = $false

$list.update()

Write-Host "Throttling has been disabled..." -ForegroundColor Green

Daily time window for large queries

We are having this option in Request Trotting. We have a timer option in it. We have to set the time when and how long it will be visible. But we have to consider about performance, when we give long duration.

visual upgrade failed _catalogs/masterpage/v4.master

We may face this error while doing visual upgrade for migrated site. Here is the steps to resolve this error.

• Create a new subsite under migrated site
• Copy the v4master from Site Settings -> Galleries -> Master Pages
• Then upload this master page in top level site
• Now visual upgrade will be working fine

Attach Content Database with SharePoint WebApplication

I am going to explain how to attach a content database with SharePoint Web Application. Follow the below steps to attach DB

• First Restore the content database in local sql server
• Open the powershell, first test the db for safer side. Give  Test-SPContentDatabase -name yourcontentdbname -WebApplication "yourwebapplication"
• It will give some exception if the DB is not attachable with web application
• Then mount the database,  Mount-SPContentDatabase "yourcontentdbname" -WebApplication yourwebapplicationname
• It will show the progress of mounting DB
• We will get 100% notification once DB mounted

Device channels in SharePoint 2013

Introduction

Now a days we all using mobile phones to browse things. To render the SharePoint site easily to smart phone and devices, we need a help from Device channels. We can use multiple design for multiple devices. Here i an going to give an idea about Device Channel usage in SharePoint.

Device Channels

It is the part of publishing infrastructure feature in SharePoint. That enables you to render site content, style, images (with same URL) in different devices. HTTP GET  request will send when we accessing the SharePoint site from Smartphones and other devices. This HTTP GET request includes user agent string. This string is having type of device. The device browser will redirect to specific master page based on device substring. For example, if you have a collection of Windows Phone and iPad devices, you can provide each pool with a unique rendering of the SharePoint publishing site by using device channels. Each device channels can be given a different master page and  CSS file to give users a more optimal viewing experience.

Create Device Channel

Here is the steps to create device channel

• Site Settings --> Look and Feel --> Design Manager
• Click Create Channel
• Give required fields like Name, Alias, Device inclusion rules
• Device Inclusion Rules contains substring of devices like iPhone, iPad, Android

• We will get master page selection page when channel has been created
• We can choose the master page for our device

Device Channel will be ordered and listed after the creation. It supports upto 10 devices per site in SharePoint 2013.

Publishing Site in SharePoint 2013

Introduction

In SharePoint 2013, We have one of the site template called Publishing Site. An unique feature of this feature is, authoring, approving and publishing processes. The Lists, Library and webparts of this features has created automatically when we create the site.

Create a Publishing Portal

This portal is top level of site collection. Follow the below steps to create publishing portal

• Central Administration --> Application Management --> Create Site Collection

• Choose your web application. Enter the title and description of the site collection. Then, Choose Publishing Portal site template at Publishing tab in Template selection

• Then give Primary and Secondary Site Collection Administrator. Select the Quota Template for storage.
• Click OK

Publishing Sub-Site

This site will be a sub site of Publishing enabled site collection. The publishing feature will enable automatically while you create under this site collection. Here is the steps to create a publishing sub-site

• Site Contents of the site collection. And click new Subsite
•  Give the title, description and URL to the subsite
• Template selection will show only publishing category site templates. Choose one among them

• Then give permission level 
• Click Create
• The content will not visible to the reader without publish it

Publishing site with approval workflow

The content approval by Admin and Stake holders will enable automatically to this site template.What makes the publishing approval workflow unique is that it’s designed specifically for publishing sites where the publishing of new and updated web pages is tightly controlled. In these kinds of sites, no new content can be published until it has been approved by every approver in the workflow.

Drop down style filter in SharePoint List

In SharePoint List, We can get drop down filter if we have more number of data. 

If you want to make this filter while page is loading. Have to add querystring in URL. For Example,

http://servername:port/sitename/list/allitems.aspx?Filter=1

Search Configuration in SharePoint 2013

Introduction

I am going to give an idea about configure search in SharePoint 2013. Follow the below steps,

Step 1:-

Central Administration --> Application Management --> Manage Service Applications

Step 2:-

Explore New drop down at ribbon. Click Search Service Application

Step 3:-

Give the properties in New Search Service Application dialog box. Then, Click Ok

It will show a success message once the configuration is done

Step 4:-

The service will display in Service Application. We will redirect to Search Administration page.

Click Index Reset for safer side

Step 5:-

Click Content Sources to do crawling. Expand the drop down of Content source and click Start Full Crawl.

That's all. Search will work in SharePoint site.

The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator.

We may face this issue in Term store page. Here is the steps to resolve this.

Central Administration --> Application Management --> Manage Service on Server. Start Managed Metadata Web Service.

Then, do iisreset. Taxonomy will get work normally.

Folder "Share with" option in Skydrive of SharePoint 2013 Mysite

Introduction

In SharePoint 2013, We are having the One drive / Sky drive option in My site. Its basically works like document library. We can keep our document in it and integrated with our local machine too. We have all the features of Document Library in One / Sky drive. But SharePoint given some limitation for sharing document and folder. Let us see about it.

Sharing Folder

We don't have any limitation to share document items. But we are having limitation to share folder. For example, If you share the folder to someone. It will throw Access denied message while he/she accessing the folder. 

Here is the solution to resolve this. Follow the below steps before share the folder. If it is already done, don't worry about it.

• Click the Sky drive at top ribbon

• Click Site Settings --> Site Collection Features
• Activate "Limited access user permission lockdown mode"

Shared user can able to access the folder once we activated the feature.

Removing Members from Community Site

Introduction

In SharePoint 2013, We have a new site template called community. This site is used as forum. We will have Community Member list which is having all the details of members. If the member is leave the community it wont delete from Community member list. Instead of hard delete, SharePoint handling the soft delete while Leave the Community.

Removing Member

If you want remove the member, follow the below steps,

• Go to Site Collection --> Site Settings --> Content and Structure 

• Expand the site
• We can get the Community Member list

• Click Community Member list
• Check the member which we want to delete
• Explore the Action menu at top. We can find the delete in it.
• Then Click the Delete