Archive for January, 2011

Increase the Default Throttle Size from 2000 for BCS in SharePoint 2010

January 26, 2011 Leave a comment


1) Open Microsoft SharePoint PowerShell

a) Go to Start>All Programs > SharePoint 2010 Products >

b) Right Click on SharePoint 2010 Management Shell to open the Powershell as an Administrator.

2) Type the following command:

Command # 1 :

$bdcProxy = Get-SPServiceApplicationProxy | where {$_.GetType().FullName –eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}

Command #2 :

Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy | Set-SPBusinessDataCatalogThrottleConfig -Maximum 100000000 -Default 500000

Command #3 :

Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy

Verify that the output looks like this:


Scope : Database

ThrottleType : Items

Enforced : True

Default : 500000

Max : 100000000

Categories: PowerShell, SharePoint Tags: , ,

CAML Query WHERE Clause not working and returning all records

January 12, 2011 5 comments

One thing I found about CAML query in SharePoint Development is when you put WHERE Clause in query it still returns all records.

For example:

SPQuery query = new SPQuery();
query.Query =

Here is the Fix:

Remove the “<Query> Tag and rewrite it

SPQuery query = new SPQuery();
query.Query =


This should fix it .



Categories: SharePoint Tags: ,

Failed to create workflow association .Cannot find SharePoint list with name. SharePoint 2010 Workflow

January 10, 2011 Leave a comment

This is one of the common issues when we try to deploy a workflow in another environment Or to a different List.

Here is the resolution:

In Visual Studio 2010 :

  1. Right Click on the “Workflow1” under Solutions Explorer and Click “Properties”

  1. Click on “…” next to Target List and it will launch the Workflow Wizard

    3 ) Select the new associations , compile and Deploy