locked
Unable to get PowerPivot 2012 to register Service with SharePoint RRS feed

  • Question

  • I'm currently running a 5-tier SharePoint 2010 SP1 + Dec 2011 CU farm.  On only one App Server I have SSRS 2012 and PowerPivot 2012 (CU3) installed.  I'm unable to get PowerPivot to register the service with SharePoint.  In other words, I do not see the SQL Server PowerPivot System Service on my App Server.  Get-SPServiceInstance also does not show it.  This prevents me from configuring PowerPivot.

    Here is the log which fails on completing the "Register SQL Server Analysis Services (POWERPIVOT) on Local Server" step.

    26/09/12 13:43:07:9606 Verbose: CreateEngineServiceInstance.NeedsExecute
    26/09/12 13:43:07:9606 Verbose: Running function IsFarmConfigured to check whether SharePoint is configured regardless of availability
    26/09/12 13:43:07:9606 Verbose: Farm is configured
    26/09/12 13:43:07:9606 Verbose: Running function IsFarmAvailable to check whether SharePoint farm is available
    26/09/12 13:43:07:9606 Verbose: Farm is configured and not null
    26/09/12 13:43:07:9684 Verbose: Farm is available and has 55 services
    26/09/12 13:43:07:9684 Verbose: Entering function IsServiceInstanceLocal().
    26/09/12 13:43:07:9772 Verbose: Service is not installed.
    26/09/12 13:43:07:9772 Verbose: Service name: MSOLAP$POWERPIVOT
    26/09/12 13:43:08:2763 Verbose: AS service account: domain\service-account
    26/09/12 13:43:08:2763 Verbose: Entering function IsServiceInstanceLocal().
    26/09/12 13:43:08:2773 Verbose: Service is not installed.
    26/09/12 13:43:08:2773 Verbose: Running function IsFarmConfigured to check whether SharePoint is configured regardless of availability
    26/09/12 13:43:08:2773 Verbose: Farm is configured
    26/09/12 13:43:08:2793 Verbose: Running function IsFarmConfigured to check whether SharePoint is configured regardless of availability
    26/09/12 13:43:08:2793 Verbose: Farm is configured
    26/09/12 13:43:08:2793 Verbose: Verifying deployment mode for instance: POWERPIVOT
    26/09/12 13:43:08:2793 Verbose: Service name MSOLAP$POWERPIVOT
    26/09/12 13:43:08:2793 Verbose: Getting Config directory path
    26/09/12 13:43:08:2793 Verbose: ImagePath: "C:\Program Files\Microsoft SQL Server\MSAS11.POWERPIVOT\OLAP\bin\msmdsrv.exe" -s "C:\Program Files\Microsoft SQL Server\MSAS11.POWERPIVOT\OLAP\Config"
    26/09/12 13:43:08:2793 Verbose: Ini file path C:\Program Files\Microsoft SQL Server\MSAS11.POWERPIVOT\OLAP\Config\msmdsrv.ini
    26/09/12 13:43:08:2793 Verbose: Instance POWERPIVOT is a PowerPivot instance.
    26/09/12 13:43:08:2793 Verbose: Entering function IsServiceInstanceLocal().
    26/09/12 13:43:08:2802 Verbose: Service is not installed.
    26/09/12 13:43:08:2802 Verbose: Service instance not found in local server.
    26/09/12 13:43:08:2802 Verbose: CreateEngineServiceInstance.NeedsExecute(True)
    26/09/12 13:43:08:2802 Verbose: CreateEngineServiceInstance.CanExecute
    26/09/12 13:43:08:2802 Verbose: Running function IsFarmConfigured to check whether SharePoint is configured regardless of availability
    26/09/12 13:43:08:2802 Verbose: Farm is configured
    26/09/12 13:43:08:2802 Verbose: Running function IsFarmAvailable to check whether SharePoint farm is available
    26/09/12 13:43:08:2802 Verbose: Farm is configured and not null
    26/09/12 13:43:08:2802 Verbose: Farm is available and has 55 services
    26/09/12 13:43:08:2802 Verbose: Testing that parameters are not null or default values
    26/09/12 13:43:08:2802 Verbose: Parameter name: Password for Analysis Services service account domain\service-account, value: System.Security.SecureString, default value: <Analysis Services Service Account Password>
    26/09/12 13:43:08:2802 Verbose: Value (System.Security.SecureString) for parameter (Password for Analysis Services service account domain\service-account) is set.
    26/09/12 13:43:08:2802 Verbose: Entering function IsServiceInstanceLocal().
    26/09/12 13:43:08:2832 Verbose: Service is not installed.
    26/09/12 13:43:08:2832 Verbose: Service name: MSOLAP$POWERPIVOT
    26/09/12 13:43:08:6937 Verbose: AS service account: domain\service-account
    26/09/12 13:43:08:6937 Verbose: Entering function IsServiceInstanceLocal().
    26/09/12 13:43:08:6937 Verbose: Service is not installed.
    26/09/12 13:43:08:6937 Verbose: Running function IsFarmConfigured to check whether SharePoint is configured regardless of availability
    26/09/12 13:43:08:6937 Verbose: Farm is configured
    26/09/12 13:43:08:6937 Verbose: CreateEngineServiceInstance.CanExecute(True)
    26/09/12 13:43:18:9615 Verbose: CreateEngineServiceInstance.Execute
    26/09/12 13:43:18:9634 Verbose: Entering function IsServiceInstanceLocal().
    26/09/12 13:43:18:9644 Verbose: Service is not installed.
    26/09/12 13:43:18:9654 Verbose: CreateEngineServiceInstance.Execute(Skipped)
    26/09/12 13:43:18:9644 High: Cannot create the service instance because the parent Service does not exist.
    26/09/12 13:43:18:9644 High: Prerequisites check for execution failed. Farm is not in a valid state.
    


    http://sharepoint.nauplius.net

    Wednesday, September 26, 2012 8:44 PM

Answers

  • Ran the PowerPivot config tool to remove all features, services, etc.  Then re-ran the tool and it successfully registered the PowerPivot service with SharePoint.

    http://sharepoint.nauplius.net

    Friday, September 28, 2012 1:47 AM