Error in communicating with Excel Calculation Services
When attempting to view an Excel spreadsheet in SharePoint, we get the following error displayed in the web browser:
Excel Web Access: An error has occurred
Checking the Event Log we see:
There was an error in communicating with Excel Calculation Services http://uklo2k3d02:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized.
[Session: (null) User: CAPCO\jtnn].- The user has full admin rights over all systems
- We are running RTM version of SharePoint 2007, Enterprise Edition
- Excel Services is enabled, configured and activated on all levels.
- The location is set as trusted.
- The rest of the server works perfectly
- Shared Services works fine apart from Excel, as My Site and Search works
- We have set up one server using Kerberos (all SPN accounts set up and working, adsutil has ensured NEGOTIATE on all instances) but no go
- We have set up another server using NTLM but no go
- I have read http://support.microsoft.com/kb/923502 but no go
- I have tried both PROCESS and IMPERSONATION in the Excel Services settings, but no difference
- Also followed every step in this article http://msd2d.com/content/Tip_viewitem_03.aspx?section=SharePoint&category=Administration&id=2d02b594-5e07-4957-921f-72e6e6954618 ...but no go.
Can anyone help?
Answers
Dr. John,
I'm posting because I just resolved an issue that was yielding exactly the same error messages you are seeing, namely, an error has occurred and HTTP 401: Unauthorized. I was trying to programmatically open a workbook from a PC on the intranet and from another PC on the internet. All was well on the intranet, but no joy on the internet. I worked on the problem for a solid month, then hired Microsoft support for $245. Within Microsoft, the problem propagated through at least 4 levels of support until it got to one of the MOSS 2007 developers. The developer asked if I had setup any alternate URLs (aka Alternate Access Mappings on the Operations tab) for the site so that I could access it from a non-intranet DNS or IP address. I had not. So, I added a couple mappings: http://MyServerName and http://MyServersActualIPAddress (e.g., http://111.222.333.444). After adding these alternate URLs, my Web Excel Services calls worked properly.
Admittedly, what prompted me to post this little blurb is only the fact that you are seeing the exact error messages that I struggled with for a month. If your experience has been anything like mine (it sounds like it has been rather painful), then you might be willing to try just about anything at this point. Just a newbie's quick two cents. Frankly, just a shot in the dark.
KrisF
In addition I now have been able to log the following messages that seem to have an effect on Excel services. The user is validated OK against sharepoint but still these messages appear (I've offcourse removed user and domain names)
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 3/15/2007
Time: 3:53:52 PM
User:
Computer: SHAREPOINT
Description:
Object Open:
Object Server: Security Account Manager
Object Type: SAM_ALIAS
Object Name: DOMAINS\Account\Aliases\000003ED
Handle ID: -
Operation ID: {0,325835}
Process ID: 436
Image File Name: C:\WINDOWS\system32\lsass.exe
Primary User Name: SHAREPOINT$
Primary Domain:
Primary Logon ID: (0x0,0x3E7)
Client User Name:
Client Domain:
Client Logon ID: (0x0,0x4BA2A)
Accesses: AddMember
RemoveMember
ListMembers
ReadInformation
Privileges: -
Restricted Sid Count: 0
Access Mask: 0xF
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 3/15/2007
Time: 3:53:44 PM
User:
Computer: SHAREPOINT
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,312251}
Process ID: 424
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: SHAREPOINT$
Primary Domain:
Primary Logon ID: (0x0,0x3E7)
Client User Name:
Client Domain:
Client Logon ID: (0x0,0x4BA2A)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 3/15/2007
Time: 3:53:11 PM
User:
Computer: SHAREPOINT
Description:
Object Open:
Object Server: Security Account Manager
Object Type: SAM_ALIAS
Object Name: DOMAINS\Account\Aliases\000003ED
Handle ID: -
Operation ID: {0,286316}
Process ID: 436
Image File Name: C:\WINDOWS\system32\lsass.exe
Primary User Name: SHAREPOINT$
Primary Domain:
Primary Logon ID: (0x0,0x3E7)
Client User Name:
Client Domain:
Client Logon ID: (0x0,0x45D1D)
Accesses: AddMember
RemoveMember
ListMembers
ReadInformation
Privileges: -
Restricted Sid Count: 0
Access Mask: 0xF
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
All Replies
From your description of the topology, I assume you're trying to use kerberos delegation for communicating in the farm.
To set Excel Services to delegation please run:
stsadm -o set-ecssecurity -accessmodel delegation -ssp sharedservices1
If the timer service isn't running on the Shared Services machine? please, run the following on that machine:
stsadm -o execadmsvcjobs
Last, do iisreset for both the web front end and shared services machines.
Then check See if that solves the issue.
John,
Did the above post answer your question? Let us know if there's any more info needed, otherwise it would be great if you could mark the post Answered so we can get it off the radar.
Thanks!
No, the suggested fix did not work.
We have spent two weeks installing MOSS on different servers. Fortuately the production servers work fine. However, the development and test servers do not - which makes it hard to develop and test. We have attempted to isolate the problem, but no joy. Here is a summary of what we tried:
Our installation of SharePoint 2007 Enterprise Edition on goes through the following steps:
1) Install and follow DB Config Wizard
2) Used the Advance Settings (Select Complete installation)
3) Create a new Farm
4) Specify Database Settings (seperate database server is being used)
5) Configure SharePoint Central Admin Web Application (Kerberos Authentication)
Log into Central Admin and continue configuration as follows below.
6) From the operation menu, configure Services on Server
7) Configure the Search Services, Tick Query, Indexing boxes and provide email address, Farm Search Services Account, Search Databases etc..
8) Create and configure Farms shared services from application management.
9) Create new SSP
10) Create a new web application for our shared services, using port 80, host header and again (Kerberos Security), tick IIS restart automatically
11) Create a new web application for our mysite services, using port 80, host header and again (Kerberos Security), tick IIS restart automatically
12) Success! (Great)
Tasks still outstanding to complete (Keep in mind we want to use excel web access)
1) Configure outgoing email settings (Not used as yet)
2) Configure workflow settings (Not Used as yet)
3) Configure infopath forms (Not used as yet)
4) Setup Services Account as single sign-on services (not used)
5) Configure diagnostic logging
6) Configure Web application general settings
7) Create site collection
Select my Web Application
Web site address as the root
Select Enterprise reports
Site collection administrators 1 and 2
No quota
So we have a new site that works. So we need to configure Excel Services.
1) From the operations menu in Central admin, select Enabled Excel Services feature on all sites
2) Switch in on and wait for success.
3) Configure a trusted path location for Excel and add webpart to page
4) Use the sample file the report library
5) And Excel Services works - but only on the production server!!
To enabled features, this can also be selected from within the shared services page to enable individual features, same can be done from you website page from within the site settings option.
Kerboros setup
We have SPNs set up for the production server and the development server - but no joy.
Both computers are trusted for delegation.
THE BIG PROBLEM
Repeat all the above steps on development server and excel services give the below error message.
An error has occurred.
Please contact your system administrator if this problem persists.After at least six attempts on the development server and lots of reading on every blog out in cyber space, can someone help please? We would really like to get excel services working on our development server not just on our production.
Thanks for the detailed info!
Could you post a snippet of your logs at the exact moment (a few minutes before and after will help as well) you are loading a workbook and receive this error message?
You can find them under:
<system drive>\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS
This should help us figure out why the workbook is giving you this error.
Here is a sample of our log.
01/30/2007 12:54:39.21 w3wp.exe (0x0B74) 0x0600 Excel Services Excel Web Access 5cbf Medium ExcelWebRenderer.OnLoad: Starting loading external EWR
01/30/2007 12:54:39.21 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Web Controls 90i3 Verbose PersonalActions::CreateChildControls() - Was called.
01/30/2007 12:54:39.22 w3wp.exe (0x0B74) 0x0600 434 8ofj Verbose Menu::OnLoad() - Was called. ID="Menu"
01/30/2007 12:54:39.22 w3wp.exe (0x0B74) 0x0600 434 8ofj Verbose Menu::OnLoad() - Was called. ID="MyLinksMenuMenu"
01/30/2007 12:54:39.22 w3wp.exe (0x0B74) 0x0600 434 8ofj Verbose Menu::OnLoad() - Was called. ID="SiteActionsMenu"
01/30/2007 12:54:39.22 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=UKLO2K3DENTDB;Initial Catalog=WSS_Content;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15
01/30/2007 12:54:39.22 w3wp.exe (0x0B74) 0x0600 1624 8acb Verbose Reverting to process identity
01/30/2007 12:54:39.23 w3wp.exe (0x0B74) 0x0600 1624 8acc Verbose Current user before SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:39.23 w3wp.exe (0x0B74) 0x0600 1624 8acf Verbose Current user after SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:39.23 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880m Verbose SqlCommand: ' SELECT TOP 6 t1.[Type] AS c0,UserData.[tp_ContentTypeId],UserData.[ntext2],t2.[tp_ID] AS c5c7,UserData.[tp_ID],t1.[TimeCreated] AS c4,t2.[tp_Created] AS c5c10,UserData.[tp_Created],CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N'/' + t1.LeafName END AS c1,UserData.[tp_ModerationStatus],UserData.[tp_Level],UserData.[nvarchar1],UserData.[tp_Author],t2.[nvarchar1] AS c5c6,t2.[nvarchar4] AS c5c8,t1.[LeafName] AS c3,UserData.[nvarchar2],UserData.[tp_HasAttachment],t1.[ScopeId] AS c2,t2.[nvarchar5] AS c5c9,UserData.[tp_Modified] FROM UserData INNER MERGE JOIN Docs AS t1 WITH(NOLOCK) ON ( 1 = 1 AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = UserData...
01/30/2007 12:54:39.23* w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880m Verbose ....tp_DirName AND t1.LeafName = UserData.tp_LeafName AND t1.Level = UserData.tp_Level AND t1.IsCurrentVersion = 1 AND (1 = 1)) LEFT OUTER JOIN AllUserData AS t2 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_Author]=t2.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t2.[tp_RowOrdinal] = 0 AND ( (t2.tp_IsCurrent = 1) ) AND t2.[tp_CalculatedVersion] = 0 AND t2.[tp_DeleteTransactionId] = 0x AND t2.tp_ListId = @L3 AND UserData.tp_ListId = @L4) WHERE (UserData.tp_IsCurrent = 1) AND UserData.tp_SiteId=@L2 AND (UserData.tp_DirName=@DN) AND UserData.tp_RowOrdinal=0 AND (((UserData.[datetime1] IS NULL ) OR (UserData.[datetime1] >= @L5DTP)) AND t1.SiteId=@L2 AND (t1.DirName=@DN)) ORDER BY UserData.[tp_Modified] Desc,UserData.[tp_ID] Asc OPTION (FORCE ORDER) ' CommandType: Text CommandTime...
01/30/2007 12:54:39.23* w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880m Verbose ...out: 0 Parameter: '@L0' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00000000-0000-0000-0000-000000000000' Parameter: '@L2' Type: UniqueIdentifier Size: 0 Direction: Input Value: '3c22eefc-a7f6-470b-8e75-b82abf624a5c' Parameter: '@L3' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'ff1a8950-7565-43f8-bd08-1d5a3d42d6ed' Parameter: '@L4' Type: UniqueIdentifier Size: 0 Direction: Input Value: '5aea8f0f-0e0b-4ac0-9e7b-8705dd6050a5' Parameter: '@L5DTP' Type: DateTime Size: 0 Direction: Input Value: '1/30/2007 12:00:00 AM' Parameter: '@DN' Type: NVarChar Size: 260 Direction: Input Value: 'Lists/Announcements'
01/30/2007 12:54:39.24 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=UKLO2K3DENTDB;Initial Catalog=WSS_Content;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15
01/30/2007 12:54:39.24 w3wp.exe (0x0B74) 0x0600 1624 8acb Verbose Reverting to process identity
01/30/2007 12:54:39.25 w3wp.exe (0x0B74) 0x0600 1624 8acc Verbose Current user before SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:39.25 w3wp.exe (0x0B74) 0x0600 1624 8acf Verbose Current user after SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:39.25 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880m Verbose SqlCommand: ' SELECT t1.[Type] AS c0,UserData.[datetime1],UserData.[tp_ContentTypeId],UserData.[ntext2],UserData.[int3],t1.[TimeCreated] AS c4,UserData.[nvarchar4],UserData.[tp_Created],UserData.[ntext4],CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N'/' + t1.LeafName END AS c1,UserData.[tp_ModerationStatus],UserData.[tp_Level],UserData.[nvarchar1],UserData.[bit2],UserData.[datetime3],UserData.[int4],t1.[LeafName] AS c3,UserData.[nvarchar2],UserData.[tp_HasAttachment],UserData.[int1],UserData.[bit3],t1.[ScopeId] AS c2,UserData.[bit4],UserData.[int2],UserData.[bit1],UserData.[datetime2],UserData.[tp_ID],UserData.[ntext3],UserData.[uniqueidentifier1],UserData.[nvarchar5] FROM UserData LEFT OUTER LOOP JOIN Docs AS t...
01/30/2007 12:54:39.25* w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880m Verbose ...1 WITH(NOLOCK) ON ( 1 = 1 AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = UserData.tp_DirName AND t1.LeafName = UserData.tp_LeafName AND t1.Level = UserData.tp_Level AND t1.IsCurrentVersion = 1 AND (1 = 1)) WHERE UserData.tp_ListID=@L5 AND ( (UserData.tp_IsCurrent = 1) ) AND UserData.tp_SiteId=@L2 AND (UserData.tp_DirName=@DN) AND UserData.tp_RowOrdinal=0 AND (((( CAST(UserData.[datetime1] AS datetime ) <= @L3DTP AND (( CAST(UserData.[datetime2] AS datetime ) IS NULL AND CAST(UserData.[datetime1] AS datetime ) >= @L4DTP) OR ( CAST(UserData.[datetime2] AS datetime ) >= @L4DTP))) OR (UserData.[datetime3] <= @L3DTP AND UserData.[datetime3] >= @L4DTP))) AND t1.SiteId=@L2 AND (t1.DirName=@DN)) ORDER BY UserData.[tp_ID] Asc OPTION (...
01/30/2007 12:54:39.25* w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880m Verbose ...FORCE ORDER) ' CommandType: Text CommandTimeout: 0 Parameter: '@L0' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00000000-0000-0000-0000-000000000000' Parameter: '@L2' Type: UniqueIdentifier Size: 0 Direction: Input Value: '3c22eefc-a7f6-470b-8e75-b82abf624a5c' Parameter: '@L3DTP' Type: DateTime Size: 0 Direction: Input Value: '1/29/2009 11:59:59 PM' Parameter: '@L4DTP' Type: DateTime Size: 0 Direction: Input Value: '1/30/2007 12:00:00 AM' Parameter: '@DN' Type: NVarChar Size: 260 Direction: Input Value: 'Lists/Calendar' Parameter: '@L5' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00d045c2-c401-4f35-80e9-7d867f57725c'
01/30/2007 12:54:39.26 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=UKLO2K3DENTDB;Initial Catalog=WSS_Content;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15
01/30/2007 12:54:39.26 w3wp.exe (0x0B74) 0x0600 1624 8acb Verbose Reverting to process identity
01/30/2007 12:54:39.26 w3wp.exe (0x0B74) 0x0600 1624 8acc Verbose Current user before SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:39.26 w3wp.exe (0x0B74) 0x0600 1624 8acf Verbose Current user after SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:39.26 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880m Verbose SqlCommand: ' SELECT TOP 21 t1.[Type] AS c0,t1.[ScopeId] AS c2,UserData.[nvarchar3],UserData.[tp_ID],UserData.[nvarchar4],UserData.[tp_Created],CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N'/' + t1.LeafName END AS c1,UserData.[tp_ModerationStatus],UserData.[tp_Level],t1.[LeafName] AS c3 FROM UserData INNER MERGE JOIN Docs AS t1 WITH(NOLOCK) ON ( 1 = 1 AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = UserData.tp_DirName AND t1.LeafName = UserData.tp_LeafName AND t1.Level = UserData.tp_Level AND t1.IsCurrentVersion = 1 AND (1 = 1)) WHERE (UserData.tp_IsCurrent = 1) AND UserData.tp_SiteId=@L2 AND (UserData.tp_DirName=@DN) AND UserData.tp_RowOrdinal=0 AND ...
01/30/2007 12:54:39.26* w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880m Verbose ...(t1.SiteId=@L2 AND (t1.DirName=@DN)) ORDER BY t1.[Type] Desc,UserData.[tp_ItemOrder] Asc,UserData.[tp_ID] Asc OPTION (FORCE ORDER) ' CommandType: Text CommandTimeout: 0 Parameter: '@L0' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00000000-0000-0000-0000-000000000000' Parameter: '@L2' Type: UniqueIdentifier Size: 0 Direction: Input Value: '3c22eefc-a7f6-470b-8e75-b82abf624a5c' Parameter: '@DN' Type: NVarChar Size: 260 Direction: Input Value: 'Lists/Links'
01/30/2007 12:54:39.27 w3wp.exe (0x0B74) 0x0600 434 8ewq Verbose PersonalActions::OnPreRender() - Was called.
01/30/2007 12:54:39.28 w3wp.exe (0x0B74) 0x0600 434 8ofk Verbose Menu::Render() - Was called. ID="Menu"
01/30/2007 12:54:39.28 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Web Controls 88w6 Verbose Rendering menu control with id=Menu, Text=""
01/30/2007 12:54:39.28 w3wp.exe (0x0B74) 0x0600 434 8ewr Verbose PostCacheSubstitutionText::Render() - Was called.
01/30/2007 12:54:39.28 w3wp.exe (0x0B74) 0x0600 434 8ewr Verbose PostCacheSubstitutionText::Render() - Was called.
01/30/2007 12:54:39.28 w3wp.exe (0x0B74) 0x0600 434 8ofk Verbose Menu::Render() - Was called. ID="MyLinksMenuMenu"
01/30/2007 12:54:39.28 w3wp.exe (0x0B74) 0x0600 434 8ofk Verbose Menu::Render() - Was called. ID="SiteActionsMenu"
01/30/2007 12:54:39.28 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Web Controls 88w6 Verbose Rendering menu control with id=SiteActionsMenu, Text="Site Actions"
01/30/2007 12:54:39.30 w3wp.exe (0x0B74) 0x0600 Excel Services Excel Web Access 5cbg Medium ExcelWebRenderer.RenderWebPart: Finished rendering external EWR
01/30/2007 12:54:39.31 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services General 0 Verbose Releasing SPRequest with allocation Id {A6D34E10-F4BF-40F6-9CC6-9D6F3F60B2E2}
01/30/2007 12:54:39.31 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services General 0 Verbose Releasing SPRequest with allocation Id {4AA296CB-4372-4A6C-9DBC-8EC3669D54CB}
01/30/2007 12:54:39.31 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services General 0 Verbose Releasing SPRequest with allocation Id {44662513-730C-452A-BEE8-4536941F17DA}
01/30/2007 12:54:39.57 w3wp.exe (0x0B74) 0x0600 CMS Publishing 8zug Medium PublishingHttpModule.Init() calling AppDomainUnloadListener.Register()
01/30/2007 12:54:39.57 w3wp.exe (0x0B74) 0x0600 CMS Publishing 8x0a High AppDomainUnloadListener.RegisterSelf() entered lock(this=32347029)
01/30/2007 12:54:39.57 w3wp.exe (0x0B74) 0x0600 Office Server Session State Service 8z8f Verbose Partition resolver initialized
01/30/2007 12:54:41.59 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services General 6t8b Verbose Looking up context site http://dev.mycapco.com:80/_layouts/ExcelRenderer.aspx in the farm SharePoint_Config
01/30/2007 12:54:41.59 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services General 6t8d Verbose Looking up the additional information about the typical site http://dev.mycapco.com:80/_layouts/ExcelRenderer.aspx.
01/30/2007 12:54:41.59 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services General 6t8f Verbose Site lookup is replacing http://dev.mycapco.com:80/_layouts/ExcelRenderer.aspx with the alternate access url http://dev.mycapco.com.
01/30/2007 12:54:41.59 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services General 6t8g Verbose Looking up typical site http://dev.mycapco.com:80/_layouts/ExcelRenderer.aspx in web application SPWebApplication Name=SharePoint - dev.mycapco.com Parent=SPWebService.
01/30/2007 12:54:41.59 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services General 6t8h Verbose Found typical site / (3c22eefc-a7f6-470b-8e75-b82abf624a5c) in web application SPWebApplication Name=SharePoint - dev.mycapco.com Parent=SPWebService.
01/30/2007 12:54:41.91 w3wp.exe (0x0B74) 0x0600 Excel Services Excel Web Access 27ew Verbose EWR is starting
01/30/2007 12:54:41.91 w3wp.exe (0x0B74) 0x0600 Excel Services Excel Web Access 27ew Verbose EWR is starting
01/30/2007 12:54:41.92 w3wp.exe (0x0B74) 0x0600 Excel Services Excel Web Access 5cbi Medium InternalEwr.OnInit: Starting loading external EWR
01/30/2007 12:54:41.93 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=UKLO2K3DENTDB;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False' ConnectionState: Closed ConnectionTimeout: 15
01/30/2007 12:54:41.93 w3wp.exe (0x0B74) 0x0600 1624 8acb Verbose Reverting to process identity
01/30/2007 12:54:41.93 w3wp.exe (0x0B74) 0x0600 1624 8acc Verbose Current user before SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:41.94 w3wp.exe (0x0B74) 0x0600 1624 8acf Verbose Current user after SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:41.94 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services Database 880m Verbose SqlCommand: 'dbo.proc_getDependentObjectsByBaseClass' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@BaseClassId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '983c4b09-fbc0-4f4b-92bc-42fabf556ed5' Parameter: '@DependeeId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '9b0f7d37-bbab-40d4-abf3-ef513c5d4f86'
01/30/2007 12:54:41.99 w3wp.exe (0x0B74) 0x0600 Excel Services Excel Services Web Front End 6k38 Medium ExcelServerProxy.ExecuteWebMethod: sending request of type OpenWorkbook, to server=http://uklo2k3dmoss:56737/SharedServices2/ExcelCalculationServer/ExcelService.asmx, session=(null), state id=0
01/30/2007 12:54:42.22 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Verbose Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The Application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:698
01/30/2007 12:54:42.22 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The parent farm application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:703
01/30/2007 12:54:42.22 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: Database session creation error for resource type 0. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:555
01/30/2007 12:54:42.22 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Exceptions 0 Monitorable <Exception><HR>0xc0041228</HR><eip>0070C870</eip><module>d:\office\source\search\ytrip\tripoli\scopes\database.cxx</module><line>316</line></Exception>
01/30/2007 12:54:42.81 w3wp.exe (0x0B74) 0x0600 Excel Services Excel Services Web Front End 6k3i Medium ExcelServerProxy.ProcessWebException: A Web exception during ExecuteWebMethod has occurred for server: http://uklo2k3dmoss:56737/SharedServices2/ExcelCalculationServer/ExcelService.asmx, method: OpenWorkbook, ex: System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServiceSoap.OpenWorkbook(String url, CommandParameter parameter, CultureCommandParameter cultureParameter, Guid requestSiteId, String& workbookId, Boolean& hasOpenItemPer...
01/30/2007 12:54:42.81* w3wp.exe (0x0B74) 0x0600 Excel Services Excel Services Web Front End 6k3i Medium ...mission) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.<>c__DisplayClass1.<OpenWorkbook>b__0(CommandParameter parameterDelegate, ExcelServiceSoap excelService) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.ExecuteWithSecurityContext(Boolean revertToSelf, CoreWebMethod coreWebMethod, ExcelServiceSoap excelService, CommandParameter parameter) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.ExecuteWebMethod(WebMethodType webMethodType, PreProcessWebMethod preProcessWebMethod, CoreWebMethod coreWebMethod, Boolean& noServerResponse), response: 'System.Net.HttpWebResponse', status ProtocolError, user name: CAPCO\jtnn.
01/30/2007 12:54:42.81 w3wp.exe (0x0B74) 0x0600 Excel Services Excel Services Web Front End 3skf Critical There was an error in communicating with Excel Calculation Services http://uklo2k3dmoss:56737/SharedServices2/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized. [Session: (null) User: CAPCO\jtnn].
01/30/2007 12:54:42.82 w3wp.exe (0x0B74) 0x0600 Excel Services Excel Web Access 5cbj Medium InternalEwr.RenderWebPart: Finished rendering internal EWR
01/30/2007 12:54:42.82 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services General 0 Verbose Releasing SPRequest with allocation Id {9E088BB6-DFAD-4078-A51E-87BD1FCC5D87}
01/30/2007 12:54:42.82 w3wp.exe (0x0B74) 0x0600 Windows SharePoint Services General 0 Verbose Releasing SPRequest with allocation Id {5C2ACCC4-77BB-4174-BB01-D9D0BDAED9B7}
01/30/2007 12:54:44.48 OWSTIMER.EXE (0x0D4C) 0x0ED0 Windows SharePoint Services Topology 88b9 Verbose Determining if the current user is a SharePoint Farm Administrator
01/30/2007 12:54:44.48 OWSTIMER.EXE (0x0D4C) 0x0D50 Windows SharePoint Services Timer 5utp Verbose Scheduled timer job Indexing Schedule Manager on UKLO2K3DMOSS, id {92EF6AC3-5061-4A59-9167-ADFD6E80F229} at 30 Jan 2007 12:55:44 -0000 (now is 30 Jan 2007 12:54:44 -0000)
01/30/2007 12:54:44.48 OWSTIMER.EXE (0x0D4C) 0x01BC Windows SharePoint Services Topology 88b9 Verbose Determining if the current user is a SharePoint Farm Administrator
01/30/2007 12:54:44.49 OWSTIMER.EXE (0x0D4C) 0x0D50 Windows SharePoint Services Timer 5utp Verbose Scheduled timer job Variations Propagate Page Job Definition, id {CCDE3A11-3E6C-4BB2-8DF7-E608F3E8773A} at 30 Jan 2007 12:55:44 -0000 (now is 30 Jan 2007 12:54:44 -0000)
01/30/2007 12:54:44.52 OWSTIMER.EXE (0x0D4C) 0x0ED0 Windows SharePoint Services Timer 8e45 Verbose Begin invoke timer job Indexing Schedule Manager on UKLO2K3DMOSS, id {92EF6AC3-5061-4A59-9167-ADFD6E80F229}, DB n/a
01/30/2007 12:54:44.52 OWSTIMER.EXE (0x0D4C) 0x0ED0 Office Server Office Server Shared Services 6pll Verbose Cache miss for shared object '1dd1db1d-8a07-4e27-9249-b7d328818fa2' of type 'Microsoft.Office.Server.Search.Administration.SearchSharedApplication'.
01/30/2007 12:54:44.52 OWSTIMER.EXE (0x0D4C) 0x0ED0 484 880l Verbose ConnectionString: 'Server=UKLO2K3DENTDB;Database=SharedServices2_DB;Trusted_Connection=yes;App=Windows SharePoint Services;Timeout=15' ConnectionState: Closed ConnectionTimeout: 15
01/30/2007 12:54:44.52 OWSTIMER.EXE (0x0D4C) 0x0ED0 1624 8acb Verbose Reverting to process identity
01/30/2007 12:54:44.52 OWSTIMER.EXE (0x0D4C) 0x0ED0 1624 8acc Verbose Current user before SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:44.53 OWSTIMER.EXE (0x0D4C) 0x0ED0 1624 8acf Verbose Current user after SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:44.53 OWSTIMER.EXE (0x0D4C) 0x0ED0 484 880m Verbose SqlCommand: 'dbo.proc_MIP_GetObject' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@ObjectId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '1dd1db1d-8a07-4e27-9249-b7d328818fa2'
01/30/2007 12:54:44.57 OWSTIMER.EXE (0x0D4C) 0x0ED0 Office Server Office Server Shared Services 6plp Verbose Retrieved shared object '1dd1db1d-8a07-4e27-9249-b7d328818fa2' of type 'Microsoft.Office.Server.Search.Administration.SearchSharedApplication'.
01/30/2007 12:54:44.57 OWSTIMER.EXE (0x0D4C) 0x0ED0 Office Server Office Server Shared Services 6plq Verbose Cached shared object '1dd1db1d-8a07-4e27-9249-b7d328818fa2' of type 'Microsoft.Office.Server.Search.Administration.SearchSharedApplication'.
01/30/2007 12:54:44.59 OWSTIMER.EXE (0x0D4C) 0x0ED0 Office Server Office Server Shared Services 6pll Verbose Cache miss for shared object '1dd1db1d-8a07-4e27-9249-b7d328818fa2' of type 'Microsoft.Office.Server.Search.Administration.SearchSharedApplication'.
01/30/2007 12:54:44.59 OWSTIMER.EXE (0x0D4C) 0x0ED0 484 880l Verbose ConnectionString: 'Server=UKLO2K3DENTDB;Database=SharedServices2_DB;Trusted_Connection=yes;App=Windows SharePoint Services;Timeout=15' ConnectionState: Closed ConnectionTimeout: 15
01/30/2007 12:54:44.59 OWSTIMER.EXE (0x0D4C) 0x0ED0 1624 8acb Verbose Reverting to process identity
01/30/2007 12:54:44.60 OWSTIMER.EXE (0x0D4C) 0x0ED0 1624 8acc Verbose Current user before SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:44.60 OWSTIMER.EXE (0x0D4C) 0x0ED0 1624 8acf Verbose Current user after SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:44.60 OWSTIMER.EXE (0x0D4C) 0x0ED0 484 880m Verbose SqlCommand: 'dbo.proc_MIP_GetObject' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@ObjectId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '1dd1db1d-8a07-4e27-9249-b7d328818fa2'
01/30/2007 12:54:44.60 OWSTIMER.EXE (0x0D4C) 0x01BC Windows SharePoint Services Timer 8e45 Verbose Begin invoke timer job Variations Propagate Page Job Definition, id {CCDE3A11-3E6C-4BB2-8DF7-E608F3E8773A}, DB {09ED42AD-61FA-460A-AF2E-C0F0A2F4D7A8}
01/30/2007 12:54:44.60 OWSTIMER.EXE (0x0D4C) 0x01BC Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=UKLO2K3DENTDB;Initial Catalog=WSS_Content;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15
01/30/2007 12:54:44.60 OWSTIMER.EXE (0x0D4C) 0x01BC 1624 8acb Verbose Reverting to process identity
01/30/2007 12:54:44.60 OWSTIMER.EXE (0x0D4C) 0x01BC 1624 8acc Verbose Current user before SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:44.61 OWSTIMER.EXE (0x0D4C) 0x01BC 1624 8acf Verbose Current user after SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:44.61 OWSTIMER.EXE (0x0D4C) 0x01BC Windows SharePoint Services Database 880m Verbose SqlCommand: 'dbo.proc_GetRunnableWorkItems' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@ProcessingId' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'ebb65ebe-5756-4889-9a13-0ec439781ff5' Parameter: '@SiteId' Type: NVarChar Size: 0 Direction: Input Value: '' Parameter: '@WorkItemType' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'ea95ab64-3857-4403-96d0-3aeb3dbdb123' Parameter: '@BatchId' Type: NVarChar Size: 0 Direction: Input Value: '' Parameter: '@MaxFetchSize' Type: Int Size: 0 Direction: Input Value: '100' Parameter: '@ThrottleThreshold' Type: Int Size: 0 Direction: Input Value: '0'
01/30/2007 12:54:44.61 OWSTIMER.EXE (0x0D4C) 0x0ED0 Office Server Office Server Shared Services 6plp Verbose Retrieved shared object '1dd1db1d-8a07-4e27-9249-b7d328818fa2' of type 'Microsoft.Office.Server.Search.Administration.SearchSharedApplication'.
01/30/2007 12:54:44.61 OWSTIMER.EXE (0x0D4C) 0x0ED0 Office Server Office Server Shared Services 6plq Verbose Cached shared object '1dd1db1d-8a07-4e27-9249-b7d328818fa2' of type 'Microsoft.Office.Server.Search.Administration.SearchSharedApplication'.
01/30/2007 12:54:44.61 OWSTIMER.EXE (0x0D4C) 0x0ED0 Search Server Common MS Search Administration 7pht Verbose IsConfigurationOnline: SSP 'SharedServices2' status is 'Online'. SSP database status is 'Online'.
01/30/2007 12:54:44.65 OWSTIMER.EXE (0x0D4C) 0x01BC Windows SharePoint Services Timer 8e46 Verbose End invoke timer job Variations Propagate Page Job Definition, id {CCDE3A11-3E6C-4BB2-8DF7-E608F3E8773A}, DB {09ED42AD-61FA-460A-AF2E-C0F0A2F4D7A8}
01/30/2007 12:54:44.81 mssearch.exe (0x0FBC) 0x0814 Search Server Common GatherSvc 0 Medium CGatherApplication::CGatherApplication::GetRole - What is the role of this server? - File:d:\office\source\search\search\gather\gthrsvc\gthrapp.cxx Line:730
01/30/2007 12:54:44.81 mssearch.exe (0x0FBC) 0x0814 Search Server Common GatherSvc 0 Medium CGatherApplication::CGatherApplication::GetRole - The role of this server is 3 - File:d:\office\source\search\search\gather\gthrsvc\gthrapp.cxx Line:752
01/30/2007 12:54:44.97 OWSTIMER.EXE (0x0D4C) 0x0ED0 Windows SharePoint Services Timer 8e46 Verbose End invoke timer job Indexing Schedule Manager on UKLO2K3DMOSS, id {92EF6AC3-5061-4A59-9167-ADFD6E80F229}, DB n/a
01/30/2007 12:54:45.49 OWSTIMER.EXE (0x0D4C) 0x0FC8 Windows SharePoint Services Topology 88b9 Verbose Determining if the current user is a SharePoint Farm Administrator
01/30/2007 12:54:45.50 OWSTIMER.EXE (0x0D4C) 0x0D50 Windows SharePoint Services Timer 5utp Verbose Scheduled timer job Config Refresh, id {7DFEDB1B-EF70-4CC0-BD2F-A9A384C36200} at 30 Jan 2007 12:55:00 -0000 (now is 30 Jan 2007 12:54:45 -0000)
01/30/2007 12:54:45.50 OWSTIMER.EXE (0x0D4C) 0x0FC8 Windows SharePoint Services Timer 8e45 Verbose Begin invoke timer job Config Refresh, id {7DFEDB1B-EF70-4CC0-BD2F-A9A384C36200}, DB n/a
01/30/2007 12:54:45.51 OWSTIMER.EXE (0x0D4C) 0x0FC8 Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=UKLO2K3DENTDB;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False' ConnectionState: Closed ConnectionTimeout: 15
01/30/2007 12:54:45.51 OWSTIMER.EXE (0x0D4C) 0x0FC8 1624 8acb Verbose Reverting to process identity
01/30/2007 12:54:45.51 OWSTIMER.EXE (0x0D4C) 0x0FC8 1624 8acc Verbose Current user before SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:45.51 OWSTIMER.EXE (0x0D4C) 0x0FC8 1624 8acf Verbose Current user after SqlConnection.Open: Name: CAPCO\SERV_SharePoint SID: S-1-5-21-486879912-1543852476-316617838-9409 ImpersonationLevel: None
01/30/2007 12:54:45.51 OWSTIMER.EXE (0x0D4C) 0x0FC8 Windows SharePoint Services Database 880m Verbose SqlCommand: 'dbo.proc_getNewObjects' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@NewestCachedVersion' Type: BigInt Size: 0 Direction: Input Value: '4746'
01/30/2007 12:54:45.52 OWSTIMER.EXE (0x0D4C) 0x0FC8 Windows SharePoint Services Timer 8e46 Verbose End invoke timer job Config Refresh, id {7DFEDB1B-EF70-4CC0-BD2F-A9A384C36200}, DB n/a
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Verbose Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The Application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:698
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The parent farm application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:703
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: Database session creation error for resource type 0. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:555
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common GatherPI 0 Monitorable SearchDB GetSession failed application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a Error is 0xc0041228 or Session pointer is null - File:d:\office\source\search\search\gather\gthrsvc\srchschema.cxx Line:3334
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Verbose Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The Application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:698
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The parent farm application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:703
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: Database session creation error for resource type 0. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:555
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common GatherPI 0 Monitorable SearchDB GetSession failed application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a Error is 0xc0041228 or Session pointer is null - File:d:\office\source\search\search\gather\gthrsvc\srchschema.cxx Line:3348
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Verbose Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The Application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:698
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The parent farm application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:703
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: Database session creation error for resource type 0. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:555
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common GatherPI 0 Monitorable SearchDB GetSession failed application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a Error is 0xc0041228 or Session pointer is null - File:d:\office\source\search\search\gather\gthrsvc\srchschema.cxx Line:3348
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common GatherPI 0 Monitorable SearchDB Re-initializing DataSource application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a - File:d:\office\source\search\search\gather\gthrsvc\srchschema.cxx Line:3359
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Verbose Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The Application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:698
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The parent farm application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:703
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: Database session creation error for resource type 0. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:555
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common GatherPI 0 Monitorable SearchDB GetSession failed application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a Error is 0xc0041228 or Session pointer is null - File:d:\office\source\search\search\gather\gthrsvc\srchschema.cxx Line:3348
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Verbose Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The Application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:698
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The parent farm application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:703
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: Database session creation error for resource type 0. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:555
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common GatherPI 0 Monitorable SearchDB GetSession failed application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a Error is 0xc0041228 or Session pointer is null - File:d:\office\source\search\search\gather\gthrsvc\srchschema.cxx Line:3348
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common GatherPI 0 Monitorable SearchDB Re-initializing DataSource application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a - File:d:\office\source\search\search\gather\gthrsvc\srchschema.cxx Line:3359
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Verbose Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The Application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:698
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The parent farm application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:703
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: Database session creation error for resource type 0. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:555
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common GatherPI 0 Monitorable SearchDB GetSession failed application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a Error is 0xc0041228 or Session pointer is null - File:d:\office\source\search\search\gather\gthrsvc\srchschema.cxx Line:3376
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common GathererSql 0 Monitorable GetManagedPropertyAliases: Failed in GetSession, Error is 0xc0041228 - File:d:\office\source\search\search\gather\gthrsvc\srchschema.cxx Line:2993
01/30/2007 12:54:46.00 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Exceptions 0 Monitorable <Exception><HR>0xc0041228</HR><eip>6007AB74</eip><module>d:\office\source\search\search\gather\gthrsvc\srchschema.cxx</module><line>2994</line></Exception>
01/30/2007 12:54:47.34 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Verbose Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The Application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:698
01/30/2007 12:54:47.34 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: The parent farm application root doesn't exist or access denied. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:703
01/30/2007 12:54:47.34 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Common 0 Monitorable Application 3fcb86b8-0efe-4aaa-ac74-a5fda012d11a: Database session creation error for resource type 0. - File:d:\office\source\search\search\searchdll\resourcemanagerimpl.cpp Line:555
01/30/2007 12:54:47.34 mssearch.exe (0x0FBC) 0x0D48 Search Server Common Exceptions 0 Monitorable <Exception><HR>0xc0041228</HR><eip>0070C870</eip><module>d:\office\source\search\ytrip\tripoli\scopes\database.cxx</module><line>316</line></Exception>Here is a shorter and perhaps more pertinent log file:
01/30/2007 13:58:32.93 w3wp.exe (0x0AB0) 0x0D24 484 880m Verbose SqlCommand: 'dbo.proc_MIP_GetObjectUpdates' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@Version' Type: BigInt Size: 0 Direction: Input Value: '50' Parameter: '@CurrentVersion' Type: BigInt Size: 0 Direction: Output Value: ''
01/30/2007 13:58:33.06 w3wp.exe (0x0E78) 0x0C60 Excel Services Excel Services Web Front End 6k3i Medium ExcelServerProxy.ProcessWebException: A Web exception during ExecuteWebMethod has occurred for server: http://uklo2k3dmoss:56737/SharedServices3/ExcelCalculationServer/ExcelService.asmx, method: OpenWorkbook, ex: System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServiceSoap.OpenWorkbook(String url, CommandParameter parameter, CultureCommandParameter cultureParameter, Guid requestSiteId, String& workbookId, Boolean& hasOpenItemPer...
01/30/2007 13:58:33.06* w3wp.exe (0x0E78) 0x0C60 Excel Services Excel Services Web Front End 6k3i Medium ...mission) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.<>c__DisplayClass1.<OpenWorkbook>b__0(CommandParameter parameterDelegate, ExcelServiceSoap excelService) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.ExecuteWithSecurityContext(Boolean revertToSelf, CoreWebMethod coreWebMethod, ExcelServiceSoap excelService, CommandParameter parameter) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.ExecuteWebMethod(WebMethodType webMethodType, PreProcessWebMethod preProcessWebMethod, CoreWebMethod coreWebMethod, Boolean& noServerResponse), response: 'System.Net.HttpWebResponse', status ProtocolError, user name: CAPCO\jtnn.
01/30/2007 13:58:33.06 w3wp.exe (0x0E78) 0x0C60 Excel Services Excel Services Web Front End 3skf Critical There was an error in communicating with Excel Calculation Services http://uklo2k3dmoss:56737/SharedServices3/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized. [Session: (null) User: CAPCO\jtnn].
01/30/2007 13:58:33.07 w3wp.exe (0x0E78) 0x0C60 Excel Services Excel Web Access 5cbj Medium InternalEwr.RenderWebPart: Finished rendering internal EWR
01/30/2007 13:58:33.07 w3wp.exe (0x0E78) 0x0C60 Windows SharePoint Services General 0 Verbose Releasing SPRequest with allocation Id {9A206831-733E-46B9-AC6C-DF616C0A9B30}
01/30/2007 13:58:33.07 w3wp.exe (0x0E78) 0x0C60 Windows SharePoint Services General 0 Verbose Releasing SPRequest with allocation Id {DF72425B-35BD-4CC5-8C9B-898EB8E2FB79}John,
Can you check the Security Event Log on uklo2k3dmoss, and check if kerberos authentication succeeded to that machine.
Also, can you check on that machine whether the web.config has the following section:
<location path="XXXXX/ExcelCalculationServer" allowOverride="true" inheritInChildApplications="true">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>The web.config is located at: %program files%\\Microsoft Office Server\12.0\WebServices\Root\Web.Config
Hey John,
Any luck? Did you get a chance to check Ira's post?
Hi Luis,
I am working with John on this Excel Calculation Services on our Development server. I can comfirm that none of the recommendations worked on the dev server. We are still searching for a solution.
Randine
- Did you check the two points Ira mentioned? That Kerberos Authentication succeeded and that the web.config contains the snippet he included?
Randine, John,
I assume from your posts, that you wish to deploy MOSS in a Kerberos enviroment. Please let me know if that isn't the case, or not a requirement.
So lets try the following:
In addition to the stsadm commands I suggested running at the beginning of the thread, please try running the following:
stsadm -o setsharedwebserviceauthn -negotiate
stsadm -o execadmsvcjobs
iisreset
Now, retry your scenario.
If it's still failing, then I suspect you have an SPN registration issue. Can you describe which SPNs you've registered for the Shared Services AppPool? Under which account is the AppPool running as? Could it be that in your production enviroment (the one that works,) the AppPool was running as Network service?
Dr. John,
I'm posting because I just resolved an issue that was yielding exactly the same error messages you are seeing, namely, an error has occurred and HTTP 401: Unauthorized. I was trying to programmatically open a workbook from a PC on the intranet and from another PC on the internet. All was well on the intranet, but no joy on the internet. I worked on the problem for a solid month, then hired Microsoft support for $245. Within Microsoft, the problem propagated through at least 4 levels of support until it got to one of the MOSS 2007 developers. The developer asked if I had setup any alternate URLs (aka Alternate Access Mappings on the Operations tab) for the site so that I could access it from a non-intranet DNS or IP address. I had not. So, I added a couple mappings: http://MyServerName and http://MyServersActualIPAddress (e.g., http://111.222.333.444). After adding these alternate URLs, my Web Excel Services calls worked properly.
Admittedly, what prompted me to post this little blurb is only the fact that you are seeing the exact error messages that I struggled with for a month. If your experience has been anything like mine (it sounds like it has been rather painful), then you might be willing to try just about anything at this point. Just a newbie's quick two cents. Frankly, just a shot in the dark.
KrisF
Hi Ira,
I've been having this problem as well. the 401 on Excel services problem is solved by:
stsadm -o setsharedwebserviceauthn -negotiate
stsadm -o execadmsvcjobs
iisreset
But I now get the following errors in eventlog, plain excel sheets on MOSS work now but SSAS data refresh fails
Description:
The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Unable to open shim database version registry key - v2.0.50727.00000.Event Type: Error
Event Source: Office SharePoint Server Error Reporting
Event Category: None
Event ID: 5000
Date: 3/15/2007
Time: 1:22:47 PM
User: N/A
Computer: SENA-SHAREPOINT
Description:
EventType ulsexception12, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435e74, P4 microsoft.office.excel.server, P5 12.0.4518.0, P6 45417eea, P7 489, P8 17, P9 timeoutexception, P10 8jfu.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 75 00 6c 00 73 00 65 00 u.l.s.e.
0008: 78 00 63 00 65 00 70 00 x.c.e.p.
0010: 74 00 69 00 6f 00 6e 00 t.i.o.n.
0018: 31 00 32 00 2c 00 20 00 1.2.,. .
0020: 77 00 33 00 77 00 70 00 w.3.w.p.
0028: 2e 00 65 00 78 00 65 00 ..e.x.e.
0030: 2c 00 20 00 36 00 2e 00 ,. .6...
0038: 30 00 2e 00 33 00 37 00 0...3.7.
0040: 39 00 30 00 2e 00 31 00 9.0...1.
0048: 38 00 33 00 30 00 2c 00 8.3.0.,.
0050: 20 00 34 00 32 00 34 00 .4.2.4.
0058: 33 00 35 00 65 00 37 00 3.5.e.7.
0060: 34 00 2c 00 20 00 6d 00 4.,. .m.
0068: 69 00 63 00 72 00 6f 00 i.c.r.o.
0070: 73 00 6f 00 66 00 74 00 s.o.f.t.
0078: 2e 00 6f 00 66 00 66 00 ..o.f.f.
0080: 69 00 63 00 65 00 2e 00 i.c.e...
0088: 65 00 78 00 63 00 65 00 e.x.c.e.
0090: 6c 00 2e 00 73 00 65 00 l...s.e.
0098: 72 00 76 00 65 00 72 00 r.v.e.r.
00a0: 2c 00 20 00 31 00 32 00 ,. .1.2.
00a8: 2e 00 30 00 2e 00 34 00 ..0...4.
00b0: 35 00 31 00 38 00 2e 00 5.1.8...
00b8: 30 00 2c 00 20 00 34 00 0.,. .4.
00c0: 35 00 34 00 31 00 37 00 5.4.1.7.
00c8: 65 00 65 00 61 00 2c 00 e.e.a.,.
00d0: 20 00 34 00 38 00 39 00 .4.8.9.
00d8: 2c 00 20 00 31 00 37 00 ,. .1.7.
00e0: 2c 00 20 00 74 00 69 00 ,. .t.i.
00e8: 6d 00 65 00 6f 00 75 00 m.e.o.u.
00f0: 74 00 65 00 78 00 63 00 t.e.x.c.
00f8: 65 00 70 00 74 00 69 00 e.p.t.i.
0100: 6f 00 6e 00 20 00 38 00 o.n. .8.
0108: 6a 00 66 00 75 00 0d 00 j.f.u...
0110: 0a 00 ..In addition I now have been able to log the following messages that seem to have an effect on Excel services. The user is validated OK against sharepoint but still these messages appear (I've offcourse removed user and domain names)
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 3/15/2007
Time: 3:53:52 PM
User:
Computer: SHAREPOINT
Description:
Object Open:
Object Server: Security Account Manager
Object Type: SAM_ALIAS
Object Name: DOMAINS\Account\Aliases\000003ED
Handle ID: -
Operation ID: {0,325835}
Process ID: 436
Image File Name: C:\WINDOWS\system32\lsass.exe
Primary User Name: SHAREPOINT$
Primary Domain:
Primary Logon ID: (0x0,0x3E7)
Client User Name:
Client Domain:
Client Logon ID: (0x0,0x4BA2A)
Accesses: AddMember
RemoveMember
ListMembers
ReadInformation
Privileges: -
Restricted Sid Count: 0
Access Mask: 0xF
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 3/15/2007
Time: 3:53:44 PM
User:
Computer: SHAREPOINT
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,312251}
Process ID: 424
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: SHAREPOINT$
Primary Domain:
Primary Logon ID: (0x0,0x3E7)
Client User Name:
Client Domain:
Client Logon ID: (0x0,0x4BA2A)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 3/15/2007
Time: 3:53:11 PM
User:
Computer: SHAREPOINT
Description:
Object Open:
Object Server: Security Account Manager
Object Type: SAM_ALIAS
Object Name: DOMAINS\Account\Aliases\000003ED
Handle ID: -
Operation ID: {0,286316}
Process ID: 436
Image File Name: C:\WINDOWS\system32\lsass.exe
Primary User Name: SHAREPOINT$
Primary Domain:
Primary Logon ID: (0x0,0x3E7)
Client User Name:
Client Domain:
Client Logon ID: (0x0,0x45D1D)
Accesses: AddMember
RemoveMember
ListMembers
ReadInformation
Privileges: -
Restricted Sid Count: 0
Access Mask: 0xF
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Has anybody had any luck in resolving this issue - I have the same problem in fact it only breaks when i try to enable Kerberos authentication by running the following commands:
stsadm -o set-ecssecurity -ssp SharedServices1 -accessmodel delegation
stsadm -o execadmsvcjobs
If I have the accessmodel set to TrustedSubsystem then it will open a blank worksheet (with no external connections) as soon as it is changed to delegation I just get a page saying an Error has occured.
After setting the access model to delegation, if you're getting an Error has occured, it most likely a result of improper SPN registered for the shared services account and/or missing enaling kerberos delegation in active directory from the sharepoint webapplication to the shared service.
To get kerberos working in moss you need to:
1. Enable kerberos authentication to share point web application, you can do so from central admin. If the sharepoint application pool is a domain account, then you must register an SPN for it, e.g.
machine FQDN = sharepoint.domain.com
apppoolaccount = domain\sharepoint
setspn -a http/sharepoint domain\sharepoint
setspn -a http/sharepoint.domain.com domain\sharepoint
(if it's a machine service account (e.g. Network Service) then an SPN is already registered when the machine was joined to the domain.)
2. Enable kerberos authenticaiton to the shared services by running the following stsadm commands on the shared services machine:
stsadm -o set-ecssecurity -accessmodel delegation -ssp SharedServices1
stsadm -o setsharedwebserviceauthn -negotiate
stsadm -o execadmsvcjobs
You'd also need to register SPNs for it if running under a domain account.
machine FQDN = sharedservice.domain.com
apppoolaccount = domain\sharedservice
setspn -a http/sharedservice domain\sharedservice
setspn -a http/sharedservice.domain.com domain\sharedservice
3. In active directory you need to enable delegation from the domain\sharepoint account to the SPNs you registered for the domain\sharedservice account.
That should do the trick.
As for accessing data sources using delegation from excel services, you'll need to:
4. Register SPNs for the data source. e.g. SSAS 2005:
setspn -a MSOLAPSvc.3/ssasmachinename domain\ssasaccount
setspn -a MSOLAPSvc.3/ssasmachinename.domain.com domain\ssasaccount
5. In active directory you need to enable delegation from the domain\sharedservice account to the SPNs you registered for the domain\ssasaccount account.
Hello,
I have same Issue when I try the show the Excel file from Excel Web Part in the SharePoint 2007. The web part show this message "An error has occurred.Please contact your system administrator if this problem persists". But the rare of this, If I check this same page from local network like intranet page, the Web part works fine, and show the File in the web part. The problem only show when I try access from the outside of the network like an internet Page and the rest of the page work fine. I access to the site with same rights for both cases. What is the problem of this? Somebody help me please. Thanks.
Regards,
Edgar.
This sounds like an Alternate Access Mapping issue. The excel web part fails to determine which zone you're navigating from, and thus fails to discover the backend excel servers.
i've tried all the steps including all the ones in the posts above this.... even mappings dint help
but the exception doesnt seem 2 leave me.....
it is the "Access is Denied" exception when i debug the UDF at runtime....n its because it doesnt get a valid SPWeb object on SPSite.OpenWeb().....
ERROR LOG SHOWS THE FOLLOWING:
There was an error in communicating with Excel Calculation Services http://ind-asdf/MySite/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized.
if someone has found the solution, plz help me out
- I am having this same issue. I've run into what I think is the problem with trying to use kerberos with this process when you are using more than one server. We have 1 SharePoint Web Server, 1 SharePoint "index" server that hosts search, excel services, etc..., 1 database server and 1 server with analysis server that holds the data we are trying to access.
When SharePoint installs it will create create an Office Web Services IIS site using a servername
ort address and the application pool must run using Netowrk Service. Becuase of this the server that this site is running on, in our case the index server, must have an spn setup for the server. Now, when you setup excel services you must use a domain account for the application pool and the location for the excel web services is automatically placed under the Office Web Services IIS site using a virtual folder. Because its application pool uses a domain account the domain account needs to have the same spn entry set as the server it is located on, which causes a duplicate spn instance to occur and will cause Kerberos to fail, causing the excel services web service call to revert back to ntlm, which would give yhou the unauthorized error, correct? Am I missing somthing where having the same spn set at both the server level and the domain account level does not cause a problem? Maybe I am missing something. To resolve the conflicting SPN for the index server and excel service, can you either have excel service run as network service as well, or enable the role of the index server on a seperate server
What are you trying to accomplish in the UDF?
Are you able to open workbooks on the server that don't use the UDF?
i'm able 2 open workbooks on the server...
in fact, i can also open the Workbk with the UDF on the 1st pg load wen it has the default parameters... but when i pass the parameters thru the paramters task pane at runtime, it throws the error i mentioned above....
in the UDF i'm accessin a Sharepoint list n returning the count....whas strange is that it wrks perfectly fine n returns the correct count on the 1st pg load...
Hello!
I want to continue this theme.
I have installed MOSS 2007 and everything works OK apart from Excel services. When I try and conect to an uploaded spreadsheet to view it in a browser I get the error in the event log There was an error in communicating with Excel Calculation Services http://server:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 407: Proxy Authentication Required. [Session: (null) User: SHAREPOINT\Sirenast].
I have checked that the spreadsheet is in document library which is a trusted location. System is using NTLM authentication, but I have set up SSO. Do I need kerberos set up for this set up? IE settings for proxy server on the server and client settings are set to direct connection. I can browse to http://server:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx OK and it comes up with the ExcelServiceSoap page. The relevant server log section is shown below:
01/28/2008 13:45:22.96 w3wp.exe (0x0D6C) 0x05F4 Office Server Office Server Shared Services 6pls Medium Cache blocked for shared object '7350d7d8-fbe1-4cc2-a25b-83fc1bd93640' of type 'Microsoft.Office.Excel.Server.ExcelServerSharedWebApplication'.
01/28/2008 13:45:22.99 w3wp.exe (0x0D6C) 0x0948 Excel Services Excel Services Web Front End 481t Information Excel Calculation Services added to the load balancer http://SERVER:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx. [User: SHAREPOINT\Sirenast]
01/28/2008 13:45:23.73 w3wp.exe (0x0D6C) 0x0948 Excel Services Excel Services Web Front End 6k38 Medium ExcelServerProxy.ExecuteWebMethod: sending request of type OpenWorkbook, to server=http://server:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx, session=(null), state id=-1
01/28/2008 13:45:24.73 w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Services Web Front End 6k3i Medium ExcelServerProxy.ProcessWebException: A Web exception during ExecuteWebMethod has occurred for server: http://server:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx, method: OpenWorkbook, ex: System.Net.WebException: The request failed with HTTP status 407: Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy filter is denied. ). at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServiceSoap.OpenWorkbook(String url, CommandParamet...
01/28/2008 13:45:24.73* w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Services Web Front End 6k3i Medium ...er parameter, CultureCommandParameter cultureParameter, Guid requestSiteId, String& workbookId, Boolean& hasOpenItemPermission) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.<>c__DisplayClass1.<OpenWorkbook>b__0(CommandParameter parameterDelegate, ExcelServiceSoap excelService) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.ExecuteWithSecurityContext(Boolean revertToSelf, CoreWebMethod coreWebMethod, ExcelServiceSoap excelService, CommandParameter parameter) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.ExecuteWebMethod(WebMethodType webMethodType, PreProcessWebMethod preProcessWebMethod, CoreWebMethod coreWebMethod, Boolean& noServerResponse), response: 'System.Net.HttpWebResponse', status Proto...
01/28/2008 13:45:24.73* w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Services Web Front End 6k3i Medium ...colError, user name: SHAREPOINT\Sirenast.
01/28/2008 13:45:24.73 w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Services Web Front End 3skf Critical There was an error in communicating with Excel Calculation Services http://server:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 407: Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy filter is denied. ). [Session: (null) User: SHAREPOINT\Sirenast].
01/28/2008 13:45:24.74 w3wp.exe (0x0D6C) 0x05F4 SharePoint Portal Server Business Data 81ky Exception An error has occured trying to get session from a workbook. Workbook: http://server/sites/ReportCenter/ReportsLibrary/SampleWorkbook.xlsx. Microsoft.Office.Excel.Server.WebServices.ExcelServerApiException: Произошла ошибка. at Microsoft.Office.Excel.Server.WebServices.ApiShared.ExecuteProxyMethod(Boolean hasSessionId, String sessionId, CoreProxyMethod coreWebMethod) at Microsoft.Office.Excel.Server.WebServices.ExcelService.OpenWorkbook(String workbookPath, String uiCultureName, String dataCultureName, Status[]& status) at Microsoft.SharePoint.Portal.WebControls.KPIHelper.GetSessionIDFromWorkbook(String workbookUrl)
01/28/2008 13:45:24.74 w3wp.exe (0x0D6C) 0x05F4 SharePoint Portal Server Business Data 63vh High Error occurred in retrieving kpi data. list: /sites/ReportCenter/Lists/Sample Dashboard/KPIListViewPage.aspx item: Минимальное количество.
01/28/2008 13:45:25.44 w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Web Access 5cbi Medium InternalEwr.OnInit: Starting loading external EWR
01/28/2008 13:45:25.57 w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Services Web Front End 6k38 Medium ExcelServerProxy.ExecuteWebMethod: sending request of type OpenWorkbook, to server=http://server:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx, session=(null), state id=0
01/28/2008 13:45:25.58 w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Services Web Front End 6k3i Medium ExcelServerProxy.ProcessWebException: A Web exception during ExecuteWebMethod has occurred for server: http://server:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx, method: OpenWorkbook, ex: System.Net.WebException: The request failed with HTTP status 407: Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy filter is denied. ). at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServiceSoap.OpenWorkbook(String url, CommandParamet...
01/28/2008 13:45:25.58* w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Services Web Front End 6k3i Medium ...er parameter, CultureCommandParameter cultureParameter, Guid requestSiteId, String& workbookId, Boolean& hasOpenItemPermission) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.<>c__DisplayClass1.<OpenWorkbook>b__0(CommandParameter parameterDelegate, ExcelServiceSoap excelService) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.ExecuteWithSecurityContext(Boolean revertToSelf, CoreWebMethod coreWebMethod, ExcelServiceSoap excelService, CommandParameter parameter) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ExcelServerProxy.ExecuteWebMethod(WebMethodType webMethodType, PreProcessWebMethod preProcessWebMethod, CoreWebMethod coreWebMethod, Boolean& noServerResponse), response: 'System.Net.HttpWebResponse', status Proto...
01/28/2008 13:45:25.58* w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Services Web Front End 6k3i Medium ...colError, user name: SHAREPOINT\Sirenast.
01/28/2008 13:45:25.58 w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Services Web Front End 3skf Critical There was an error in communicating with Excel Calculation Services http://server:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 407: Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy filter is denied. ). [Session: (null) User: SHAREPOINT\Sirenast].
01/28/2008 13:45:25.60 w3wp.exe (0x0D6C) 0x05F4 Excel Services Excel Web Access 5cbj Medium InternalEwr.RenderWebPart: Finished rendering internal EWR
What is it? Does anybody know?
We have the same issues any help would be great.
We have been trying to get this to work for over 6 months even with Microsoft's Help to no avail.
Helping from them is lacking seriously.
Here is a snippet of our log I have removed any security issues as far as id's and server and site names.
01/30/2008 11:25:17.37 w3wp.exe (0x054C) 0x1FBC Excel Services Excel Services Web Front End 3skf Critical There was an error in communicating with Excel Calculation Services http://Servername:56737/Site-SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/Site-SharedServices1/ExcelCalculationServer/ExcelService.asmx?AspxAutoDetectCookieSupport=1">here</a>.</h2> </body></html> --. [Session: (null) User: domain\username].
01/30/2008 11:25:17.37 w3wp.exe (0x054C) 0x1FBC SharePoint Portal Server Business Data 81ky Exception An error has occured trying to get session from a workbook. Workbook: http://SiteName/dashboard/ReportsLibrary/SampleWorkbook.xlsx. Microsoft.Office.Excel.Server.WebServices.ExcelServerApiException: An error has occurred. at Microsoft.Office.Excel.Server.WebServices.ApiShared.ExecuteProxyMethod(Boolean hasSessionId, String sessionId, CoreProxyMethod coreWebMethod) at Microsoft.Office.Excel.Server.WebServices.ExcelService.OpenWorkbook(String workbookPath, String uiCultureName, String dataCultureName, Status[]& status) at Microsoft.SharePoint.Portal.WebControls.KPIHelper.GetSessionIDFromWorkbook(String workbookUrl)
01/30/2008 11:25:17.52 w3wp.exe (0x054C) 0x0A10 Excel Services Excel Services Web Front End 3skf Critical There was an error in communicating with Excel Calculation Services http://Servername:56737/Site-SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/Site-SharedServices1/ExcelCalculationServer/ExcelService.asmx?AspxAutoDetectCookieSupport=1">here</a>.</h2> </body></html> --. [Session: (null) User: domain\username].
01/30/2008 11:25:17.37 w3wp.exe (0x054C) 0x0A10 Excel Services Excel Services Web Front End 3skf Critical There was an error in communicating with Excel Calculation Services http://Servername:56737/Site-SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/Site-SharedServices1/ExcelCalculationServer/ExcelService.asmx?AspxAutoDetectCookieSupport=1">here</a>.</h2> </body></html> --. [Session: (null) User: domain\username].
01/30/2008 11:25:17.37 w3wp.exe (0x054C) 0x0A10 SharePoint Portal Server Business Data 81ky Exception An error has occured trying to get session from a workbook. Workbook: http://SiteName/dashboard/ReportsLibrary/SampleWorkbook.xlsx. Microsoft.Office.Excel.Server.WebServices.ExcelServerApiException: An error has occurred. at Microsoft.Office.Excel.Server.WebServices.ApiShared.ExecuteProxyMethod(Boolean hasSessionId, String sessionId, CoreProxyMethod coreWebMethod) at Microsoft.Office.Excel.Server.WebServices.ExcelService.OpenWorkbook(String workbookPath, String uiCultureName, String dataCultureName, Status[]& status) at Microsoft.SharePoint.Portal.WebControls.KPIHelper.GetSessionIDFromWorkbook(String workbookUrl)
I cant beleieve this but this was my fix after remembering something about our search center.
I went into IIS opened Office Server Web Services Instance then clicked the ASP.NET tab
I then clicked the edit configuration and chose state management.
Then I set everything to look as follows
Session State Mode:SQLServer
Cookieless Mode:Use Cookies
SQL Server Settings: data source=localhost;Integrated Security=SSPI
Everything works now with no errors
- Hi everyone,
I had similar problem with Excel Services on Sharepoint 2007. The problem was the proxy setting for Sharepoint.
I ran wireshark on sharepoint server and figured that it was using proxy server (squid in my network environment) to connect to Excel Services.
Proxy wouldn't support Windows Integrated authentication (Kerberos here, I also tried Basic Authentication but it was unsuccessful too) and I was getting 401.2 Unauthorized...
After about 2 weeks poking around (I am not very smart or quick) I figured out that sharepoint is getting it's proxy setting from WPAD (Web Proxy Autodiscovery Protocol).
I looked up on the web where would be this setting set for Sharepoint Server and found this web site:
Proxy Server Settings for Sharepoint 2007 http://geekswithblogs.net/hinshelm/archive/2007/10/24/Proxy-server-settings-for-SharePoint-2007.aspx
The configuration file I edited "c:\inetpup\wwwroot\wss\VirtualDirectories\80\web.config"
My setting was:
<system.net>
<defaultProxy>
<proxy autoDetect="true" />
</defaultProxy>
</system.net>
I have changed it to:
<system.net>
<defaultProxy>
<proxy usesystemdefault="false" proxyaddress="http://my_proxy_server:8080" bypassonlocal="true" />
</defaultProxy>
</system.net>
I ran:
iisreset /noforce <Enter>
from command window and all is sweet.
I can pick the cell when setting KPI etc. that was my problem
It could also be worth to look at this site:
Working with web.config Files in Windows SharePoint Services
http://msdn.microsoft.com/en-us/library/ms868619.aspx
Cheers
Peter Krisf...Good solution,
I don't understand very well, why the sharepoint has this behave ... but, now my sharepoint is ok .
tks a lot.
