Udostępnij za pośrednictwem

Remove PowerPivot for SharePoint (PowerPivot Configuration Tool)

  • Artykuł

Uninstalling PowerPivot for SharePoint from a SharePoint farm is a multi-step process that includes using tools or script to remove features and solutions from SharePoint, followed by SQL Server Setup to remove program files and registry settings on a local computer.

This topic explains how to remove features and solutions using the PowerPivot Configuration Tool. Removing features and solutions is part of broader set of task that uninstall the software. Before removing features and solutions, review this topic to learn about steps that precede and follow this one: Uninstall PowerPivot for SharePoint.

Requirements for using the configuration tool

You must be a farm administrator, a server administrator on the Analysis Services instance, and db_owner on the farm’s configuration database.

Use the appropriate version of the configuration tool for the version of SharePoint. Do not use either tool with SQL Server 2008 R2 installations.

Verify that the SharePoint Administration service is running.

Run the PowerPivot Configuration Tool to remove features and solutions

Before you run SQL Server 2012 Setup to uninstall program files, you can run the PowerPivot Configuration Tool to remove features and solutions from the farm.

  1. Note the configuration tools are only listed only when PowerPivot for SharePoint is installed on the local server.On the Start menu, point to All Programs, click Microsoft SQL Server 2012 , click Configuration Tools, and then click one of the following:

    • PowerPivot for SharePoint 2013 Configuration

    • PowerPivot Configuration Tool

  2. Select Remove Features, Services, Applications, and Solutions and then click OK.

  3. Optionally, expand the window to full size. You should see a button bar at the bottom of the window that includes Validate, Run, and Exit commands.

  4. Review each action in the task list to understand what each one does.

    In Remove PowerPivot Service Applications, you are given the option of deleting application data associated with the service application. The application data is a SQL Server database that was created with the service application for the purpose of storing data refresh schedules, database instance information, usage data, and other data used by PowerPivot for SharePoint. It does not store user files, such as PowerPivot workbooks. Unless you have a specific reason to keep the application data (for example, if you have data retention policies related to data refresh or data access) you can delete the application database without removing any files that were created or saved by SharePoint users.

    To delete the database, select Remove PowerPivot Service Applications and then select the Delete application data associated with this service application.

  5. Optionally, review detailed information in the Output tab or Script tab.

    The Output tab is a summary of the actions that will be performed by the tool. This information is saved in log files at:.

    C:\Program Files\Microsoft SQL Server\110\Tools\PowerPivotTools\ConfigurationTool\Log

    The Script tab shows the PowerShell cmdlets or references the PowerShell script files that the tool will run.

  6. Click Validate to check whether each action is valid. If Validate is not available, it means that all of the actions are valid for your system.

  7. Click Run to perform all of the actions that are valid for this task. Run is available only after the validation check is passed. When you click Run, the following warning appears, reminding you that actions are processed in batch mode: “All of the configuration settings that are flagged as valid in the tool will be applied to the SharePoint farm. Do you want to continue?”

  8. Click Yes to continue.

After the features and solutions are removed, continue with the remaining steps described in this topic: Uninstall PowerPivot for SharePoint.

Troubleshooting errors

Sometimes errors will occur that prevent the task from completing. You can view error information in the Parameters pane for each action.

For problems related to solution deployment or retraction, verify the SharePoint 2010 Administrator service is started. This service runs the timer jobs that trigger configuration changes in a farm. If the service is not running, solution deployment or retraction will fail. Persistent errors indicate that an existing deployment or retraction job is already in the queue and blocking further action from the configuration tool.

To find and remove a deployment or retraction job that is already in the queue, do the following:

  1. Start the SharePoint Management Shell as an administrator and then run the following command to view jobs in the queue:

    Stsadm –o enumdeployments

  2. Review existing deployments for the following information: Type is Retraction or Deployment, File is powerpivotwebapp.wsp or powerpivotfarm.wsp.

  3. For deployments or retractions related to PowerPivot solutions, copy the GUID value for JobId and then paste it into the following command (use the Mark, Copy, and Paste commands on the Shell’s Edit menu to copy the GUID):

    Stsadm –o canceldeployment –id “<GUID>”

  4. Retry the task in the configuration tool by clicking Validate followed by Run.

For all other errors, check the ULS logs. For more information, see Configure and View SharePoint Log Files and Diagnostic Logging (PowerPivot for SharePoint).