PowerPoint Web Application encountered an error: Service unavailable. Please try again later.

That’s funny, but PowerPoint stop working today without any visible reasons. Error message about service anavailable

I tryed to get into PowerPoint Service Application, but System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

and this in log:

1: “Could not find default ServiceProxy or it does not implement IWacServiceApplicationProxy”

2: “Unhandled exception caught when executing web method handler: System.NullReferenceException”

First of all – re-create PowerPoint Service Application. Problem with given key is gone.

Investigation… Something wrong with the PowerPoint application proxy. This solution using UI did’t work for me and  . It was not hooked up to the default proxy group, but admin pages said different. (Thanks to Dale Hirt)

Get-SPPowerPointServiceApplicationProxy | Remove-SPPowerPointServiceApplicationProxy -confirm

Add new one w-AddToDefaultGroup switch:

Get-SPPowerPointServiceApplication | New-SPPowerPointServiceApplicationProxy -Name “PowerPoint Proxy” -AddToDefaultGroup

Verification:

$(Get-SPPowerPointServiceApplication).ServiceApplicationProxyGroup.DefaultProxies

Strange Office Web in Word Vieving Service Error after SP1 install

In Central Administration at Services On Server we have Word Viewing Service stopped.

When we try to start it – we get this (the main is highlighted):

Adding binding ‘*:32843:’ for protocol ‘http’. 8dce029c-949a-495f-9c87-fae7133d906a
08/10/2011 09:45:37.55  w3wp.exe (0x1608)                        0x11FC SharePoint Foundation          Topology                       bmu2 High     Adding secure binding ‘*:32844:’ with SSL certificate ‘FindBySubjectDistinguishedName:CN=SharePoint Services, OU=SharePoint, O=Microsoft, C=US’ in store ‘SharePoint’. 8dce029c-949a-495f-9c87-fae7133d906a
08/10/2011 09:45:37.55  w3wp.exe (0x1608)                        0x11FC SharePoint Foundation          Topology                       bmu3 High     Adding binding ‘32845:*’ for protocol ‘net.tcp’. 8dce029c-949a-495f-9c87-fae7133d906a
08/10/2011 09:45:37.55  w3wp.exe (0x1608)                        0x11FC SharePoint Foundation          Topology                       bmu3 High     Adding binding ‘*’ for protocol ‘net.pipe’. 8dce029c-949a-495f-9c87-fae7133d906a
08/10/2011 09:45:38.07  w3wp.exe (0x1608)                        0x11FC SharePoint Foundation          Topology                       fx74 High     An exception occured while committing IIS configuration changes: A specified logon session does not exist. It may already have been terminated. (Exception from HRESULT: 0x80070520) 8dce029c-949a-495f-9c87-fae7133d906a
08/10/2011 09:45:39.10  w3wp.exe (0x1608)                        0x11FC SharePoint Foundation          Topology                       bmu3 High     Adding binding ‘*:32843:’ for protocol ‘http’. 8dce029c-949a-495f-9c87-fae7133d906a
08/10/2011 09:45:39.10  w3wp.exe (0x1608)                        0x11FC SharePoint Foundation          Topology                       bmu2 High     Adding secure binding ‘*:32844:’ with SSL certificate ‘FindBySubjectDistinguishedName:CN=SharePoint Services, OU=SharePoint, O=Microsoft, C=US’ in store ‘SharePoint’. 8dce029c-949a-495f-9c87-fae7133d906a
08/10/2011 09:45:39.10  w3wp.exe (0x1608)                        0x11FC SharePoint Foundation          Topology                       bmu3 High     Adding binding ‘32845:*’ for protocol ‘net.tcp’. 8dce029c-949a-495f-9c87-fae7133d906a
08/10/2011 09:45:39.10  w3wp.exe (0x1608)

Investigation – something wrong with Sharepoint Service certificate. And it can’t be assigned.

Resolution in this article: http://blogs.msdn.com/b/besidethepoint/archive/2010/11/30/sharepoint-2010-certificates.aspx

I use SPServiceHostCertificate_Example and change $names = “Sharepoint Services”, “full.server.name” and $env:PSModulePath to folder with files. As I can see – we recreate certificates and assign the new one to services. Word Viewing Service is started for me now. Fuff…

Word and PowerPoint File Open in Browser Error

Sometimes we get an error in Office Web Application like this:

Word Web App cannot open this document for viewing because of an unexpected error. To view this document, open it in Microsoft Word.
Error Id: e526e7cf-f17a-48ee-85ee-916c593e0569, 20110415162644

What we can see in logs? Surprise!

DownloadManager: Exception thrown downloading file \\fs001\Anikin, Alexander\Agency contract.docx: System.UnauthorizedAccessException: Access to the path ‘C:\Windows\TEMP\waccache\30091891-f580-40fb-a151-9ff2114df390\DEV_ow_services\e7c940c5-2bc8-471b-b63d-37507944b53a\’ is denied.

Sharepoint Services Pool (OWA workrs under) account can’t write into the Temp\waccache folder any more.

I’be found this, but solution 1 don’t work for me. I add permissions for this folder to my accounts and it works!

I don’t know why it happens. Conversion service use this folder for temp files, but it start creating folders without needed permissions.

Sharepoint Service Account’s Permisions for Office Web Apps

I had some  investigations about Sharepoint account permissions and rights.

What I have: Windows Server 2008 R2 (included in AD, with Service Packs), SharePoint Foundation 2010 (very important – with update kb2394323) , Office Web Applications (very important – with update KB2346411  – this update has a lot for changes for OWA, and big changes in PowerPoint) .

I have simple account’s configuration:
domain\ow_site – web-applicaiton pool
Domain Groups Member Of: Domain Users, and rights for reading other users account if needed.
Local Server: Administrators (WSS_WPG and others adding automatically at creation time of managed accounts)
Local policies (if needed for any reasons – ex. specific authentication with http-module): Act as part of operating system, Logon as service  

domain\ow_services – services pool (by default: SharePoint Services Default Pool: Word, PowerPoint, Excel and etc.; we can definitely do separate account for services)
Domain Groups Member Of: Domain Users, and rights for reading other users account if needed.
Local Server: Administrators, (WSS_WPG and others adding automatically at creation time of managed accounts)
Local policies(if needed for any reasons – ex. specific authentication with http-module): Act as part of operating system, Logon as service

Comments:

1. Excel Services account should be in local Administrators when it’s working in File Access Method – Impersonation. (more info https://aanikin.wordpress.com/2010/11/13/excel-services-file-access-method-impersonation/)

2. After Security  Update KB2346411 PowerPoint Service needs thats web-applications pool acoount must be member of Local Administrators group. (As i think something with local policies.)

3. After Security  Update KB2346411 PowerPoint service account must have rights for writing to web-application content db:

Adding ow_services account db_owner role for  web-application content DB
a. Getting database name in Central Administration->Application Management->Manage content database – choose created Office Web Application at upper right corner. Copy DB_NAME for this application
b. Create config.sql file:
use [DB_NAME]
go
create user [DOMAIN\svc_ow_services] from login [DOMAIN\svc_ow_services]
go
sp_addrolemember ‘db_ownew’, ‘DOMAIN\svc_ow_services’
c. Run the command as administrator in the same folder with config.sql:
“C:\Program Files\Microsoft SQL Server\100\Tools\Binn\”sqlcmd –S localhost\SHAREPOINT –i config.sql
d. Do iisreset /noforce

How to Clear Office Web Applications Cache

For testing purposes(ex. performance tests) sometimes we need need to clear Office Web Applications Cache. 

PowerShell: Remove-SPOfficeWebAppsCache -WebApplication <web_app_name>

Warning: Performing operation “Remove-SPOfficeWebAppsCache” on Target “Removing the Office Web Apps cache could result in degraded performance of Word Web App and PowerPoint Web App.”.

More info about OWA Cache: http://blogs.technet.com/b/wbaer/archive/2010/09/01/the-office-web-applications-cache.aspx