RE: Excel Web Access Error

{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang2052\f0\fs20 Hi Steve,
\par
\par Have you ever encountered this error before or do you remember any particular configuration changes on the sharepoint server? Is this an intermittent issue, that seems to happen under high usage periods of the Excel Calculation Service?
\par
\par Based on the research, when the IIS Server is unable to handle more HTTP request due to an overload of the server (HTTP 503) is because the Excel Calculation Services denies requests (normally during periods of high usage) due to a delay in releasing TCP sessions. By default, TCP maintains a closed connection for up to four minutes. If this is the real cause of the issue, it should be intermittent, happening only when there are a high number of requests to the Excel Calculation Service.
\par
\par If you identify that this is your case, you can modify the default TCP settings changing the TcpTimedWaitDelay valur from 240 seconds to 30. Edit the following key in the registry to accomplish this:
\par
\par HKLM\\SYSTEM\\ControlSet\\Services\\Tcpip\\Parameters
\par
\par In addition, I've also searched for some former issue with same syptome, some of them are resolved via the following suggesitons:
\par
\par Follow the steps in the white paper:
\par http://technet2.microsoft.com/Office/en-us/library/eea3ace8-0863-429a-b1e8-041254ed2fc41033.mspx?mfr=true
\par
\par -added the document library on the trusted file location with excel services
\par -didn't selected trusted data connection library . it was set to none
\par -add the excel web part to display the excel file in document library
\par
\par then, the excel file is accessed correctly.
\par
\par Hope this helps
\par
\par Sincerely,
\par
\par Steven Cheng
\par
\par Microsoft MSDN Online Support Lead
\par
\par
\par Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
\par
\par ==================================================
\par Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.
\par
\par Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support
\par Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support
\par professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations
\par that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx.
\par ==================================================
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par
\par \pard\li720 --------------------
\par Thread-Topic: Excel Web Access Error
\par thread-index: AcjhFnyQDb+Kzsc+SW+hv7H0/kM/fg==
\par X-WBNR-Posting-Host: 207.46.19.197
\par From: =?Utf-8?B?ZXplZ2V0LmNvbQ==?= <ezeget.com2007@xxxxxxxxxxxxxxxx>
\par Subject: Excel Web Access Error
\par Date: Tue, 8 Jul 2008 09:20:07 -0700
\par
\par
\par I am having difficulty getting the Excel Sample WOrkbooks to work.
\par
\par Event Viewer says that
\par
\par No Excel Calculation Services is available in the farm.[User:
\par SHAREPOINT\\system]
\par
\par But when I look at Central Admin it suggests that Excel Calculation Services
\par are working fine.
\par
\par What am I missing must be security / permissions related, can anyone guide
\par me to a solution please.
\par
\par I am running SharePoint on WIn2k Server R2 with SSRS Deep Integration.
\par
\par Thanks in anticipation
\par --
\par Steve G
\par \pard
\par
\par }

Relevant Pages
Loading