SharePoint - Cannot convert a primitive value to the expected type 'Edm.Double'. See the inner exception for more details

If you see this kind of error, make sure that is because the value which you are passing doesnt match with the data type present in the sharepoint list column

make sure what ever you are sending to sharepoint list matches the column data type, to figure out which column is causing the error, remove one by one column/filed in the item which you are passing or else you can check the error.responseText in error

Creating a new task in SharePoint list using CSOM/Rest API

var fieldUserValues = new Array();
      fieldUserValues.push(userId);              //userid is ID of user

$.ajax({
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('Project Tasks')/Items",
type: 'POST',
async: false,
headers: {
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val(),
"X-HTTP-Method": "POST"
},
data: JSON.stringify({
__metadata: {
type: "SP.Data.Project_x0020_TasksListItem"
},
Title: taskName,             
StartDate: taskStartDate,
DueDate: taskDueDate,
PercentComplete: percentageComplete, //percentage complete should be integer
AssignedToId: { "results": fieldUserValues }
}),
success: function(data) {
alert('Item created successfully!');
},
error: function(error) {
alert(JSON.stringify(error));
}
 });

Getting tasks and sub-tasks from task list using SharePoint 2013/SP online and rest API

var fullurl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('Project%20Tasks')/items?$select=*,ParentID/Id,Predecessors,Predecessors/Id&$expand=ParentID,Predecessors";
    $.ajax 
({ 
url: fullurl, 
type: "GET",
headers: {
"accept": "application/json;odata=verbose",
},
success: function (data) {
var items = data.d.results.length;
if(items > 0) 
{ 
var tasks = data.d.results; 

jsonObj = [];
var mainTasks = [], subTasks = [];
$.each(tasks, function (index, task) {
if(task.ParentID.Id) {
item = {}
item ["ParentID"] = task.ParentID.Id
item ["Title"] = task.Title
item ["Priority"] = task.Priority
item ["DueDate"] = task.DueDate
item ["StartDate"] = task.StartDate
item ["PercentComplete"] = task.PercentComplete
item ["Status"] = task.Status
subTasks.push(item);
} else {
item = {}
var startdate = $.datepicker.formatDate( "dd-mm-yy", new Date(task.StartDate));
var duedate = $.datepicker.formatDate( "dd-mm-yy", new Date(task.DueDate));
item ["ID"] = task.Id
item ["Title"] = task.Title
item ["Priority"] = task.Priority
item ["DueDate"] = duedate
item ["StartDate"] = startdate
item ["PercentComplete"] = task.PercentComplete
item ["Status"] = task.Status
mainTasks.push(item);
}
});
},
error: function (error) {
alert(JSON.stringify(error));
}
});  

Minimizing/hiding sub tasks on a tasks list in office 365

By default sharepoint will show all the subtask on a tasks list to minimize them use the below script by adding script editor webpart on tasks pages

<script src="https://sharepointsiteurl/SiteAssets/JS%20file/jquery-1.9.1.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            $(".ms-commentcollapse-icon").click();

        });
</script>

Workflows getting suspended when sending emails outside company domain using SharePoint designer in O365

SharePoint 2013 designer workflows does not allow users to send emails out side their company domain the alternative is to start 2010 workflow from 2013 with email functionality or degrade the workflow version to 2010

Retrieving all list items from a list which has crossed threshold limit in O365/sharepoint online using REST

To retrieve list item from a list which has already crossed the threshold limit i.e. 5000 items in 0365
this can only be done if we have indexed the list previously, i mean we can only query a list which has indexed column which has been created while list creation, in office 365 we cannot increase the threshold limit more than 5000 but we have an option to do that in on perm for up to 20000 items

increasing a threshold limit is not suggested by Microsoft, this will effect the performance, the only option to do this is to pull up data from a large list(more than 5000) in batches, you can batch data up to 4999 in once rest call and need to run untill the total count of the list completes

in the below code "ArchivedList" object will store all the items from a list in batch basis
use the script editor webpart to check this code.

<script src="https://yoursharepointsite/SiteAssets/Java%20Script%20Files/jquery-1.10.2.js"></script>  
<script type="text/javascript">
var ArchivedList = [];
var ListTest=[];
var i=0;
$(document).ready(
       function () {

           var spHostUrl = "https://yoursharepointsite";
           //Build absolute path to the layouts root with the spHostUrl
           var layoutsRoot = spHostUrl + '/_layouts/15/';
           $.getScript(layoutsRoot + "SP.Runtime.js", function () {
               $.getScript(layoutsRoot + "SP.js", getListData);
           }
           ); 
       }
     );
function getDataFromUrl(endpoint) {
     return jQuery.ajax({
         url: endpoint,
         method: "GET",
         headers: {
             "Accept": "application/json; odata=verbose",
             "Content-Type": "application/json; odata=verbose"
         }
     });
}
function getLargeList(nextUrl) {
     var dfd = new $.Deferred();
     if (nextUrl == undefined) {
         dfd.resolve();
         return;
     }
     getDataFromUrl(nextUrl).done(function (listItems) {
         var items = listItems.d.results;
          ListTest=items;
          ArchivedList=ArchivedList.concat(ListTest);
         var next = listItems.d.__next;
   
         $.when(getLargeList(next)).done(function (){
             dfd.resolve();
         });
     });
     return dfd.promise();
}
function getListData() {
     var documentLibName = 'Archived';
     
     https://yoursharepointsite/_api/web/lists/getbytitle(documentLibName)/items?$select=Title,No_Days,Current_x0020_State,Form_x0020_Type,Modified,ContentType/Name,ContentType/Id&$expand=ContentType&$filter=(Modified ge '"+strtDate +"' and Modified le '"+endDate+"') and startswith(ContentTypeId,'0x0120') &$top=200
     var listServiceUrl1= _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('Archived')/Items?$Select=Title,No_Days,Current_x0020_State,Form_x0020_Type,Modified,ContentType/Name,ContentType/Id&$expand=ContentType&$filter=startswith(ContentTypeId,'0x0120')&$top=200";
     
     
     
     var listServiceUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('" + documentLibName + "')/Items?$Select=Title,No_Days,Current_x0020_State,Form_x0020_Type,Modified,ContentType/Name,ContentType/Id&$expand=ContentType&$top=200";
     $.when(getLargeList(listServiceUrl)).done(function () {
            alert(ArchivedList.length);
 });
 }

</script> 

Deleting data from workflow history list using JSON 

copy past the below code in script editor webpart.

<script src="https://sharepoint_yoursite/subsitename/SiteAssets/Java%20Script%20Files/jquery-1.10.2.js"></script>
    <script type="text/javascript">
var clientContext;
var website;
var oList;
var cnt = 0;
var collListItem;
// Make sure the SharePoint script file 'sp.js' is loaded before your code runs.
SP.SOD.executeFunc('sp.js', 'SP.ClientContext', sharePointReady);

// Create an instance of the current context.
function sharePointReady() {
    clientContext = SP.ClientContext.get_current();
    website = clientContext.get_web();
    oList = website.get_lists().getByTitle('Workflow History');

    var camlQuery = new SP.CamlQuery();
    camlQuery.set_viewXml('<View><RowLimit>1000</RowLimit></View>');
    this.collListItem = oList.getItems(camlQuery);

    clientContext.load(website);
    clientContext.load(collListItem, 'Include(Id)');
    clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed));
}

function onQuerySucceeded(sender, args) {

    var listItemInfo = '';
    var listItemEnumerator = collListItem.getEnumerator();

    while (listItemEnumerator.moveNext()) {
        var oListItem = listItemEnumerator.get_current();
        var ID = oListItem.get_id();
        var oListItemDel = oList.getItemById(ID);
        oListItemDel.deleteObject();
        clientContext.executeQueryAsync(Function.createDelegate(this, this.onDeleteSucceeded), Function.createDelegate(this, this.onDeleteFailed));
        console.log(ID + " : Deleted");
    }
}

function onQueryFailed(sender, args) {
    console.log('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}


function onDeleteFailed(sender, args) {
    console.log('Delete failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}

function onDeleteSucceeded(sender, args) {
    cnt = cnt + 1;
    console.log('Delete success : ' + cnt);
}
</script> 

Error: Sorry something went wrong...the file … has been modified by … on in document library or document set

Issue: i am seeing the above error while updating an item inside document library with document set content type, it is happening while updating the item using JQuery code in office 365 with REST calls, and i am do that update for checking out(updating a custom column called checkout) document set and then updating the field columns, so i am seeing this error for the second update of item properties for a document set.

Resolution:

I have resolved this issue by removing the versioning from that particular document library

and the also unchecked the "Automatically update the workflow status to the stage name" and the other JQuery code change which may help resolving the issue is to reload the list before doing a second update using CSOM

Provider hosted app security in SharePoint apps

Check the below link, it was in detail.
https://samlman.wordpress.com/2015/03/02/security-in-sharepoint-apps-part-1/

BCS in Office 365

We can also call BCS an ORM(object relational map)

Secured store service is used to connect to external sources using different accounts apart from the organizational accounts

The main steps involved in devlopemt using BCS are:

1. Creating external content types using designer or VS
2. Importing external content type to BCS
3. Configure the secured store
4. Creating external lists
5. Creating apps

Creation of App level ECT(external content type)

FileBackedMetadatCatalog loads External content type into it to easy access and also for creation of external lists

Specific finder is a method that is used to find one particular item, it is similar to a view on a list but i only returns one item on a list

We are have all the CRUD operational method for ECT to do

Sample code to connect to a list

Debugging Remote Event Recievers

1. We must create a new azure service bus namespace using azure powershell
2. The command give back a connection sting to connect to Azure environment with EndPoint
3. Use this in visual studio for connecting to azure
4. go to project properties
5. inside that go to SharePoint tab
6. Check the enable debugging via Azure service bus
7. copy past the connection string that we got from command prompt
8. insert a breakpoints and click on F5 for debugging

Remote event receivers in SharePoint 2013

The remote events supports

Site - Create, Move, Delete
List - Create, Delete
List schema - Create, Update, Delete
List Item - Create, Update, Delete, Move, CheckIn, UnCheckIn, CheckOut, AttachmentsAdded, AttachemntsRemoved, FileMoved, FileConverted
App - Install, Update, Uninstall

Some Impotent Points to be noted:

• Remote event receivers call across the networks
• After events use WCF(Windows communication foundation) call on remote web so that they do not block the sharepoint host nor delay the response back to the user
• Remote event recievers will only workf if the concern list is present in App Web
• SharePoint hosted apps doesnt support remote event receievers, its only provider hosted apps
• IRemoteEventService an interface thats get inherited in remote event recievers
• We have only two events called "ProcessEvent" which is a two way event and "ProcessOneWayEvent" for one way
• Properties argument defines the event that has fired on a list item
• We will be having only single entry point for all the events
• Properties.ItemEventProperties is for an item events and Properties.ListEventProperties for list events
• SPRemoteEventResult which is used to sent status back to SharePoint(used for sending information and also for canceling the events)

Before events example

After events example

• App Life Cycle events are two way events
• "ProcessOneWayEvent" never file in App related events

This are just brief points about remote event recievers.

points to be noted on Event receivers in SharePoint 2013

properties.ErrorMessage is used for showing error in event handlers

properties.ListItem.Updateoverwriteversion() is used to overwrite version in list item, rather than adding a new version to the item it overwrites the existing one.

this.EventFiringEnable = false or True to stop or start the events on a list item, when ever you use "Updateoverwriteversion()" method inside a event we should set "this.EventFiringEnable= True" to stop the recursion 

SharePoint 2013 People Picker error: “Sorry, we’re having trouble reaching the server.”

If you see the above error while adding users to a group or to a site there are many resolutions which are out there in internet.

but for me i have tried everything which i seen based on the above error but nothing worked out, finally after extending the web application to new port number and deleting the same, the issue got fixed

Hope this helps others.

News feed error: SharePoint could not retrieve the content. Please try again later

If you see this error message, ther could be an issue with user profile service, Authentication issue and may a with distributed cache.

if you have already checked all of the above and still seeing the same issue, then check the microfeeds list and see whether you are able to see the items in it.

if you are not able to see items in micro feeds list, increase the threshold value of lists from 5000 to 10000 or something...

by default administrators have 20000 has the limit for each list so there will be no issues for administrators on news feeds.

we have figured it out when we see the above error while trying to access "Show all replies" inside a news feed.

Hope this helps others.

Oracle LDAP and SharePoint 2013 integration

I have came across a post for oracle and SharePoint 2013 integration, i think this will help other too.

http://blogs.msdn.com/b/ronalg/archive/2014/04/14/sharepoint-2013-and-forms-based-authentication-configuration-for-open-ldap.aspx

Difference between SharePoint 2010 and 2013

Very briefly i will tell what are the major changes in SharePoint 2013 on above of 2010

First thing is it 14 hive folder has been moved to 15 hive folder and it is also called as SP15

Shredded storage this is used for storing the version updates in documents and stores locally
Workflow manager for 2013 which is also called as windows azure workflow which can be only used for SharePoint 2013
workflow service manager - this is an integration layer between SharePoint and workflow manager
workflow manager should be installed in separate farm server where SharePoint is not installed

SharePoint is now with HTML 5

content search web part(CSWP) new in SharePoint 2013

Distributed cache service which is a new service located in services on server this is used for cache in SharePoint and also used for rendering of docs more faster than previous versions

Minimal downloaded Strategy(MDS) : when a document is downloaded to SharePoint server it will create a copy locally and keep it in cache when ever changes happens it will only download the changes that are made not the whole document
MDS will not be enabled for publishing site
Enable minimal download= True is the property for enabling MDS and it is a feature in SharePoint 2013

Now using Open XML/Power point/word 2010 we can create themes in SP15 and the extension for this is .thmx

Three new services had been included in SharePoint service application:

• Machine Translation( only this can be used across farm servers)
• Work Management
• App Management

Usage.xslx is an excel file in webanalytics used to see the usage of user and you can see this option in site settings--> site administration--> property trends

In SP15 webapplications are by default claims based authentication
and this calims based authentication supports

• windows claims
• SAML- based claims
• Forms based authentication claims

Hosted name site collection: these site collections should have public IP and DNS examples for these site collections are
http://hr.adventure-works.com
http://it.adventure-works.com
(SP15) this is a new change in SP15

http://intranet.adventure-works.com/sites/hr
http://intranet.adventure-works.com/sites/it
(sharepont 2010) this is a old version

 SharePoint 2010 Vs. SharePoint 2013 limitations

Limit Name	SharePoint 2010 Maximum Value	SharePoint 2013 Maximum Value
Web application limits
Web application	Not Published	20 per farm
Content database	300 per Web application	300 per Web application
Zone	5 per Web application	5 per Web application
Managed path	20 per Web application	20 per Web application
Solution cache size	300 MB per Web application	300 MB per Web application
Site collection	250,000 per Web application	250,000 per Web application
Web server and application server limits
Application pools	10 per Web server	10 per Web server
Content database limits
Number of content databases	300 per Web application	500 per farm
Content database size (general usage scenarios)	200 GB per content database	200 GB per content database
Content database size (all usage scenarios)	4 TB per content database	4 TB per content database
Content database size (document archive scenario)	No explicit content database limit	No explicit content database limit
Content database items	60 million items including documents and list items	60 million items including documents and list items
Site collections per content database	2,000 recommended 5,000 maximum	2,000 recommended 5,000 maximum
MySites per content database	Not Published	5,000 per content database
Remote BLOB Storage (RBS) storage subsystem on Network Attached Storage (NAS)	Time to first byte of any response from the NAS cannot exceed 20 milliseconds	Time to first byte of any response from the NAS cannot exceed 20 milliseconds
Site collection limits
Site collection	Not Published	2,000,000 per farm
Web site	250,000 per site collection	250,000 per site collection
MySites per farm	Not Published	500,000 per farm
Site collection size	Maximum size of the content database	Maximum size of the content database
Number of device channels per publishing site collection	Not Available in SharePoint 2010	10
List and library limits
List row size	8,000 bytes per row	8,000 bytes per row
File size	2 GB	2 GB
Documents	30,000,000 per library	30,000,000 per library
Major versions	400,000	400,000
Minor versions	Not Published	511
Items	30,000,000 per list	30,000,000 per list
Rows size limit	6 table rows internal to the database used for a list or library item	6 table rows internal to the database used for a list or library item
Bulk operations	100 items per bulk operation	100 items per bulk operation
List view lookup threshold	8 join operations per query	8 join operations per query
List view threshold	5,000	5,000
List view threshold for auditors and administrators	20,000	20,000
Subsite	2,000 per site view	2,000 per site view
Coauthoring in Word and PowerPoint for .docx, .pptx and .ppsx files	10 concurrent editors per document	10 concurrent editors per document
Security scope	1,000 per list	1,000 per list
Column limits
Single line of text	276	276
Multiple Lines of Text	192	192
Choice	276	276
Number	72	72
Currency	72	72
Date and Time	48	48
Lookup	96	96
Yes / No	96	96
Person or group	96	96
Hyperlink or picture	138	138
Calculated	48	48
GUID	6	6
Int	96	96
Managed metadata	94	94
Page limits
Web parts	25 per wiki or Web part page	25 per wiki or Web part page
Security limits
Number of SharePoint groups a user can belong to	5,000	5,000
Users in a site collection	2 million per site collection	2 million per site collection
Active Directory Principles/Users in a SharePoint group	5,000 per SharePoint group	5,000 per SharePoint group
SharePoint groups	10,000 per site collection	10,000 per site collection
Security principal: size of the Security Scope	5,000 per Access Control List (ACL)	5,000 per Access Control List (ACL)
Search limits
Search service applications	20 per farm	20 per farm
Crawl databases	10 crawl databases per search service application 25 million items per crawl database	5 crawl databases per search service application
Crawl components	16 per search service application	2 per search service application
Index components	Not Published	60 per Search service application
Index partitions	20 per search service application 128 total	20 per search service application
Index replicas	Not Available in SharePoint 2010	3 per index partition
Indexed items	100 million per search service application; 10 million per index partition	100 million per search service application; 10 million per index partition
Crawl log entries	100 million per search application	100 million per search application
Property databases	10 per search service application;128 total	10 per search service application;128 total
Link database	Not Available in SharePoint 2010	Two per Search service application
Query processing components	128 per search application 64/(total crawl components) per server	1 per server computer
Content processing components	Not Published	One per server computer
Scope rules	100 scope rules per scope; 600 total per search service application	100 scope rules per scope; 600 total per search service application
Scopes	200 site scopes and 200 shared scopes per search service application	200 site scopes and 200 shared scopes per search service application
Display groups	25 per site	25 per site
Alerts	1,000,000 per search application (seems like a mistake)	100,000 per search application
Content sources	50 per search service application	50 per search service application
Start addresses	100 per content source	100 per content source
Concurrent crawls	20 per search application	20 per search application
Crawled properties	500,000 per search application	500,000 per search application
Crawl impact rule	100	no limit
Crawl rules	100 per search service application	no limit
Managed properties	100,000 per search service application	50,000 per search service application
Values per managed property	Not Published	100
Indexed managed property size	Not Published	512 KB per searchable/queryable managed property
Managed property mappings	100 per managed property	100 per managed property
Retrievable managed property size	Not Published	16 KB per managed property
Sortable and refinable managed property size	Not Published	16 KB per managed property
URL removals	100 removals per operation	100 removals per operation
Authoritative pages	1 top level and minimal second and third level pages per search service application	1 top level and minimal second and third level pages per search service application
Keywords	200 per site collection	200 per site collection
Metadata properties recognized	10,000 per item crawled	10,000 per item crawled
Analytics processing components	Not Available in SharePoint 2010	6 per Search service application
Analytics reporting database	Not Available in SharePoint 2010	Four per Search service application
Maximum eDiscovery KeywordQuery text length	Not Available in SharePoint 2010	16 KB
Maximum KeywordQuery text length	Not Available in SharePoint 2010	4 KB
Maximum length of eDiscovery KeywordQuery text at Search service application level	Not Available in SharePoint 2010	20 KB
Maximum length of KeywordQuery text at Search service application level	Not Available in SharePoint 2010	20 KB
Maximum size of documents pulled down by crawler	Not Available in SharePoint 2010	64 MB (3 MB for Excel documents)
Navigable results from search	Not Available in SharePoint 2010	100,000 per query request per Search service application
Number of entries in a custom entity extraction dictionary	Not Available in SharePoint 2010	1 million
Number of entries in a custom search dictionary	Not Available in SharePoint 2010	5,000 terms per tenant
Number of entries in a thesaurus	Not Available in SharePoint 2010	1 million
Ranking models	Not Available in SharePoint 2010	1,000 per tenant
Results removal	Not Available in SharePoint 2010	No limit
Term size	Not Available in SharePoint 2010	300 characters
Unique terms in the index	Not Available in SharePoint 2010	2^31 (>2 billion terms)
Unique contexts used for ranking	Not Available in SharePoint 2010	15 unique contexts per rank model
User defined full text indexes	Not Available in SharePoint 2010	10
User Profile Service limits
User profiles	2,000,000 per service application	2,000,000 per service application
Social tags, notes and ratings	500,000,000 per social database	500,000,000 per social database
Maximum Number of Users Imported Via FIM	Not Published	1000000
Content deployment limits
Content deployment jobs running on different paths	20	20
Blog limits
Blog posts	5,000 per site	5,000 per site
Comments	1,000 per post	1,000 per post
Business Connectivity Services limits
ECT (in-memory)	5,000 per Web server (per tenant)	5,000 per Web server (per tenant)
External system connections	500 per Web server	500 per Web server
Database items returned per request	2,000 per database connector	2,000 per database connector
Response latency	Not Published	600 seconds
Service response size	Not Published	150,000,000 bytes
Filter Descriptor (in-store)	Not Published	200 per ECT method
ECT Identifier (in-store)	Not Published	20 per ECT
Database Item	Not Published	1,000,000 per request
Workflow limits
Workflow postpone threshold	15	15
Workflow timer batch size	100	100
Workflow associations	Not Published	100 per list
List items or documents that can be bulk created or uploaded to start workflow instances	Not Published	5,000 items
Published workflow definitions per site	Not Published	1,000 per site
Total workflow associations per site	Not Published	1,799 per site
Maximum workflow definition (xaml) size	Not Published	5,120 KB
Maximum depth of a workflow sub-step in xaml (workflow complexity)	Not Published	121 levels
Workflow instance activations per second per web server	Not Published	6 per second
Rest calls from SharePoint workflow per second per web server	Not Published	60 per second
Workflow variable value size	Not Published	256 KB
Maximum list size for workflow lookups to non-indexed fields	Not Published	5,000 items per list view
Maximum list size for auto-start workflow associations	Not Published	10 million items per list
Managed Metadata term store (database) limits
Maximum number of levels of nested terms in a term store	7	7
Maximum number of term sets in a term store	1,000	1,000
Maximum number of terms in a term set	30,000	30,000
Total number of items in a term store	1,000,000	1,000,000
Number of Variation Labels	Not Available in SharePoint 2010	209 per term store
Visio Services limits
File size of Visio Web drawings	50 MB	50 MB
Visio Web drawing recalculation time-out	120 seconds	120 seconds
Visio Services minimum cache age (data connected diagrams)	Minimum cache age: 0 to 24hrs	Minimum cache age: 0 to 24hrs
Visio Services maximum cache age (non-data connected diagrams)	Maximum cache age: 0 to 24hrs	Maximum cache age: 0 to 24hrs
SharePoint Web Analytics service limits
SharePoint entities	30,000 per farm when Web Analytics is enabled	Deprecated
PerformancePoint Services limits
Cells	1,000,000 per query on Excel Services data source	1,000,000 per query on Excel Services data source
Columns and rows	15 columns by 60,000 rows	15 columns by 60,000 rows
Query on a SharePoint list	15 columns by 5,000 rows	15 columns by 5,000 rows
Query on a SQL Server data source	15 columns by 20,000 rows	15 columns by 20,000 rows
Word Automation Services limits
Input file Size	512 MB	512 MB
Frequency with which to start conversions (minutes)	1 minute (recommended)  15 minutes (default) 59 minutes (boundary)	1 minute (recommended)  15 minutes (default) 59 minutes (boundary)
Number of conversions to start per conversion process	For PDF/XPS output formats: 30 x M For all other output formats: 72 x M Where M is the value of Frequency with which to start conversions (minutes)	For PDF/XPS output formats: 30 x M For all other output formats: 72 x M Where M is the value of Frequency with which to start conversions (minutes)
Conversion job size	100,000 conversion items	100,000 conversion items
Total active conversion processes	N-1, where N is the number of cores on each application server	N-1, where N is the number of cores on each application server
Word Automation Services database size	2 million conversion items	2 million conversion items
SharePoint Workspace limits (Renamed to Office Live Workspace)
Office Live Workspace list items	30,000 items per list	30,000 items per list
Office Live Workspace documents	1,800 documents limit in SharePoint Workspace	1,800 documents in Office Live Workspace
OneNote limits
Number of Sections and Section Groups in a OneNote Notebook (on SharePoint)	See limit for "Documents" in List and library limits	See limit for "Documents" in List and library limits
Maximum size of a section	See limit for "File size" in List and library limits	See limit for "File size" in List and library limits
Maximum size of an image, embedded file, and XPS OneNote printout in a OneNote section.	See limit for "File size" in List and library limits	See limit for "File size" in List and library limits
Maximum size of all images, embedded files, and XPS printouts in a single OneNote page.	Default limit is double the "File size" limit.	Default limit is double the "File size" limit.
Merge operations	One per CPU core per Web server	One per CPU core per Web server
Excel Services limits
Maximum workbook size	Not Published	10 MB
Machine Translation Service limits
Input file size for binary files	Not Available in SharePoint 2010	524,288 KB per file
Input file size for text files	Not Available in SharePoint 2010	15,360 KB per file
Maximum character count for Microsoft Word Documents	Not Available in SharePoint 2010	10,000,000 per document
Total concurrent translation processes	Not Available in SharePoint 2010	5
Delay between translations	Not Available in SharePoint 2010	59 minutes
Number of translations per translation process	Not Available in SharePoint 2010	1,000 per process
Maximum concurrent translation requests	Not Available in SharePoint 2010	300
Files per translation job	Not Available in SharePoint 2010	100,000 files
Machine Translation Service database size	Not Available in SharePoint 2010	1,000,000 files
Office Web Application Service limits
Cache size	100 GB	100 GB
Renders	One per document per second per CPU core per application server (maximum eight cores)	One per document per second per CPU core per application server (maximum eight cores)
OneNote concurrent merge operations	Not Available in SharePoint 2010	8 per document
Project Server limits
End of project time	Date: 12/31/2049	Date: 12/31/2049
Deliverables per project plan	1,500 deliverables	1,500 deliverables
Number of fields in a view	256	256
Number of clauses in a filter for a view	50	50
SharePoint Apps limits
Maximum Access app size on Office 365/SQL Azure	Not Available in SharePoint 2010	100 Mb
Apps displayed in Manage Licenses page	Not Available in SharePoint 2010	2,000
Number of app licenses per tenant	Not Available in SharePoint 2010	1,000,000
Number of apps displayed in the Add an App page	Not Available in SharePoint 2010	240
Number of managers per app license	Not Available in SharePoint 2010	30
Number of app licenses assigned to a user viewable by that user	Not Available in SharePoint 2010	2,000
Number of apps in the corporate catalog viewable by a single user	Not Available in SharePoint 2010	500
Miscellaneous limits
Number of User agent substrings per device channel	Not Available in SharePoint 2010	150
Number of SharePoint sources per EDiscovery case	Not Available in SharePoint 2010	100
Number of Exchange sources (mailboxes) per EDiscovery case	Not Available in SharePoint 2010	1500
Maximum size of EDiscovery Query	Not Available in SharePoint 2010	16K characters or 500 keywords
Number of nodes in managed navigation term set	Not Available in SharePoint 2010	2000