RE: Excel Web Access Error
- From: stcheng@xxxxxxxxxxxxxxxxxxxx (Steven Cheng [MSFT])
- Date: Thu, 17 Jul 2008 09:46:21 GMT
{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang2052\f0\fs20 Hi Steve,
\par
\par I did found some permission related issue about the excel webpart not working when viewing things from excel calculation service.
\par
\par You can try using a user account with powerful permission on the MOSS server to visit the site:
\par
\par Got the credentials for service account and started excel calculation services from central admin.
\par
\par 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.
\par
\par You can also check the permission on the excel file to see whether it had permission for other accounts(try adding everyone for test).
\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 ==================================================
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par
\par
\par \pard\li720 ---------------------------
\par From: =?Utf-8?B?ZXplZ2V0LmNvbQ==?= <ezeget.com2007@xxxxxxxxxxxxxxxx>
\par References: <EA637BCC-40F9-442A-9CB8-CF9996081351@xxxxxxxxxxxxx> <sihLOzY4IHA.1620@xxxxxxxxxxxxxxxxxxxxxx>
\par Subject: RE: Excel Web Access Error
\par Date: Wed, 9 Jul 2008 03:54:00 -0700
\par
\par Hi Steven,
\par The error has always happened with my current machine Win 2003 Server R2,
\par but I am sure I did have it working successfully under XP.
\par
\par I have worked through all those steps several times and the final result is
\par what I said in the fault report. Central Admin says Excel Calculation
\par Services are working but when I try to access the Sample Workbook it errors
\par and the error message says that it is not running by SHAREPOINT/System
\par
\par Not sure if that is suggesting I have a missing dummy SHAREPOINT user or
\par something?
\par
\par I have even tried the Single SIgn On things and that appeared to work.
\par
\par I am not trying to do anything clever with Excel Services yet, just get your
\par Sample Demo working properly for a start, but it is failing to recognize that
\par Excel Calcualtion Services are running. I wonder if this is yet another
\par Security Account permissions setting fiasco! Security is good, but not when
\par it stops us from working and using basic sample demos, the default for demos
\par should be minimal security or at least automatic fail safe settings to ensure
\par ease of use - Dare I say USABILITY!
\par
\par
\par
\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 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 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. 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 > 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 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. 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 > Note: The MSDN Managed Newsgroup support offering is for non-urgent 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 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 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 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 \pard
\par
\par }
- Follow-Ups:
- RE: Excel Web Access Error
- From: ezeget.com
- RE: Excel Web Access Error
- References:
- Excel Web Access Error
- From: ezeget.com
- RE: Excel Web Access Error
- From: Steven Cheng [MSFT]
- RE: Excel Web Access Error
- From: ezeget.com
- Excel Web Access Error
- Prev by Date: Tune Workflow Task Alerts
- Next by Date: Re: How to find most viewed sites/pages on Sharepoint Services
- Previous by thread: RE: Excel Web Access Error
- Next by thread: RE: Excel Web Access Error
- Index(es):
Relevant Pages
|
