RE: Excel Web Access Error

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have now even tried using a powerful system admin user, but I still get the
useless error

Excel Web Access

An error has occurred.
Please contact your system administrator if this problem persists!

The event viewer again tells me that Excel Services are not running on this
farm!

Is there something I need to play about with in Component Services and if so
what do I need to do to fix this please!

Becoming more of an issue now as we intend to use this dashboard kind of
stuff for demo purposes!


--
Steve G


"Steven Cheng [MSFT]" wrote:

Hi Steve,

I did found some permission related issue about the excel webpart not
working when viewing things from excel calculation service.

You can try using a user account with powerful permission on the MOSS
server to visit the site:

Got the credentials for service account and started excel calculation
services from central admin.

If you then receive 'file not found' error, you can try checking the work
book location ,make sure add entry into the trusted file location and also
make an entry into the trusted data connection for it.

You can also check the permission on the excel file to see whether it had
permission for other accounts(try adding everyone for test).

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.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


---------------------------
From: =?Utf-8?B?ZXplZ2V0LmNvbQ==?= <ezeget.com2007@xxxxxxxxxxxxxxxx>
References: <EA637BCC-40F9-442A-9CB8-CF9996081351@xxxxxxxxxxxxx>
<sihLOzY4IHA.1620@xxxxxxxxxxxxxxxxxxxxxx>
Subject: RE: Excel Web Access Error
Date: Wed, 9 Jul 2008 03:54:00 -0700

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
    ... The error has always happened with my current machine Win 2003 Server R2, ... Central Admin says Excel Calculation ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Excel Web Access
    ... Before trying to use an Excel Web Access web part to point to the workbook, ... I would suggest you try opening it directly in the web browser to see if it ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Help with Excel Web Access.
    ... child libraries are trusted. ... The Excel service is running in MOSS. ... But when I point the URL to the excel file in the Excel web access web ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Excel Web Access with xlviewer page missing in WSS 3.0
    ... In order to use Excel Services and the Excel Web Access web part, you will need to have the appropriate edition of MOSS installed. ... I have WSS 3.0 on my system. ...
    (microsoft.public.sharepoint.portalserver)
  • Excel Web Access | An error has occurred.
    ... just wanted to try Excel Web Access, created simple XLSX with 3 numbers, as easiest as it gets. ... Created a EWA wep part, document library with that XSLS and tried to conenct EWA webpart with it. ...
    (microsoft.public.sharepoint.portalserver)