Here is my first blog after a long vacation back from my hometown in India. Tomorrow is a special day as Hurricane Sandy is going to hit my area ( Edison, NJ) , so writing this post tonight itself :)
There are many articles out in web provides the details of Office Web Apps 2013 , its planning, deployment etc. What I’m trying to give in this post is my experience with the installation and configuration of Office Web Apps 2013 for SharePoint Server 2013.
Environment details are given below :-
Total 4 Servers in my Windows Azure Virtual Machine Environment.
litdc – AD & DC (Windows Server 2008 R2)
litsp1 – WFE – SPS 2013 RTM (Windows Server 2012 Datacenter Edition)
litsp2 – App Server – SPS 2013 RTM (Windows Server 2012 Datacenter Edition)
litsp3 – OWA 2013 RTM Server (Windows Server 2012 Datacenter Edition)
After installing and configuration of my SharePoint 2013 environment I have started the setup for Office Web Apps 2013 in litsp3.
Please refer the TechNet articles for details about planning & deployment of Office Web Apps 2013. In this post I’m providing details of deployment of Office Web Apps 2013 on a Windows 2012 Server. Also, this will be a single server OWA farm only.
Enable the prerequisites for Office Web Apps 2013 in Windows Server 2012. You can do this using PowerShell. Open Windows PowerShell Console as Administration and run the below.
# if script execution policy is “Restricted”, enable it using Set-ExecutionPolicy "UnRestricted"
System restart required after provisioning the above prerequisites features.
After system reboot, go ahead and run the OWA 2013 installation setup as administrator.
Before creating a new OWA farm, you have to do couple of things based upon the planning you have done. Make sure that there won’t be any application running in default ports in the server that you are setting up the OWA farm. As a best practice, always use HTTPS for the communication, so in my test environment, I have imported a domain certificate in the IIS. Since this was a domain certificate that got from the CA (certificate authority) in my DC it was already added to my trusted root authority in the litsp3 server, if not , you have to import it manually.
Once the server certificate is installed, its ready to provision the new OWA single server farm. You have to run New-OfficeWebAppsFarm PS commandlet , if you need more details of the Commandlet and also to verify whether the PowerShell snap is correctly added, you can use
As you see it in the screenshot below, also notice the default web site in IIS running in port 80, because after creating a new web app farm it will remove that site.
Execute the below PowerShell Commandlet
New-OfficeWebAppsFarm –InternalUrl “https://litsp3” -ExternalUrl https://litsp3.litware.local –CertificateName "OfficeWebApps Certificate" –EditingEnabled
Since I have used the –EditingEnabled parameter it will prompt the confirmation for the licensing. Remember that editing is only possible in SharePoint 2013 and not in Exchange & Lync 2013. After executing the commandlet successfully , we can see the details of the configurations. It will list out the URLs, Cache location, ULS log location and other specific configuration for excel and stuff.
Now, if you look at the IIS you can see that default web site has been replaced by OWA web sites. To confirm a successful configuration you can browse to the web service discovery location like this : https://litsp2.litware.local/hosting/discovery
In the below screenshot you can see the IIS websites for OWA and a discovery details for the above mentioned URL. Please note the port numbers used for the binding. Make sure that all those ports are not blocked by the firewall to avoid any communication issues with OWA.
Alright, once above steps are done then next step is to configure SharePoint Server 2013 to make the WOPI binding with Office Web Apps 2013.
You have to use New-SPWOPIBinding commandlet to do that. In my environment I run it like below.
New-SPWOPIBinding –ServerName “litsp3.litware.local”
Office Web Apps Server uses the concept of zones to determine which URL (internal or external) and which protocol (HTTP or HTTPS) to use when it communicates with the host, which in this case is SharePoint 2013. By default, SharePoint Server 2013 uses the internal-https zone. Verify that this is the current zone by running the following command:
After you run this command, you should see the WOPI zone displayed. It should be internal-https.
Finally to test everything working fine or not, create or upload different types of office documents. Below screenshot is a test with a new PowerPoint document. You can see the URL that since SharePoint 2013 is already has the capability as a host using WOPI, it will detect the document and render it in the WOPI interface (/_layouts/15/WopiFrame.aspx)
Troubleshooting & Monitoring
For troubleshooting, we have our friend :) ULS log available for Office Web Apps 2013 as well. Location is different than default location of SharePoint. You might have noticed it in the Step #4 that after provisioning a new farm it will provide the details of the ULS log as well.
Since by default ULS log location configured under “C:\ProgramData\Microsoft\OfficeWebApps\Data\Logs\ULS”, you have to enable the hidden files in C:\ drive as “ProgramData” folder is hidden by default.
Location of the ULS log can be changed using Set-OfficeWebAppsFarm, but only one caveat is that to get the change to effect , we have to restart the OWA server, if there are more servers in the farm all servers has to be started to get the change updated. Not only this setting there are other configuration changes as well which needs the system restart, you can refer the documentation of above mentioned PS commandlet for more information about those all. I would recommend you to go through the that PS commandlet and plan all your required configurations before the deployment so that way you can avoid any system reboot after the deployment.
Like in SharePoint, ULS log will be very helpful to get to know what is happening behind the scene and hence troubleshoot issues easily. In my case I have faced an issue while rending the document in SharePoint web interface after the configuration. Then I have checked the ULS logs in OWA server then found that there was a communication issue due to firewall in my environment. In windows Azure virtual machines ping is disabled by default I have had to enable the below firewall rule (Virtual Machine Monitoring (Echo Request - ICMPV4-In)) to get it working.
ULS log exception is given below.
Health report by PowerPointViewingServicesWatchdog_Web: Agent: WebPPTViewer, eventId: 1188, eventType: Error, categoryId: 0, eventMessage: PowerPointViewingServicesWatchdog_Web reported status for WebPPTViewer in category 'WfeRedirect'. Reported status: Exception when checking /default.aspx: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 10.10.1.10:80 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) - -- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetResponse() at Microsoft.Office.Web.Common.WatchdogHelper.CheckWfeRedirect(ServiceInstance instance, Int16 category, String categoryName)
For monitoring the OWA server there are many performance counters available
Perfmon view to monitor the performance by using the counters.
Task Manager view of OWA related processes
Hope this post will be helpful for someone !
I would recommend to read the below blog posts as well
Spencer’s article on Editing License with OWA 2013
Ali’s article on Machine Translation Services with OWA 2013
Steve’s article on Configuring OWA 2013
It's always usefull to know how monitor applications! Thanks!
I hope that sandy won't hurt to much..
Thanks Chris. So far we are safe :)
tell me please, how to Install, Configure & Monitor Office Web Apps 2013 for Lync 2013
Please refer the below links
I doing "Validating the Configuration of Office Web Apps Server"
but i have LS Data MCU event with the event ID of 41033 failed.
What me doing now?
I have same System.Net.Sockets.SocketException (all firewalls disabled). How can i solve it?
Try to ping the OWA server and see if there is any communication issue. Also try to browse to the https://OWAServer/hosting/discovery from the SP server that you are trying to create the binding and see if it is accessible and showing the right data.
Great stuff Steve! Thanks
For the troubleshooting section
Issue: Word Document : "Sorry, there was a problem and we can't open this document. If this happens again, try opening the document in Microsoft Word."
Error: You see Unexpected error in the ULS logs on the Office Web App server.
"WOPI Check, non-200 return [code:Forbidden, url [sitename.domain.com/.../GUID]"
When using http for SharePoint site you need to set AllowOAuthOverHttp to true. This needs to be done in the SharePoint Management Shell using the following commands:
$sts = (Get-SPSecurityTokenServiceConfig)
$sts.AllowOAuthOverHttp = $true
Https SharePoint sites should work with default = false
my Name is Marc from Germany,
thanks for the perfekt instructions!
But i have a liitle Problem getting webapps working.When i try to start a ppt presentation, it doesn't works.
eventvwr says: ID 1004 Reported Status health is unhealthy.
Do you know what's the Problem here?
Is that issue happening only with PPTx files ? can you look at the ULS log in the OWA server and see any more details ?
Does anyone have any idea when the rest of the language packs for Office Web Apps 2013 are coming out?
thanks for the great article. Everything in SharePoint 2013 and Office Web Apps is working fine, except the Translation Service. I have done all setup steps as described in this and in Ali's article, but every time I try to translate a document, I'll get the following error: "Sorry the document can't be translated at this time because we're having trouble talking to the service. Please try again in a few minutes."
Does anyone have an idea on this?
I recommend this step-by-step installation guid:
I have tried to configure this on a simple test server . The only difference is I am using -internal-http and I have applied the CU wacserver2013-kb2810007-fullfile-x64-glb .. I don't see the warning re the -EnableEditing switch nor am I ever asked about a product key. I cam able to see that everything appears ok inc the http://wacFarm/.mydomain.com/discovery/hosting.........but
The net result is yes my sp2013 can see the office web app install and even make an attempt to open my work doc in OWA iframe but
orry, there was a problem and we can't open this document. If this happens again, try opening the document in Microsoft Word."
Also the OWA ULS logs shows WOPI CheckFile: Catch-All Failure [exception:Microsoft.Office.Web.Common.EnvironmentAdapters.FileUnknownException: WOPI 404 at Microsoft.Office.Web.Apps.Common.WopiDocument.LogAndThrowWireException(HttpRequestAsyncResult result, HttpRequestAsyncException delayedException) at Microsoft.Office.Web.Apps.Common.HttpRequestAsync.End() at Microsoft.Office.Web.Apps.Common.WopiDocument.GetWopiRequestResultWithRetry(Int32 maxSize, MemoryStream ms, WopiRequest wopiRequest) at Microsoft.Office.Web.Apps.Common.WopiDocument.CheckWopiFile()]..
getucinfo.com/.../kb2810007，If you install KB2810007,Office Web App is failed.Please check getucinfo.com/.../kb2810007 to solve your Problem.Thanks!