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_datareaderpermission to PowerPivotUnattendedAccount for the PowerPivot Service Application database