Sunday, September 1, 2013

List View Threshold

List View Threshold

Sometimes you might face a situation where you get this error:

9239 items (list view threshold is 5000)

The number of items in list exceeds the list view threshold, which is 5000 items.  Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.

Even though it is recommended to use prescribed limits in your queries, but

Thursday, August 1, 2013

List and Site templates in SharePoint

List Templates

Any List/Library in SharePoint can be saved as template (STP) .

Go to List/Library > Library Settings > Save document Library as Template

  1. Provide File Name, Template Name and Template description ( you can choose to include content of source in the template)

  2. You can visit List template gallery (Site settings > List template gallery) , and your template will be found saved there.  You can easily open the list template gallery in explorer view and extract the stp file on your hard disk. This can be uploaded on any site collection as target.

  3. This template is available for new list creation in current site collection wherever this List template stp file is available under List Template Gallery. Visit Site Content >Add an App > you will find your template to create new List/Library here.

  • You would be able to create a List/Library with same set of columns and views as the source of template

Please visit Library settings and observe different list settings like version setting metadata navigation, security etc.


Site Templates

A sub site can also be saved as template.

Go to site settings > Save site as Template

  1. Provide File Name, Template Name and Template description. Description (you can choose to include content of source sub site’s list and libraries in the template.)

  2. Please note site template is being saved as a wsp under Solution Gallery ( /_catalogs/solutions/forms/allitems.aspx)  This can be uploaded on any site collection as target.


  1. Go to Site content > New sub site > under template choose custom   and you can create a replica of source sub site.



  • Security settings are not saved in List / site Templates

  • Default max size for list/site templates is 50 MB which can be changed by administrator. But you won’t go beyond 500 MB though

$tSize = 50000000

$myW = [Microsoft.SharePoint.Administration.SPWebService]::ContentService

$myW.MaxTemplateDocumentSize = $tSize



  • List definition / site definition based on which source list / sub site was created, must be present on target.

  • List / site templates are saved in content data base of site collection.

  • Once target is created using a template, it has no relation with template. These templates are only scripts to create the target. If you missed something in source before creating a template, redo creation of target.

  • If you are looking for code level high customization on the top of default list definition, better you choose custom list definition than list/ site templates.

Wednesday, July 24, 2013

Cannot create Variation site because the parent Publishing web cannotbe found. Ensure the parent Publishing web has been spawned and tryagain

To create a child variation to root variation we create a new label under Variation Labels [http://newServerName/_Layouts/_Layouts/VariationLabels.aspx] and after this click on Create Hierarchies button on this page. 

When timer job "Variations Create Hierarchies Job Definition" runs , it tries to create the child variation site including subsite of child variations. This also includes publishing Pages Library and publishing pages.
Current status can be verified under Variation Logs[http://newServerName/_Layouts/VariationLogs.aspx]
I was trying to use timer job "Variations Create Hierarchies Job Definition" to create a child variation [es-LA] to root variation[en-US] .

But I was getting error (under Variation Logs) :

A new site sub1Site1 did not get created under Label es-LA by the variation system for source site http://newServerName/en-US/sub1Site1. Cannot create Variation site because the parent Publishing web cannot be found. Ensure the parent Publishing web has been spawned and try again.


Pages did not get created under Label es-LA by the variation system for source publishing web http://newServerName/en-US/sub1Site1 because the target publishing web cannot be determined.

Below mentioned solutions did not work for me :

1. Fix the possible misalignments like problem in the relationships list[http://newServerName/Relationships List/AllItems.aspx] using VariationFixUpTool.
2. In the SharePoint file C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Resources\ (installed by the language pack for Spanish)

Change the value of List_Pages_UrlName as seen below

<Data Name="List_Pages_UrlName">




<Data Name="List_Pages_UrlName">



Save the file. Now go and restart the SharePoint 2010 Timer service. Then create the Spanish Variation.  [

Eventhough "List_Pages_UrlName" solution did not work for me for this specifc problem , but with Spanish sites you get funky behaviour out of URLS retrived from Microsoft.SharePoint.Publishing.PublishingWeb.PagesList SPobjects ,
you can give it a try !!!!]

Below mentioned solution worked for me :
1. Disable all custom built features on root variation. (spweb level features)
2. Now create new Label , submit variation creation on Variation Labels and run timer job "Variations Create Hierarchies Job Definition".
3. I was still facing issue 0x80070057 which is discussed here as a separate thread.
4. After resolving issue 0x80070057 , child variation was created.
5. Now enable all custom built features on both root variation and child variation.

Access "Pages" Library for Chinese Locale

Monday, July 22, 2013

Few Questions to be answered before you start a SharePoint project

Few Questions to be answered before you start a SharePoint project:

  1. Are you looking for a public facing site or an intranet portal? Do you need subset of information available on intranet to be published to outer word? Do you want to develop a portal as one stop solution for whole organization or it will be in parallel with various other system with scattered information e.g. user profiles , etc.

  2. What are the maximum users we want to target in next 5 years?

  3. Do you want to pre-plan for multilingual scenarios?

  4. The user policies and permission must be strictly defined well ahead and direct access (without SharePoint user groups) to content must be eliminated. Owners who define will manage the security must be clear and precise and well trained how to manage security in SharePoint.  Administrators and owners, who don’t know how to manage security, are the biggest loop holes in the security chain.

  5. Ownership of servers and management is a pain in butt at later stages, so must be documented and defined during initial stages.

  6.  Read only search accounts must be predefined. Using administrators as search accounts is a big security loop hole.

  7. Security patches and Upgrades for Windows Servers SharePoint SQL must be scheduled and monitored.  Blocking them forever is inviting hackers to dump the system.

  8. Antivirus scans are often ignored during planning stages. Never do that.

  9. It must be defined clearly what all need to be blob cached and duration of caching must be precise and documented. According front end server configuration might have to be changed. You may never want to blob cache secured contents.

  10. To avoid more expenditure on future upgrades maximize utilization of out of box features of SharePoint.

  11. You may never want to expose underlying framework information through headers . Plan for that during initial stages , if it is a public facing site .

  12. You may want to rely on Google analytic to understand Visitor flow and improvise the site accordingly during later stages . Plan for this .

  13. What might be the external systems from where information flows in or goes out of SharePoint future system . Plan security and minimize / define  and document the limitations .

  14. Do you want to go for automatic TFS / 3rd party deployments or want a more controlled deployments with dedicated administrator ?

  15. Have you take sign off on all the relevant SharePoint features to be accommodated in the ecosystem with capacity planning and infrastructure involved to avoid performance hits at later stages ?

You are requested to add more here as comments based on what you had to go through in your previous projects  . 

You may also like:
MOSS 2007 Troubleshooting Guide

Wednesday, June 26, 2013

Faulting application name: CcmExec.exe, version: 4.0.6221.1000, timestamp: 0x 339 6 Faulting module name: ntdll.dll, version:6.1.7601.17725, time stamp: 0x c4 8f

Ccmexec.exe refers to CCM Executive and operates as a component of the Microsoft SMS Agent Host for Microsoft Systems Management Server which handles Change and Configuration Management utility.

The error I was getting :

Log Name: Application
Source: Application Error
Date: x/xx/xxx xx:xx:xx xM
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: xxxxxxx
Faulting application name: CcmExec.exe, version: 4.0.6221.1000, time stamp: 0x 339 6
Faulting module name: ntdll.dll, version: 6.1.7601.17725, time stamp: 0x c4 8f
Exception code: 0xc0000005
Fault offset: 0x0009ce74
Faulting process id: 0xbf8
Faulting application start time: 0x01 5e9 49 2bc
Faulting application path: C:\Windows\SysWOW64\CCM\CcmExec.exe
Faulting module path: C:\Windows\SysWOW64\ntdll.dll
Report Id: 59e021fb-dd92-11e2-bf93-0050568d00ab
Event Xml:
<Event xmlns="">
<Provider Name="Application Error" />
<EventID Qualifiers="0">1000</EventID>
<TimeCreated SystemTime="2013-06-25T12:25:42.000000000Z" />
<Security />

Suggested read : System Center Configuration Manager 

You may also like:

The COM+ System Application service entered the running state.

The application-specific permission settings do not grant Local Launch permission

MSDTC encountered an error (HR=0x80000171) while attempting to establish a

Question: The backing-file for the real-time session “WDC.BE95A9B1-DE15-4B78-B923-A12AB70BE951” has reached…

Tuesday, June 25, 2013

Monitor traffic b/w SQL server and front end

I want to monitor SQL traffic b/w Front End and SQL server. What could be the best approach for this ?

Reason :

In our uls logs , we are getting message :

Process : OWSTIMER.EXE (_x-_-_)
Thread ID : _x-_-_
Area : SharePoint Foundation
Category : Database
Event ID : f-_-
Level : Monitorable

Message :

A large block of literal text was sent to sql. This can result in blocking in sql and excessive memory use on the front end. Verify that no binary parameters are being passed as literals, and consider breaking up batches into smaller components. If this request is for a SharePoint list or list item, you may be able to resolve this by reducing the number of fields.

QL Profiler:

You may also like:

Question : Thread was being aborted : PerfmonInstanceIncrement

In our uls logs , we are getting message :

Process : w3wp.exe (_x-_-_)
Thread ID : _x_-_-
Area : SharePoint Server
Category : General
Event ID : 7-_-
Level : Warning

Message :

A runtime exception was detected. Details follow. Message: Thread was being aborted. Technical Details: System.Threading.ThreadAbortException: Thread was being aborted. at Microsoft.Office.Server.Diagnostics.ULS.NativeMethods.DoPerfmonInstance(Int32 instanceHandle, UInt32 pcid, Int64 lValue, PerfmonAction pcvo) at Microsoft.Office.Server.Diagnostics.ULS.PerfmonInstanceIncrement(Int32 instanceHandle, PCIDBase pcid, Int64 value)

Please help us identify the root cause and resolution for this .

We have also updated SPWebService.CollectSPRequestAllocationCallStacks property

You may also like:

Question : Memory Leak : Microsoft.SharePoint.SPRequestManager.GetContextRequest(SPRequestAuthenticationMode authenticationMode)

Question: The backing-file for the real-time session “WDC.BE95A9B1-DE15-4B78-B923-A12AB70BE951” has reached…

MOSS 2007 Troubleshooting Guide

Question : what is arpirowupdater.hxx ?

Question : what is merge.cxx ?