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 Yes, I'm consulting some other SPS engineers on this issue. Some of them mentioned that there are several possibilities for this and the most they can think of are in the setup of MOSS. Also, they agree that it will be better to open a support incident to continue troubleshooting on this, and they suggested work on this with Excel service part as that might be the key part of the issue.
\par
\par Sincerely,
\par
\par Steven Cheng
\par
\par Microsoft MSDN Online Support Lead
\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 ==================================================
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par \pard\li720 --------------------
\par From: =?Utf-8?B?ZXplZ2V0LmNvbQ==?= <ezeget.com2007@xxxxxxxxxxxxxxxx>
\par References: <EA637BCC-40F9-442A-9CB8-CF9996081351@xxxxxxxxxxxxx> <sihLOzY4IHA.1620@xxxxxxxxxxxxxxxxxxxxxx> <6BBAB1AE-CA9A-4ED6-BC3E-24F9B338DA5E@xxxxxxxxxxxxx> <Jx$Pxoy4IHA.4056@xxxxxxxxxxxxxxxxxxxxxx>
\par Subject: RE: Excel Web Access Error
\par Date: Tue, 22 Jul 2008 05:44:02 -0700
\par
\par
\par Hi Steven,
\par
\par Any more progress on this one please, it is starting to really hold us up
\par here.
\par
\par Do I need to escalate it as a support incident or something please?
\par
\par We want to be able to make use of Excel Services to produce some fancy
\par dashboard like the example please.
\par
\par Regards
\par --
\par Steve G
\par
\par
\par "Steven Cheng [MSFT]" wrote:
\par
\par > Thanks for the followup Steve,
\par >
\par > I'll do some further research to see whether there is any existing cases
\par > that can provide any clues on this.
\par >
\par > BTW, for your former case in which you eliminite the proble by uninstalling
\par > live commuinicator, I have checked our internal case library for former
\par > issues. However, I haven't found existing issue which definitely document
\par > that live communicator will impact SSRS or MOSS system. I'm sorry for not
\par > being able to help much on that.
\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
\par > suggestions about how we can improve the support we provide to you. Please
\par > feel free to let my manager know what you think of the level of service
\par > provided. You can send feedback directly to my manager at:
\par > msdnmg@xxxxxxxxxxxxxx
\par >
\par > ==================================================
\par > Get notification to my posts through email? Please refer to
\par > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
\par > ications.
\par > ==================================================
\par > This posting is provided "AS IS" with no warranties, and confers no rights.
\par >
\par > --------------------
\par >
\par > From: =?Utf-8?B?ZXplZ2V0LmNvbQ==?= <ezeget.com2007@xxxxxxxxxxxxxxxx>
\par > References: <EA637BCC-40F9-442A-9CB8-CF9996081351@xxxxxxxxxxxxx>
\par > <sihLOzY4IHA.1620@xxxxxxxxxxxxxxxxxxxxxx>
\par > Subject: RE: Excel Web Access Error
\par > Date: Wed, 9 Jul 2008 03:59:03 -0700
\par >
\par >
\par > Just an extra note, happened to notice that I am currently on
\par > WIndows Server 2003 R2 Standard Edition, do you think that this may explain
\par > the issue, ie does SharePoint Excel Calc Services rely on Enterprise
\par > Edition
\par > of Windows?
\par >
\par > Long shot but who knows it may give you the key.
\par >
\par > If this is in fact the case, then some more useful error messages would
\par > save
\par > masses of precious time all round, and we could all be doing much more
\par > interesting and forward thinking stuff instead of going round in
\par > circles......
\par > --
\par > Steve G
\par >
\par >
\par > "Steven Cheng [MSFT]" wrote:
\par >
\par > > Hi Steve,
\par > >
\par > > Have you ever encountered this error before or do you remember any
\par > > particular configuration changes on the sharepoint server? Is this an
\par > > intermittent issue, that seems to happen under high usage periods of the
\par > > Excel Calculation Service?
\par > >
\par > > Based on the research, when the IIS Server is unable to handle more HTTP
\par > > request due to an overload of the server (HTTP 503) is because the Excel
\par > > Calculation Services denies requests (normally during periods of high
\par > > usage) due to a delay in releasing TCP sessions. By default, TCP
\par > maintains
\par > > a closed connection for up to four minutes. If this is the real cause of
\par > > the issue, it should be intermittent, happening only when there are a
\par > high
\par > > number of requests to the Excel Calculation Service.
\par > >
\par > > If you identify that this is your case, you can modify the default TCP
\par > > settings changing the TcpTimedWaitDelay valur from 240 seconds to 30.
\par > Edit
\par > > 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,
\par > > some of them are resolved via the following suggesitons:
\par > >
\par > > Follow the steps in the white paper:
\par > >
\par > http://technet2.microsoft.com/Office/en-us/library/eea3ace8-0863-429a-b1e8-0
\par > > 41254ed2fc41033.mspx?mfr=true
\par > >
\par > > -added the document library on the trusted file location with excel
\par > 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
\par > > suggestions about how we can improve the support we provide to you.
\par > Please
\par > > feel free to let my manager know what you think of the level of service
\par > > provided. You can send feedback directly to my manager at:
\par > > msdnmg@xxxxxxxxxxxxxx
\par > >
\par > > ==================================================
\par > > Get notification to my posts through email? Please refer to
\par > >
\par > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
\par > > ications.
\par > >
\par > > Note: The MSDN Managed Newsgroup support offering is for non-urgent
\par > issues
\par > > where an initial response from the community or a Microsoft Support
\par > > Engineer within 1 business day is acceptable. Please note that each
\par > follow
\par > > up response may take approximately 2 business days as the support
\par > > professional working with you may need further investigation to reach the
\par > > most efficient resolution. The offering is not appropriate for situations
\par > > that require urgent, real-time or phone-based interactions or complex
\par > > project analysis and dump analysis issues. Issues of this nature are best
\par > > handled working with a dedicated Microsoft Support Engineer by contacting
\par > > Microsoft Customer Support Services (CSS) at
\par > > http://msdn.microsoft.com/subscriptions/support/default.aspx.
\par > > ==================================================
\par > > This posting is provided "AS IS" with no warranties, and confers no
\par > rights.
\par > >
\par > > --------------------
\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
\par > > Services
\par > > are working fine.
\par > >
\par > > What am I missing must be security / permissions related, can anyone
\par > 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 > >
\par >
\par \pard
\par
\par }