Redirect Sharepoint Site and office webapp site via Kemp LB

0

I had a OfficeWebApp url NATed by Kemp LB, using * Certificate and it is working fine. Now i have a sharepoint site abc.company.com which is redirected by KEMP and working fine but whenever i open any document of this sharepoint site in webapp, it gives me "Server Error in /x Application". Any Ideas ??

10 comments

Avatar
0
Christian Scheller

Please go to:

Miscellaneous Options ==> Network Options

and tick the box that says "Handle non HTTP Uploads"

This should fix the issue for you.

Best Regards,
KEMP Customer Service

Avatar
0
rishi.pandit

Hi Christian,
Still its not working - Same error

Avatar
0
Christian Scheller

Please check the Sharepoint servers logs and enable the L7 debug traces under Logging Options ==> Debug Options.

Also please check if downloads work fine when you connect to the server direct.

Avatar
0
rishi.pandit

File is not even downloading - EventViewer giving below error

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 23-09-2015 19:57:20
Event time (UTC): 23-09-2015 14:27:20
Event ID: 43937b724789435894e1c48e15070bb6
Event sequence: 26623
Event occurrence: 17
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/2/ROOT/x-1-130874563757438275
Trust level: Full
Application Virtual Path: /x
Application Path: C:\Program Files\Microsoft Office Web Apps\ExcelServicesWfe\
Machine name: WEBAPP

Process information:
Process ID: 22332
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: ExcelWebRendererException
Exception message: We couldn't find the file you wanted.
at Microsoft.Office.Excel.WebUI.EwaState.OpenWorkbook()
at Microsoft.Office.Excel.WebUI.ExcelWebRendererInternal.RenderControl(HtmlTextWriter writer)
at ASP.layouts_xlviewerinternal_aspx.Rendercontrol6(HtmlTextWriter __w, Control parameterContainer)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at ASP._layouts_xlviewerinternal_aspx.
Render_control1(HtmlTextWriter __w, Control parameterContainer)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.Page.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

We couldn't find the file you wanted.
at Microsoft.Office.Excel.WebUI.EwaState.EnsureDocumentHostInfo()
at Microsoft.Office.Excel.WebUI.EwaState.OpenWorkbook()

at Microsoft.Office.Excel.Server.ServiceHost.ServiceHostLoader.GetCheckedBaseDocument(String querySignature, BaseUser baseUser, String canary, Boolean shouldCheckCanary, ScenarioRestrictions restriction)
at Microsoft.Office.Excel.Server.ServiceHost.ServiceHost.GetCheckedBaseDocument(String uri, String canary, Boolean shouldValidateCanary, Byte[] documentProperties, ScenarioRestrictions restriction)
at Microsoft.Office.Excel.Server.ServiceHost.ServiceHost.Microsoft.Office.Excel.Server.Host.IEwaHost.GetDocumentHostInfo(String uri, String canary, Boolean shouldValidateCanary, Byte[] documentProperties, Boolean isGenerated, ScenarioRestrictions restriction, ResourceThrottlingScenario scenario)
at Microsoft.Office.Excel.WebUI.EwaState.EnsureDocumentHostInfo()

WOPI Check File
at Microsoft.Office.Web.Apps.Common.WopiDocument.CheckWopiFile()
at Microsoft.Office.Excel.Server.ServiceHost.ServiceHostLoader.GetCheckedBaseDocument(String querySignature, BaseUser baseUser, String canary, Boolean shouldCheckCanary, ScenarioRestrictions restriction)

Request information:
Request URL: https://WebAppFQDN:443/x/_layouts/xlviewerinternal.aspx?ui=en-US&rs=en-US&WOPISrc=http://SharePointSite.DomainName.Ext/_vti_bin/wopi.ashx/files/81b0ee4eaeb04555996c5a2e3baf62bf&sc=https://communicate.impetus.co.in/Documents/Forms/AllItems.aspx&wdEnableRoaming=1
Request path: /x/_layouts/xlviewerinternal.aspx
User host address: <IP Address of the WebApp Server>
User:

Is authenticated: False
Authentication Type:

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 12
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at Microsoft.Office.Excel.WebUI.EwaState.OpenWorkbook()
at Microsoft.Office.Excel.WebUI.ExcelWebRendererInternal.RenderControl(HtmlTextWriter writer)
at ASP.layouts_xlviewerinternal_aspx.Rendercontrol6(HtmlTextWriter __w, Control parameterContainer)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at ASP._layouts_xlviewerinternal_aspx.
Render_control1(HtmlTextWriter __w, Control parameterContainer)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.Page.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

Avatar
0
Christian Scheller

Hi,

two lines seem to contain a hint:

Is authenticated: False
Exception message: We couldn't find the file you wanted.

Now I think that the authentication method for the site is different from the one used for the files. You may try to access a file while bypassing the Loadmaster and check the log for the authentication method used for downloads.

In addition I think its better if you raised a support ticket through the portal as this case might require it.

Thanks and regards
KEMP Customer Service

Avatar
0
rishi.pandit

Okay - i will try to log a support ticket.

In Office Webapp event viewer, i found another error.

Could not contact WOPI End Point. Error details - 'FileNotFound url - http://sitename/_vti_bin/wopi.ashx/files/...........................

any guesses ?

When i bypass the LB and opens sharepoint document library, file opens fine but via loadbalancer same error

Avatar
0
Christian Scheller

Hi,

since you are using Response header modifications we might have to add another rule which would mangle the request string according to the target domain.

Avatar
0
rishi.pandit

Oh so can you guide on this or link any article which i can refer ?

Avatar
0
Christian Scheller

At this point I think it is best to raise a support ticket.

Thanks for your understanding
KEMP Customer Service

Avatar
0
rishi.pandit

Yeah, i have raised a support ticket for the same. I will post the resolution as i get it.