Thursday, August 19, 2010

Office Web Application on SharePoint 2010 Step 5 Error

Installing Office Web Application on SharePoint 2010 after the configuration wizard is through with its process you may ran into an issue on Step 5: Configuring SharePoint services. The configuration wizard failed with an InvalidOperationException with the following entry in the eventlog.

Failed to register SharePoint services. An exception of type System.InvalidOperationException was thrown. Additional exception information: Failed to load or format string Id ManagementUI_ExcelCalculationService_FriendlyName for culture en-US: System.TypeInitializationException: The type initializer for ‘Microsoft.Office.Excel.Server.Host.ExcelServerHost’ threw an exception. —> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.TypeLoadException: Could not load type ‘Microsoft.Office.Excel.Server.Extensions.IHostExtension’ from assembly ‘Microsoft.Office.Excel.Server.MossHost, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’.

image

Click run and type regedit enter goto HKLM\SOFTWARE\MICROSOFT\Shared Tools\Web Server Extensions\14.0\WSS\Services Delete the key for the service causing the error and re-run the configuration. After the delete the coniguration wizard ran successfully to completion.

image 

Please note that by removing above reg. key the Excel Service will appear under SharePoint Central Admin. Configuration. so you may not able to view Excel document online.

help from : http://techdhaan.wordpress.com/

5 comments:

தஞ்சை.வாசன் said...

Hi Faizal,

How are you?

I am srinivasan. I would like to have your gmail ID. Can you please send me.

Thanks for your post.


Regards,
Sree

Faizal said...

Hi Vasan,

Thanks for your post.... Here is my email address kmdfaizal at gmail dot com

tony rocks said...

Um...what if you want to use Office Web Apps AND you want to allow users to view Excel docs online? This is a bad solution in my opinion :)

Faizal said...

Tony, thanks for dropping a note, true you cannot use excel service if you follow above solutions. This work around rather than final solution.

This happen only if you use Office Web Apps beta version with SharePoint 2010 (final release). If you try both in beta versions there is no issue.

I also try Office Web Apps (MSDN version) with SharePoint 2010 there is no issue on step 5.

Hope the above clarification helps.

Kevin said...

Thank you for your post, it saves us a lot of time !