ISSUE 1:
When opening a SharePoint Dashboard that contains multiple Excel Web Access Web Parts the message Excel Services Failed to Download Chart will appear.
ISSUE 2:
When you refresh the page (after receiving the above message) you receive the message "Bad Request (Request Header Too Long)".
CAUSE 1:
Maximum Concurrent Queries Per Session were being exceeded (were set to 5).
CAUSE 2:
The HTTP request that was sent to the IIS server had a request header that exceeded the allowable request header length configured on the IIS server.
RESOLUTION 1:
Capture a ULS Log via: Central Administration>Operations>Logging and Reporting>Diagnostic Logging.
*Note: this may require analyzing all ULS from al machines in farm that are Web Front Ends.
Filter under>Excel Services>Excel Services External Data>Information and look for the message:
"An external data query was queued because there were already 5 active external queries. To improve performance, consider updating the number of concurrent queries using the administration console."
If you see the above messge browse to Excel Services Settings>Trusted file Locations>Maximum Concurrent Queries Per Session (Increased from Default 5 to 50).
RESOLUTION 2:
Add the below RegKeys to the WFE and Applicaton Servers and Reboot:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\HTTP\Parameters\MaxFieldLength
DWORD: 65534
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\HTTP\Parameters\MaxRequestBytes
DWORD: 500000
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\HTTP\Parameters\MaxTokenSize
DWORD: 65535
Note: It may be necessary to add the below Registry Key to the Client & Server and Reboot:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Lsa\ Kerberos\Parameters\MaxPacketSize
DWORD: 1
CLM: HTTP Bad Request (Request header too long)
http://kbalertz.com/Feedback.aspx?kbNumber=955585
Http.sys registry settings for IIS
http://kbalertz.com/Feedback.aspx?kbNumber=820129
New resolution for problems with Kerberos authentication when users belong to many groups
http://kbalertz.com/Feedback.aspx?kbNumber=327825
CLM: HTTP Bad Request (Request header too long)
http://kbalertz.com/Feedback.aspx?kbNumber=955585
How to force Kerberos to use TCP instead of UDP in Windows
http://kbalertz.com/Feedback.aspx?kbNumber=244474
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See
Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.