Thursday, February 25, 2016

Coercion warning: user or group does not have a valid e-mail address

This post is about sending emails to SharePoint Group (everyone in SharePoint group).
I was working on a requirement where a task has to be assigned to a SharePoint group and an email has to be sent to that SharePoint group upon task creation. So I created a SharePoint group in a Task List called “Approvers” and added few people to it. In SharePoint workflow added a “Send an Email” action and added “Approvers” group in “To” section. Published the workflow with no errors. Then I created a task and assigned the task to “Approvers” group. But the workflow was throwing below error in workflow history and was failing to send the email.

"Coercion warning: user or group does not have a valid e-mail address."

Solution: Use the “Return field as” Display Names instead of Email Addresses if you are having a SharePoint group in the email.

Thursday, February 18, 2016

Sorry, we can't seem to connect to the SharePoint Store. Try again in a bit.

Select your web application from CA -> Click on "Manage Features. Activate "Apps that require accessible internet facing endpoints"

Monday, February 9, 2015

SharePoint Administrator Interview Questions


1. What are the authentication methods supported by SharePoint 2013?

   a. Windows Authentication  - NTLM, Kerberos, Digest, Basic
   b. Forms- based authentication
   c. Security Assertion Markup Language (SAML) token based authentication

 2. What are the minimum software requirements for SP 2013 installation?

   WFE - 64 bit Windows server 2012 or 64 bit Windows server 2008 R2 SP1
   SQL - 64 bit SQL Server 2012 or 64 bit SQL server 2008 R2 SP1

3. What is a PassPhrase? 

   It is a password used during the installation of the SharePoint. It is needed every time you add a server to the SharePoint farm.

4. What is deferred site collection upgrade? 

   In SP2013, farm administrators can allow site collection owners to upgrade their sites to new user interface on their own timeline.

5. What is the path for 15 hive?

   15 hive is located C:\Program Files\Common Files\Microsoft Shared\Web Server Entensions\15. This is the path where you can find all the SharePoint core files like config, templates, logs etc.

Monday, January 19, 2015

SharePoint 2013 boundaries, thresholds and limitations

It is at most important to any administrator to know the boundaries, thresholds and limitations of any software you use during capacity planning stage itself for the smooth ride later.

Any SharePoint version has the following hierarchy - Web Application, Content Databases, Site Collections, lists & libraries, columns. Each one of them has limitations by design and also by configurations. Following lists them by hierarchy.

   1.  Web Applications  
   

       Limit       Maximum value
       Number of content databases     500 per farm
       Content database size (general              usage scenarios)     200 GB per content           database
       Content database size (all usage            scenarios)     4 TB per content database
      
2.  Content Databases

       LimitMaximum value
       Number of content databases500 per farm
       Content database size(general usage        scenarios)200 GB per content database
       Content database size (all usage                scenarios)4 TB per content database
       Content database size (document              archive scenario)No explicit content database limit
       Content database items60 million items including documents and list items
      Site collections per content database10,000 maximum (2,500 non-Personal site collections and 7,500 Personal Sites, or 10,000 Personal Sites alone)
     Remote BLOB Storage (RBS) storage     subsystem on Network Attached         Storage (NAS)When SharePoint Server 2013 is configured to use RBS, and the BLOBs reside on NAS storage, consider the following boundary. From the time that SharePoint Server 2013 requests a BLOB, until it receives the first byte from the NAS, no more than 20 milliseconds can pass.





3.  Site Collection Limits

     Limit Maximum value
     Site collections per farm 750,000 (500,000 Personal Sites and 250,000 other sites per farm)
     Web site 250,000 per site collection
     Site collection size Maximum size of the content database
     Number of device channels per           publishing site collection 10



4.  Lists and Library Limits

   Limit Maximum value
   List row size 8,000 bytes per row
   File size 2 GB
   Documents 30,000,000 per library
   Major versions 400000
   Minor versions 511
   Items 30,000,000 per list
   Rows size limit 6 table rows internal to the database used for a list or library item
  Bulk operations 100 items per bulk operation
  List view lookup threshold 8 join operations per query
  List view threshold 5000
  List view threshold for auditors and administrators 20000
  Subsite 2,000 per site view
  Coauthoring in Word and PowerPoint for .docx, .pptx   and .ppsx files 10 concurrent editors per document
  Security scope 50,000 per list

5. Column Limits

   Limit Maximum value
   Single line of text 276
   Multiple Lines of Text 192
   Choice 276
   Number 72
   Currency 72
   Date and Time 48
   Lookup 96
   Yes / No 96
   Person or group 96
   Hyperlink or picture 138
   Calculated 48
   GUID 6
   Int 96
   Managed metadata 94

Friday, January 16, 2015

Did you know?

We all know that there are two recycle bins in SharePoint and we also know about Site collection quotas.

But do you know that stage two recycle bin doesn't count towards site collection quota? Yes it doesn't count towards site collection quota. Stage two recycle bin quota is set depending on site collection quota. By default  stage two recycle bin quota = 50% of site collection quota.



So it is very important to set the site collection quota.

Wednesday, December 17, 2014

SharePoint 2013 system requirements

1.    Minimum Hardware Requirements:
v WFE/App Server
Processor:        64 bit, 4 Cores
            RAM:              Single Server Farm : 24 GB
                                    WFE or app in 3 tier – 12 GB
Hard Disk:       80 GB free for system drive

NOTE: Microsoft recommends to maintain atleast 2X free space as available as RAM.

v Database Server
Processor:      Small deployment 64 bit 4 cores
                                   Medium 64 bit 8 core
RAM:             8GB for small
           16 GB for medium
Hard Disk:      80 GB free for system drive

NOTE: Overall RAM depends on usage models and data size.

2.    Software Requirements:
v WFE/App Server:
64 bit edition of Windows Server 2008 R2 SP1 Standard Enterprise or Data Center.
                                          OR
Windows Server 2012 Standard or Datacenter

v Database Server : 64 bit edition of Microsoft SQL Server 2008 R2 SP1 or Microsoft SQL Server 2012 (For BI Scenarios SQL 2012 SP1 is required)

3.     Client Computer Requirements: 
v Microsoft Office: Microsoft Office 2010 or 2013.

v  SharePoint Designer: SharePoint Designer 2010 only works for 2010 mode sites. SharePoint Designer 2013 works for both 2010 and 2013 mode sites.

v SharePoint Workspace: SharePoint Workspace 2010 works for 2010 mode sites.
SP 2013 introduces new SkyDrive Pro to replace this product – Part of the office client installation.

v Browser Compatibility: IE 8,9 & 10 with 32 bit gives best experience. Since Active x controls doesn't work in 64 bit, IE 8 -10 with 64 bit is supported with limitations.
NOTE: Mozilla, Safari, Google Chrome latest versions is also supported in SP2013 with limitations.