RE: Excel Web Access Error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hi Steven,
The error has always happened with my current machine Win 2003 Server R2,
but I am sure I did have it working successfully under XP.

I have worked through all those steps several times and the final result is
what I said in the fault report. Central Admin says Excel Calculation
Services are working but when I try to access the Sample Workbook it errors
and the error message says that it is not running by SHAREPOINT/System

Not sure if that is suggesting I have a missing dummy SHAREPOINT user or
something?

I have even tried the Single SIgn On things and that appeared to work.

I am not trying to do anything clever with Excel Services yet, just get your
Sample Demo working properly for a start, but it is failing to recognize that
Excel Calcualtion Services are running. I wonder if this is yet another
Security Account permissions setting fiasco! Security is good, but not when
it stops us from working and using basic sample demos, the default for demos
should be minimal security or at least automatic fail safe settings to ensure
ease of use - Dare I say USABILITY!



--
Steve G


"Steven Cheng [MSFT]" wrote:

Hi Steve,

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?

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.

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:

HKLM\SYSTEM\ControlSet\Services\Tcpip\Parameters

In addition, I've also searched for some former issue with same syptome,
some of them are resolved via the following suggesitons:

Follow the steps in the white paper:
http://technet2.microsoft.com/Office/en-us/library/eea3ace8-0863-429a-b1e8-0
41254ed2fc41033.mspx?mfr=true

-added the document library on the trusted file location with excel services
-didn't selected trusted data connection library . it was set to none
-add the excel web part to display the excel file in document library

then, the excel file is accessed correctly.

Hope this helps

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


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

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
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.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
Thread-Topic: Excel Web Access Error
thread-index: AcjhFnyQDb+Kzsc+SW+hv7H0/kM/fg==
X-WBNR-Posting-Host: 207.46.19.197
From: =?Utf-8?B?ZXplZ2V0LmNvbQ==?= <ezeget.com2007@xxxxxxxxxxxxxxxx>
Subject: Excel Web Access Error
Date: Tue, 8 Jul 2008 09:20:07 -0700


I am having difficulty getting the Excel Sample WOrkbooks to work.

Event Viewer says that

No Excel Calculation Services is available in the farm.[User:
SHAREPOINT\system]

But when I look at Central Admin it suggests that Excel Calculation
Services
are working fine.

What am I missing must be security / permissions related, can anyone guide
me to a solution please.

I am running SharePoint on WIn2k Server R2 with SSRS Deep Integration.

Thanks in anticipation
--
Steve G

.



Relevant Pages

  • RE: Excel Web Access Error
    ... Do I need to escalate it as a support incident or something please? ... Subject: Excel Web Access Error ... WIndows Server 2003 R2 Standard Edition, do you think that this may explain ... Thread-Topic: Excel Web Access Error ...
    (microsoft.public.sharepoint.portalserver.development)
  • RE: Excel Web Access Error
    ... WIndows Server 2003 R2 Standard Edition, do you think that this may explain ... Excel Calculation Service? ... number of requests to the Excel Calculation Service. ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.sharepoint.portalserver.development)
  • RE: More about trying to automation multiple Excel instances
    ... Welcome to Microsoft Newsgroup Support Service! ... Excel Instances". ... is a Multiuse server. ...
    (microsoft.public.excel.programming)
  • Re: VS2003 transfer data between two data sources
    ... data and blast the rows to a SQL Server table. ... The problem with reading an excel table without a header row is that the ... Another not so elegant solution might be to get the UI to read the Excel ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VS2003 transfer data between two data sources
    ... data and blast the rows to a SQL Server table. ... The problem with reading an excel table without a header row is that the ... Another not so elegant solution might be to get the UI to read the Excel ...
    (microsoft.public.dotnet.framework.adonet)