Home » SharepointRSS

Errors PowerPivot in SharePoint

Hi guys,

I'm having many problems to use PowerPivot in my SharePoint 2010.

I make the install SQL Server 2008 R2 without configure the SharePoint Integration to use Gemini/PowerPivot. After i install and configure the SharePoint 2010, after that i run SQL Server 2008 R2  setup and configure the integration Gemini/PowerPivot and the end of setup show an error message, but was executed completed.

I open the file log and encountered the message:

Error: Action "Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction" threw an exception during execution.
Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.AnalysisServices.SharePoint.Integration, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIConfigExtension.UpdateEngineServiceInstanceIMBIVersionAndUnprovisionedBySetupBit(Version imbiVersion)
at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction.ConfigExistingFarmFirstASserver()
at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction.ExecuteAction(String actionId)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.

After that i open the SharePoint and activated the Gemini feature in Central Administration, I created a gallery for PowerPivot (I remember that read anything about this a guess this must be created automatically), but when i try to use de gallery a received this messagem Error:

"Could not load type 'Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView'."

I try to reinstall the feature using the setup of SQL Server 2008 R2, but i received a message saying that already the feature install in my Farm.

Somebody have any idea to my help me?

I thanks a lot.
gcardoso

 

6 Answers Found

 

Answer 1

If you can provide detail on
- OS version and whether you have installed the hotfix as required before install SharePoint
- where you get the install files, the version of install files,
- and the exact options you have selected during each step, for instance, when you install SQL Server 2008 R2 after you have installed and configured SharePoint, what option did you select, did you select New Farm, or Existing Farm, etc,

it would help narrow down the problem.

Also AS product team has posted a detailed troubleshooting writeup in http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/thread/dd119dca-961b-4e8f-83a0-bba5c9ef81df, you might want to review it first before taking any further step.

Thanks,
Lisa

 

Answer 2

I have the same issue for several times.
At the following my steps of installation

1. Windows 2008 R2 - 64 bit
2. SQL Server 2008 R2 November CTP - 64 bit
3. WCF Fix: Sharepoint Shared Services Roll
4. SharePoint Serber 2010 - 64 bit  (Options:
Server Farm and Complete - Install all components)
Don't start the configuration wizarad at the end
5. SQL Server 2008 R2 November CTP new Instance :
Analysis Services with SharePoint Integration with Option: new Farm


please have a look at my detail error file:

2009-12-15 13:35:51 Slp: Error: Action "Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction" threw an exception during execution.
2009-12-15 13:35:51 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
2009-12-15 13:35:51 Slp: File name: 'Microsoft.AnalysisServices.SharePoint.Integration, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
2009-12-15 13:35:51 Slp:    at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIConfigExtension.UpdateEngineServiceInstanceIMBIVersionAndUnprovisionedBySetupBit(Version imbiVersion)
2009-12-15 13:35:51 Slp:    at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction.CreateAndConfigNewFarm()
2009-12-15 13:35:51 Slp:    at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction.ExecuteAction(String actionId)
2009-12-15 13:35:51 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
2009-12-15 13:35:51 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
2009-12-15 13:35:51 Slp: WRN: Assembly binding logging is turned OFF.
2009-12-15 13:35:51 Slp: To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
2009-12-15 13:35:51 Slp: Note: There is some performance penalty associated with assembly bind failure logging.
2009-12-15 13:35:51 Slp: To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
2009-12-15 13:35:51 Slp:    --- End of inner exception stack trace ---
2009-12-15 13:35:51 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
2009-12-15 13:35:51 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
2009-12-15 13:35:51 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
2009-12-15 13:35:51 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2009-12-15 13:35:51 Slp: The configuration failure category of current exception is ConfigurationFailure
2009-12-15 13:35:51 Slp: Watson Bucket 1
 Original Parameter Values
 

Answer 3

Likely an improperly uninstall or a repair operation was ran. This leaves the server in the state where it believes that the assembly is present, but we've already deleted it as part of the uninstall or repair. There are workarounds, but you must uninstall SharePoint and go back to the beginning. See http://powerpivotgeek.com/server-installation/reported-problems/#006 and http://powerpivotgeek.com/server-installation/reported-problems/#HowTo000 for more information.

Hope that helps.
 

Answer 4

In the Installation Wizard step to let you confirm your configuration, i get the location of the ConfigurationFile.ini file. I opened the file to find that the TCP/IP port of the SharePoint Central Administration site is incorrect. I modified the port number and saved the file, then this error does not appear.

BTW, before this, i also installed the WCF hotfix someone else mentions. So, i am not so sure of which action actually had fixed the error.
 

Answer 5

The port change did it! Thanks a lot!

 

Answer 6

Likely an improperly uninstall or a repair operation was ran. This leaves the server in the state where it believes that the assembly is present, but we've already deleted it as part of the uninstall or repair. There are workarounds, but you must uninstall swf SharePoint and go back to the beginning. See http://powerpivotgeek.com/server-installation/reported-problems/#006 and http://powerpivotgeek.com/server-installation/reported-problems/#HowTo000 for more information.

Hope that helps.

Dave Wickert (MSFT) blog: http://www.powerpivotgeek.com/ Enjoy!

What you shared helps me understand it, I'm new here.
 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter