Friday, September 26, 2014

Stop & Start the Farm Services using powershell script

Get-SPServiceInstance | ? {$_.TypeName -eq "Search Host Controller Service"}

To Stop the Specific Instance ID
Stop-SPServiceInstance -Identity <instance ID>

To Start the Specific Instance ID

Start-SPServiceInstance -Identity <instance ID>

Monday, September 8, 2014

SharePoint - The column name you have entered is already in use or reserved - Solution


SharePoint - The column name you have entered is already in use or reserved. Choose another name
When you’re creating columns either the Site Columns or the List Columns in SharePoint, suddenly it might show a message stating “The column name that you entered is already in use or reserved. Choose another name.” 


Here is the fix for this issue.


1. Goto Site Actions > Site Settings > Modify All Site Settings
2. Under Galleries, choose Site Content Type
3. Select the content type and choose the column
4. Edit the column in new window
5. On your browser address bar, type the following and enter:
javascript:g_FieldName={};alert('Successfully cleared forbidden columns');
6. Be sure you get the 'Successfully cleared forbidden columns' alert before proceeding, if not then something is wrong.
7. Change the column name and Hit OK

Tuesday, September 2, 2014

Increasing BDC Throttle config using powershell


Error:

WCF Service Connector has throttled the response. The response from the WCF service contains more than '500000' bytes. The maximum amount of data that can be read through WCF Service Connector is '500000' bytes. The limit can be changed via the 'Set-SPBusinessDataCatalogThrottleConfig' cmdlet


Resolution:

Run the below PowerShell script in Admin Mode:

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { 
        Add-PSSnapin "Microsoft.SharePoint.PowerShell" 
    } 

$bdcProxy = Get-SPServiceApplicationProxy | where {$_.GetType().FullName -eq ('Microsoft.SharePoint.BusinessData.SharedService.' + 'BdcServiceApplicationProxy')}
$dbRule = Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy
#Default and Maximum must be provided together. This increases the limit for external lists to 3000. 
Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Maximum 1000000 -Default 3000

#This disables a throttling rule. Notice the “:” instead of a space. 
Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Enforced:$false

#This enables a throttling rule. 
Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Enforced:$true