Databases running in compatibility range, upgrade recommended (for BdcServiceDatabase)

The SharePoint Health Analyzer showed the below error after March 2013 PU Upgrade for SharePoint 2013.

Title:  Databases running in compatibility range, upgrade recommended. 

Severity: 2 - Warning 

Category: Configuration 

Explanation:

The following databases have versions that are older than the current SharePoint software, but are within the backwards compatible range:SP_BDC_DB

- When I browsed to the Upgrade and Migration -> Review database status

Resolution

Run the below command in SharePoint Management Shell

(Get-SPDatabase | ?{$_.type -match "BdcServiceDatabase"}).Provision()

Now if you try to open the BCS Service Application you get the below error.

To fix this give the BCS Service Applications’ App Pool Account SPDataAccess on the BCS database.

PowerPivot: Secondary Logon service (seclogon) is disabled

Title:  PowerPivot: Secondary Logon service (seclogon) is disabled 

Severity:  2 - Warning 

Category: Configuration 

Explanation: Secondary Logon service (seclogon) is disabled

Resolution

Enable secondary Logon service (seclogon).

1) Login to the servers in the farm.

2) Run -> services.msc -> Secondary Logon -> Start

InfoPath Forms Services forms cannot be filled out in a Web browser because no State Service connection is configured.

Title:  InfoPath Forms Services forms cannot be filled out in a Web browser because no State Service connection is configured. 

Severity:  2 - Warning 

Category: Configuration 

Explanation:

InfoPath Forms Services is not functional on the following Web applications because there is no service connection configured for the State Service: SharePoint - 80  

Resolution

If a State Service application doesn't exist, create one by using the new-SPStateServiceApplication Powershell commandlet.

$stateName = "State Service Application"

$stateDBName = "SP_DB_State_Service"

$stateDB = New-SPStateServiceDatabase -Name $stateDBName

$state = New-SPStateServiceApplication -Name $stateName -Database $stateDB

New-SPStateServiceApplicationProxy -Name "$stateName Proxy" -ServiceApplication $state

-DefaultProxyGroup

DisplayName                 TypeName                                Id

-----------                     --------                                      --

State Service App...        State Service Proxy                    3c******-****-****-a8c4-5****008****

PowerPivot: Usage data is not getting updated at the expected frequency

I was getting the below warning from Central Administration SharePoint Health Analyzer

Title:  PowerPivot: Usage data is not getting updated at the expected frequency. 

Severity:  2 - Warning 

Category:  Configuration 

Explanation:

The PowerPivot Management Data.xlsx file is not being updated. This workbook stores internal data used by the PowerPivot Management Dashboard. The current file for PowerPivot service application <0> was last updated 5 day(s) ago.

Resolution

1) Check under what account the PowerPivotUnattendedAccount is running.

2) Open SQL Management Studio and browse to Security -> Logins

3) Give db_datareader permission to PowerPivotUnattendedAccount for the PowerPivot Service Application database

Checked out and editable

If you see the above message in any of you SharePoint pages, it is because publishing feature has been enabled on your site. Whenever you make a change, you will see this yellow bar on top of the page.

Fix

After you are done making changes on the page, go to the Publish tab on the page and Publish

STSADM for Starting and Stopping Sharepoint services on a farm

Today a colleague wanted to stop some SharePoint services using PowerShell. I tried doing the same in STSADM.This is how you do the same using STSADM

To list out all Sharepoint services

stsadm -o enumservices [I am listing only some of them below]

<Services>

  <Service>

    <Type>Microsoft.Office.Access.Server.MossHost.AccessServerWebService, Microsoft.Office.Access.Server, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type>

    <Name />

    <DisplayName>Access Services 2010</DisplayName>

    <Status>Disabled</Status>

  </Service>

  <Service>

    <Type>Microsoft.Office.SecureStoreService.Server.SecureStoreService, Microsoft.Office.SecureStoreService, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type>

    <Name />

    <DisplayName>Secure Store Service</DisplayName>

    <Status>Disabled</Status>

  </Service>

  <Service>

    <Type>Microsoft.Office.Server.PowerPoint.Administration.PowerPointConversionService, Microsoft.Office.Server.PowerPoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type>

    <Name />

    <DisplayName>Microsoft.Office.Server.PowerPoint.Administration.PowerPointConversionService</DisplayName>

    <Status>Disabled</Status>

  </Service>

<Service>

  <Type>Microsoft.SharePoint.BusinessData.SharedService.BdcService, Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type>

  <Name />

  <DisplayName>Business Data Connectivity Service</DisplayName>

  <Status>Disabled</Status>

</Service>

<Services>

To start a service

stsadm -o provisionservice -action start -servicetype Microsoft.SharePoint.BusinessData.SharedService.BdcService

To stop a service

stsadm -o provisionservice -action stop -servicetype Microsoft.SharePoint.BusinessData.SharedService.BdcService

If this is a Web service, IIS must be restarted for the change to take effect.  To restart IIS, open a command prompt window and type "iisreset /noforce".

Running SharePoint Configuration Wizard

Whenever a change is made on a SharePoint farm (like adding or removing a server from the farm), it is advisable to run the configuration wizard to sync the servers in the farm. Or when you do a Cumulative Update. Below is how you do it.

1. Login to the servers in the farm as setup account.

2. Start -> SharePoint 2010 Products Configuration wizard

3. Click Next (on the Welcome page of configuration wizard)

 

4. Choose Yes (for restarting the service)

5 .Select Do not disconnect from this server farm (on the Modify server farm Settings page)

 6. Choose the default option (on the Modify SharePoint Central Administration Web Application Settings page)

7. On the Summary page, verify the displayed information and select Next

8. The configuration wizard runs and click Finish once the wizard completes

 

 

9. If the farm configuration wizard opens, cancel it.

 

 

Removing a Server from the SharePoint farm

1. Login to the servers in the farm as setup account.

2. Start -> SharePoint 2010 Products Configuration wizard

3. Click Next (on the Welcome page of configuration wizard)
 

4. Choose Yes (for restarting the service)

 

5 .Select Disconnect from this server farm (on the Modify server farm Settings page)

 

6. Choose Yes and proceed to remove the server from the SharePoint farm

 

7. The configuration wizard runs and click Finish once the wizard completes

 

The object was not found. (Error from SharePoint site: HttpStatusCode NotFound The request failed with HTTP status 404: Not Found.)

I was checking the crawl logs for my Search Service application and was seeing the below error many times

The object was not found. (Error from SharePoint site: HttpStatusCode NotFound The request failed with HTTP status 404: Not Found.)

Cause

This because a file that was previously stored in Sharepoint and the crawler couldn’t find the object anymore. This could have been because the file was deleted or the access was denied. So the crawler would keep on trying to crawl the object for 30 times or 720 hours.

When the crawler encounters an access denied or a file not found error, the item is deleted from the index if the error was encountered in more than ErrorDeleteCountAllowed (the value for this is 30) consecutive crawls AND the duration since the first error is greater than ErrorDeleteIntervalAllowed (the value for this is 720 hours or 30 days). If both conditions are not met, the item is retried.

We can manage this deletion policy at the service application level to specify how many times and how long an item will be retried in consecutive crawls. This policy existed in Microsoft Office SharePoint Server 2007, but you could not view them nor change their values.

Resolution

Either you wait for 30 days for the errors to go away or you modify the default values.

$ssa = Get-SPEnterpriseSearchServiceApplication

To view the current value of a property:

$ssa.GetProperty("<PropertyName>")

To change the value of a property:

$ssa.SetProperty("<PropertyName>", <NewValue>)

The Property Name here would be ErrorDeleteCountAllowed and ErrorDeleteIntervalAllowed 

Read this article in TechNet to know more about the other deletion policies in SharePoint 2010 Search

Windows files opening on single click and underlined

Problem Description

Recently Ii had an issue with my Windows 7 desktop. All my files were opening on single click rather than double.Also I noticed that all filenames in my system was underlined

Fix

1. Browse to Control Panel -> Folder Options.

2. In the General Tab -> Click items as follows section, select Double click to open an item (Single click to select) option -> Click OK.