none
PowerPivot Management Dashboard Processing Timer Job Error RRS feed

  • Question

  • We have the following SharePoint 2013 BI farm configuration: 1 SQL 2012 SP1 server for the SharePoint databases, 1 SQL 2012 SP1 server with Analysis instances for PowerPivot and Tabular mode and 1 single SharePoint 2013 server.

    The problem we are facing is with the processing of the PowerPivot Management Dashboard Excel sheet. During the processing of the timer job the following execption is found in de ULS logs on the SharePoint server.

    EXCEPTION: Microsoft.AnalysisServices.AmoException: The 'Database' with 'ID' = 'PowerPivot20Management20Data_febbc76ffbdb4bbfaf9e31e635b160fe_8e4e71112d854575ae6de08cf8dc1c4b_SSPM' doesn't exist in the collection.    
     at Microsoft.AnalysisServices.ModelComponentCollection.GetItem(String key, Boolean throwIfNotFound, String keyPropertyName)    
     at Microsoft.AnalysisServices.DatabaseCollection.get_Item(String id)    
     at Microsoft.AnalysisServices.SPAddin.UsageProcessingTimerJob.RefreshUsageCube(GeminiServiceApplication application)    
     at Microsoft.AnalysisServices.SPAddin.UsageProcessingTimerJob.Execute(Guid targetInstanceId)A

    The given cube is however present in the PowerPivot instance. A SQL Profiler trace does not show any errors and it looks as if the cube is being processed.

    More information on the Excel/PowerPivot/Farm configuration:

    - SQL alias is used to access the database server. This alias is also configured on the Analysis server.

    - PowerPivot and Excel service application both use a domain account. domain\serviceapps. All SharePoint service application this same account.

    - PowerPivot service application is build using the PowerPivot wizard. Afterwards the service account is changed from the farm account to the ssa account (see previous).

    - The ssa account is administrator on the POWERPIVOT OLAP instance.

    - The ssa account is granted permissions on the CA content database using the following PowerShell lines

      $w = Get-SPWebApplication -Identity http://cawebapp

     $w.GrantAccessToProcessIdentity("domain\serviceapps")

    - The PowerPivot OLAP server is added to the Excel services Data Model Settings as <server>\POWERPIVOT.

    - Central Administration website is running NTLM.

    I can't find any similar situation online, so any helpfull information or suggestions are more the welcome.

    Thanks

    Friday, January 10, 2014 11:07 AM

All replies

  • We have the following SharePoint 2013 BI farm configuration: 1 SQL 2012 SP1 server for the SharePoint databases, 1 SQL 2012 SP1 server with Analysis instances for PowerPivot and Tabular mode and 1 single SharePoint 2013 server.

    The problem we are facing is with the processing of the PowerPivot Management Dashboard Excel sheet. During the processing of the timer job the following execption is found in de ULS logs on the SharePoint server.

    EXCEPTION: Microsoft.AnalysisServices.AmoException: The 'Database' with 'ID' = 'PowerPivot20Management20Data_febbc76ffbdb4bbfaf9e31e635b160fe_8e4e71112d854575ae6de08cf8dc1c4b_SSPM' doesn't exist in the collection.    
     at Microsoft.AnalysisServices.ModelComponentCollection.GetItem(String key, Boolean throwIfNotFound, String keyPropertyName)    
     at Microsoft.AnalysisServices.DatabaseCollection.get_Item(String id)    
     at Microsoft.AnalysisServices.SPAddin.UsageProcessingTimerJob.RefreshUsageCube(GeminiServiceApplication application)    
     at Microsoft.AnalysisServices.SPAddin.UsageProcessingTimerJob.Execute(Guid targetInstanceId)A

    The given cube is however present in the PowerPivot instance. A SQL Profiler trace does not show any errors and it looks as if the cube is being processed.

    More information on the Excel/PowerPivot/Farm configuration:

    - SQL alias is used to access the database server. This alias is also configured on the Analysis server.

    - PowerPivot and Excel service application both use a domain account. domain\serviceapps. All SharePoint service application this same account.

    - PowerPivot service application is build using the PowerPivot wizard. Afterwards the service account is changed from the farm account to the ssa account (see previous).

    - The ssa account is administrator on the POWERPIVOT OLAP instance.

    - The ssa account is granted permissions on the CA content database using the following PowerShell lines

      $w = Get-SPWebApplication -Identity http://cawebapp

     $w.GrantAccessToProcessIdentity("domain\serviceapps")

    - The PowerPivot OLAP server is added to the Excel services Data Model Settings as <server>\POWERPIVOT.

    - Central Administration website is running NTLM.

    I can't find any similar situation online, so any helpfull information or suggestions are more the welcome.

    Thanks

    Update 2014-01-10

    Additional SQL profile trace log information indicated that the Farm account needed permissions on the cube, possibly during the query phase. So we added this account as a PowerPivot system administrator.

    This step shouldn't be necessary since only the Excel services application service account needs this permission.

    Can anyone explain why the farm account needs permissions on the PowerPivot Analysis instance?

    Note:

    I used the PowerPivot wizard to create the midtier PowerPivot service application. This creates the service application under the default SharePoint Web Services System Application Pool. I moved this to my own default Service application pool running under account domain\serviceapps.

    Friday, January 10, 2014 3:39 PM
  • have you created powerpivot service application multiple times?

    if config db holds multiple  database entries for powerpivot.

    excel service application my be point to  the old db.

    In this case you neeed to

    uninstall powerpivot

    delete all  left over powerpivot entries in the config db using powershell or stsadm.

    Note:

    Not directly form the DB using Sql command.

    Thanks

    Ravi 


    Ravi

    Monday, March 3, 2014 3:05 AM
  • You already identified the solution. Add the farm account as POWERPIVOT SSAS instance admin.

    This post reflects my opinion on this specific thread. It does not necessarily represent my employer's opinion.

    SharePoint Consultant
    MCSA Windows Server 2008
    MCTS SharePoint 2010, Configuring

    Thursday, April 24, 2014 1:09 PM