Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh: Power Pivot Data

Friday, January 25, 2013 12:46 AM

0
HI

I am getting Error like

Unable to refresh data for a data connection in the workbook.
Try again or contact your system administrator. The following connections failed to refresh:
PowerPivot Data.

When i created a excel workbook from plain excel data and publish to SharePoint Pivot gallery, Its working fine and i am able to filter with different columns.

But i am getting above error while i try to create Excel Workbook from SQL 2008R2 Database table and publish to SharePoint Pivot gallery, its working fine but while i try to apply any filters, then i am getting error.

Please help me to resolve this issue.

Farm Config:

1-APP Server(Central Admin)

1-WFE

1-SQL 2008 R2 Database
- Changed Type surapanenikiran Friday, January 25, 2013 12:56 AM
- Reply
- Quote

All Replies

Monday, January 28, 2013 9:28 AM

0
Hi,

I have a few questions?
- What version of SharePoint are you running?
- What Version of SQL are you running?
- How did you configure AS PowerPivot?
- Is the xslx file in a trusted location?
- Do you have PowerPivot refreshing in any other Excel file?
Also, I have couple of resolutions you may try, but I will not know any further information until you answer the questions above.
- Scenario 1: Service is not started
- Scenario 2a: Opening an earlier version workbook n the server
- Scenario 2b: Excel Services is running on an application server that has the wrong version of the client libraries
- Scenario 3: Domain controller is unavailable
- Scenario 4: Unstable server
Reference: The resolution to the scenarios above http://msdn.microsoft.com/en-us/library/ff487856.aspx

Dependent on the versions of SharePoint and PowerPivot it is most likely a configuration issue.

-Ivan

Ivan Sanders My LinkedIn Profile, My Blog, @iasanders, Business Intelligence in SharePoint 2013.
- Edited by Ivan SandersMVP Monday, January 28, 2013 9:29 AM
- Proposed As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, January 29, 2013 7:09 AM
- Reply
- Quote
Tuesday, January 29, 2013 7:12 AM

Moderator

0

Hello,

Please also take a look at the following article to troubleshot this issue:
http://social.technet.microsoft.com/wiki/contents/articles/11566.refreshing-powerpivot-for-sharepoint-2010-sql-2008-the-data-connection-uses-windows-authentication-unable-to-refresh-data-for-a-data-connection-in-the-workbook-errors-en-us.aspx
http://www.sharemuch.com/2012/01/22/troubleshooting-powerpivot-unable-to-refresh-data-for-a-data-connection-in-the-workbook/

Regards,
Elvis Long
TechNet Community Support
- Reply
- Quote
Wednesday, January 30, 2013 7:31 PM

0
Thanks for your reply
- What version of SharePoint are you running? 2010 (14.0.6109.5002)
- What Version of SQL are you running? SQL 2008 R2
- How did you configure AS PowerPivot?
- FOLLOWED ALL STEPS IN
- http://powerpivotgeek.com/docs/PowerPivot_Existing_Farm_Installation.pdf
- Is the xslx file in a trusted location? YES
- Do you have PowerPivot refreshing in any other Excel file?
PowerPivot refresh Excel files independent of database, means all data in Excel itself. But if any excel files having SQL database connection, it's not refreshing.

I have one more question

My SharePoint farm configuration

1-WFE, 1-APP SERVER(CENTRAL ADMIN), 1-FAST, 1-SQL 2008 R2 DB.

I installed and configured PowerPivot in APP server but do I need to install anything on WFE?

Please help me to resolve this issue.
- Reply
- Quote
Thursday, January 31, 2013 2:25 AM

Moderator

0
Hi surapanenikiran,

Could you please help to collect the log information to us for further investigation? Please refer to the following article:
View Log Files (PowerPivot for SharePoint): http://technet.microsoft.com/en-us/library/ee210652(v=sql.105).aspx

To new question, we can find the following description in the document you posted above:
On each WFE (that is, each machine on which you installed and configured SharePoint but did not run Analysis Services setup; in this case, this is the server named WFE), install the following:
a. The SQL Server Analysis Services 10.0 OLE DB Provider (MSOLAP) from http://go.microsoft.com/fwlink/?LinkID=188445&clcid=0x409
b. Microsoft ADOMD.NET (ADOMD) for SQL Server 2008 R2 from http://go.microsoft.com/fwlink/?LinkID=188442&clcid=0x409

For the installation, you can refer to the following document:
Installation (PowerPivot for SharePoint): http://technet.microsoft.com/en-us/library/ee210654(v=sql.105).aspx

Regards,
Elvis Long
TechNet Community Support
- Proposed As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 04, 2013 2:05 AM
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, February 05, 2013 1:56 AM
- Reply
- Quote
Wednesday, February 06, 2013 11:49 PM

0

Thanks for your reply. I installed PowerPivot on our Staging environment but still get the same issue. I got the below logs Document=http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.47 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services 7up6 Medium Session.HandleTrimmedWorkbookReloading: userOperation GetRangeOperation doesn't require Baseworkbook To be untrimmed. 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.51 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Result=Success 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.51 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services eci4 Medium ExcelService.PostProcessRequest: finished request of type GetRange 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.51 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=44.6031548702419 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.52 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:bf3d87f7-3ce3-4269-bb78-4ac76bab1394' 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.52 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.52 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services ecc3 Medium ExcelServiceBase.EndProcessOperation: Called. UserOperation was finished synchronously: True 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.52 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services d64g Medium UserOperation.Dispose: Disposing Microsoft.Office.Excel.Server.CalculationServer.Operations.GetRangeOperation, WebMethod: GetRange. 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.52 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=0.269238129427064 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.53 w3wp.exe (0x207C) 0x2254 Excel Services Application Web Front End abvg Medium ServerSession.ExecuteWebMethodCore: request of type GetRange succeeded, from server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, new state id=7, health score=0, error delta=0 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.53 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium Result=Success 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:20.58 w3wp.exe (0x207C) 0x2254 Excel Services Application Browser 3k9g Medium InternalEwr.RenderWebPart: Finished rendering internal EWR 465f37cc-20b4-46c2-87a3-559cfd8e2419 02/06/2013 15:19:21.42 w3wp.exe (0x207C) 0x328C Excel Services Application Web Front End abvf Medium ServerSession.ExecuteWebMethodCore: sending request of type GetRange, to server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, state id=-1, health score=0, error delta=0 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.42 w3wp.exe (0x207C) 0x328C Excel Services Application Excel Calculation Services d51n Medium MossHost.GetEndpointAddress: Server endpoint Uri: http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx. 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.43 w3wp.exe (0x207C) 0x328C SharePoint Foundation Topology e5mc Medium WcfSendRequest: RemoteAddress: 'http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'Microsoft.Office.Excel.Server.CalculationServer.Proxy.IExcelServiceSoap' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:eb309edd-d070-49c7-8915-e9cd9f5836c7' 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.43 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:eb309edd-d070-49c7-8915-e9cd9f5836c7' 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.43 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.43 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium ECS RequestId=4462 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.43 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services eca6 Medium ExcelService.LogRequest: starting request of type GetRange. Caller ip=fe80::ad54:68e5:345b:52d7%12 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.43 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium User=0#.w|ewbc\ksurapaneni 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.43 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.43 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium User=EWBC\KSURAPANENI 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.43 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium Session=36.0769cf06-c88d-4a01-81cd-57b05ade6815162.1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.43 w3wp.exe (0x207C) 0x2254 Excel Services Application Browser 147s Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler: started processing 'GetRangeContent' web method call 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.43 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Document=http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.43 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services 7up6 Medium Session.HandleTrimmedWorkbookReloading: userOperation GetRangeOperation doesn't require Baseworkbook To be untrimmed. 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.43 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.43 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium User=EWBC\KSURAPANENI 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:18.97 OWSTIMER.EXE (0x22C4) 0x2720 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Timer Job SchedulingApproval) 34297a65-25ac-44ee-b0f3-0b296df2e28c 02/06/2013 15:19:18.99 OWSTIMER.EXE (0x22C4) 0x2720 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Timer Job SchedulingApproval). Execution Time=21.6570122739063 34297a65-25ac-44ee-b0f3-0b296df2e28c 02/06/2013 15:19:21.44 w3wp.exe (0x207C) 0x2254 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Result=Success 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services eci4 Medium ExcelService.PostProcessRequest: finished request of type GetRange 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=5.35047052069467 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:eb309edd-d070-49c7-8915-e9cd9f5836c7' 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services ecc3 Medium ExcelServiceBase.EndProcessOperation: Called. UserOperation was finished synchronously: True 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services d64g Medium UserOperation.Dispose: Disposing Microsoft.Office.Excel.Server.CalculationServer.Operations.GetRangeOperation, WebMethod: GetRange. 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=0.435250848920743 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.44 w3wp.exe (0x207C) 0x2254 Excel Services Application Web Front End abvf Medium ServerSession.ExecuteWebMethodCore: sending request of type GetRange, to server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, state id=-1, health score=0, error delta=0 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.44 w3wp.exe (0x207C) 0x2254 Excel Services Application Excel Calculation Services d51n Medium MossHost.GetEndpointAddress: Server endpoint Uri: http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx. 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.44 w3wp.exe (0x207C) 0x328C Excel Services Application Web Front End abvg Medium ServerSession.ExecuteWebMethodCore: request of type GetRange succeeded, from server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, new state id=7, health score=0, error delta=0 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.44 w3wp.exe (0x207C) 0x2254 SharePoint Foundation Topology e5mc Medium WcfSendRequest: RemoteAddress: 'http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'Microsoft.Office.Excel.Server.CalculationServer.Proxy.IExcelServiceSoap' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:5120c738-d045-4c17-8b13-29cd50a93718' 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.44 w3wp.exe (0x207C) 0x328C SharePoint Server Logging Correlation Data xmnv Medium Result=Success 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:5120c738-d045-4c17-8b13-29cd50a93718' 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium ECS RequestId=4463 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.44 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services eca6 Medium ExcelService.LogRequest: starting request of type GetRange. Caller ip=fe80::ad54:68e5:345b:52d7%12 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium User=0#.w|ewbc\ksurapaneni 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Document=http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services 7up6 Medium Session.HandleTrimmedWorkbookReloading: userOperation GetRangeOperation doesn't require Baseworkbook To be untrimmed. 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Result=Success 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services eci4 Medium ExcelService.PostProcessRequest: finished request of type GetRange 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=4.49596247567778 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:5120c738-d045-4c17-8b13-29cd50a93718' 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x207C) 0x328C Excel Services Application Browser 147u Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler: complete processing 'GetRangeContent' web method call 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services ecc3 Medium ExcelServiceBase.EndProcessOperation: Called. UserOperation was finished synchronously: True 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services d64g Medium UserOperation.Dispose: Disposing Microsoft.Office.Excel.Server.CalculationServer.Operations.GetRangeOperation, WebMethod: GetRange. 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=0.265815906770274 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x207C) 0x2254 Excel Services Application Web Front End abvg Medium ServerSession.ExecuteWebMethodCore: request of type GetRange succeeded, from server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, new state id=7, health score=0, error delta=0 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium Result=Success 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:21.45 w3wp.exe (0x207C) 0x328C SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:http://stg.bridgenet.ewbc.net:80/departments/_vti_bin/DynamicGridContent.json/GetRangeContent?context=%7B%22SessionId%22%3A%2236.0769cf06-c88d-4a01-81cd-57b05ade6815162.1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.%2B0480%230000-11-00-01T02%3A00%3A00%3A0000%23%2B0000%230000-03-00-02T02%3A00%3A00%3A0000%23-006036.fa97da1c-4667-4583-9808-64a710c360d71.N%22%2C%22TransientEditSessionToken%22%3Anull%2C%22PermissionFlagsHash%22%3A%22JOJRj%2Fs9Q809bGW%2FfG8V%2BmFAjBodUG5XQwptslzR2nZdTiewAa8VKDBXp%2Fb0HGrSkcXaG5va3DxsnGwxYSsOTHJDJ0FpniShUyhfA3dfnHlO3ko1UZfPo2DrUOEx5qP4zwSOZ1jAaLdYkuYCGQB37SMNa6UnSAo02P3n%2FgfQd2wd6qfkADir3wdpEPTd6Mbq%2FGivuefaW%2Bc%3D%22%2C%22CompleteResponseTimeout%22%3A0%2C%22CollaborationParameter%22%3A%7B%22CollaborationState%22%3A%7B%7D... 4a79c2a2-e059-4462-b267-8075c4cf9890 02/06/2013 15:19:21.24 w3wp.exe (0x0864) 0x1368 Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Memory Manager: CurrentSize=475340800. 53fed7f1-fd48-7254-0000-000050f7b00c amedItem=false&row=28&column=0&rowCount=28&columnCount=30&blockX=0&blockY=1&revision=-1)). Execution Time=46.9540123116206 889aa8b7-9d58-4ade-b57b-293d24ad276d 02/06/2013 15:19:23.52 w3wp.exe (0x1FEC) 0x0880 Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Memory Manager: CurrentSize=405270528. 53fed7f1-1cd6-27fa-0000-000050f7b00c 02/06/2013 15:19:23.76 w3wp.exe (0x17E0) 0x0274 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/cb20eee826a34d5483740a4a1b8bb153/MetadataWebService.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:65585859-776d-480a-ae16-b978127c4de6' 3362b523-77e6-4ca0-bd0a-83a9ca47db56 02/06/2013 15:19:23.76 w3wp.exe (0x17E0) 0x0274 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 3362b523-77e6-4ca0-bd0a-83a9ca47db56 02/06/2013 15:19:23.76 w3wp.exe (0x17E0) 0x0274 SharePoint Server Taxonomy fuc5 Medium MetadataWebServiceApplication.GetChanges called on 'Managed Metadata Service STE' starting. 3362b523-77e6-4ca0-bd0a-83a9ca47db56 02/06/2013 15:19:23.76 w3wp.exe (0x17E0) 0x0274 SharePoint Server Taxonomy fuc6 Medium MetadataWebServiceApplication.GetChanges called on 'Managed Metadata Service STE' completed. 3362b523-77e6-4ca0-bd0a-83a9ca47db56 02/06/2013 15:19:23.76 w3wp.exe (0x17E0) 0x0274 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=1.93048278482321 3362b523-77e6-4ca0-bd0a-83a9ca47db56 02/06/2013 15:19:23.94 w3wp.exe (0x1FEC) 0x15E0 Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Disk Manager: CurrentSize=1470356. 11c5f189-1cd6-27fa-0000-000050f7b00c 02/06/2013 15:19:25.00 w3wp.exe (0x207C) 0x2254 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Request (POST:http://stg.bridgenet.ewbc.net:80/departments/_vti_bin/EwaInternalWebService.json/ApplySlicerSelection)) 02/06/2013 15:19:25.00 w3wp.exe (0x207C) 0x2254 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (POST:http://stg.bridgenet.ewbc.net:80/departments/_vti_bin/EwaInternalWebService.json/ApplySlicerSelection) cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.01 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium User=EWBC\KSURAPANENI cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.01 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium Session=36.0769cf06-c88d-4a01-81cd-57b05ade6815162.1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.01 w3wp.exe (0x207C) 0x2254 Excel Services Application Browser 147s Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler: started processing 'ApplySlicerSelection' web method call cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.01 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.01 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium User=EWBC\KSURAPANENI cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.01 w3wp.exe (0x207C) 0x2254 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.01 w3wp.exe (0x207C) 0x2254 Excel Services Application Web Front End abvf Medium ServerSession.ExecuteWebMethodCore: sending request of type ApplySlicerSelection, to server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, state id=-1, health score=0, error delta=0 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.01 w3wp.exe (0x207C) 0x2254 Excel Services Application Excel Calculation Services d51n Medium MossHost.GetEndpointAddress: Server endpoint Uri: http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx. cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.02 w3wp.exe (0x207C) 0x2254 SharePoint Foundation Topology e5mc Medium WcfSendRequest: RemoteAddress: 'http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'Microsoft.Office.Excel.Server.CalculationServer.Proxy.IExcelServiceSoap' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelection' MessageId: 'urn:uuid:22cce4d4-8882-4387-b537-56119a16139c' cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.02 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelection' MessageId: 'urn:uuid:22cce4d4-8882-4387-b537-56119a16139c' cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.02 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.02 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium ECS RequestId=4464 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.02 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services eca6 Medium ExcelService.LogRequest: starting request of type ApplySlicerSelection. Caller ip=fe80::ad54:68e5:345b:52d7%12 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.02 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium User=0#.w|ewbc\ksurapaneni cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.02 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.02 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Document=http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.02 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services bccc Medium Session.HandleTrimmedWorkbookReloading: userOperation ApplySlicerSelectionOperation requires BaseWorkbook: "http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx" [0x409] [Wednesday, 06 February 2013 23:02:12] [BaseWB ID: 1] to be untrimmed if it is currently trimmed. The workbook is currently NOT trimmed. cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.03 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services f1va Medium CWorkbookWrapper::CWorkbookWrapper: Created with ID=8 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:24.47 w3wp.exe (0x0864) 0x1308 Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Disk Manager: CurrentSize=584461. 11c5f189-fd48-7254-0000-000050f7b00c 02/06/2013 15:19:25.01 OWSTIMER.EXE (0x22C4) 0x0E60 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Timer Job SchedulingApproval) 786a7168-8a70-4c86-9557-f4e46002ecd8 02/06/2013 15:19:25.02 OWSTIMER.EXE (0x22C4) 0x0E60 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Timer Job SchedulingApproval). Execution Time=3.60716236281427 786a7168-8a70-4c86-9557-f4e46002ecd8 02/06/2013 15:19:25.03 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services eq3r Medium ConnectionRequest.ConnectionRequest: New connection request. SessionId=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, WorkbookVersion=ConnectionInfo.WorkbookVersion: Uri=http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx, Version=Wednesday, 06 February 2013 23:02:12 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.03 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services aysl Medium Succeeded to initialize a chart. cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.03 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services 8xk9 Medium ExternalSource.ExecuteOperation: We exhausted all available connection information. Exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException: Exception of type 'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException' was thrown. at Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request request, String externalSourceName, Int32 externalSourceIndex, Boolean& shouldReportFailure) at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request request, ExternalSourceStateInfo externalSourceStateInfo, ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index, ConnectionInfoManager connectionInfoManager, ExternalDataScenario scenario, DataOperation dataOpe... cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.03* w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services 8xk9 Medium ...ration, Boolean verifyPreOperationConnection), Data Connection Name: PowerPivot Data, SessionId: 1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, UserId: 0#.w|ewbc\ksurapaneni cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Result=Success cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services f1ve Medium CWorkbookWrapper::FinalRelease: Heap is still referenced! refCount=199, ID=8 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services f1vb Medium CWorkbookWrapper::~CWorkbookWrapper: Destroying. ID=8 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services eci4 Medium ExcelService.PostProcessRequest: finished request of type ApplySlicerSelection cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=15.6439575420898 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelection' MessageId: 'urn:uuid:22cce4d4-8882-4387-b537-56119a16139c' cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services ecc3 Medium ExcelServiceBase.EndProcessOperation: Called. UserOperation was finished synchronously: True cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services d64g Medium UserOperation.Dispose: Disposing Microsoft.Office.Excel.Server.CalculationServer.Operations.ApplySlicerSelectionOperation, WebMethod: ApplySlicerSelection. cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=0.266863525950924 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x207C) 0x2254 Excel Services Application Web Front End abvg Medium ServerSession.ExecuteWebMethodCore: request of type ApplySlicerSelection succeeded, from server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, new state id=8, health score=0, error delta=0 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium Result=Success cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x207C) 0x2254 Excel Services Application Browser 147u Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler: complete processing 'ApplySlicerSelection' web method call cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:25.04 w3wp.exe (0x207C) 0x2254 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (POST:http://stg.bridgenet.ewbc.net:80/departments/_vti_bin/EwaInternalWebService.json/ApplySlicerSelection)). Execution Time=37.8704556025975 cdc6dd8b-f573-4a6a-b820-20b3f11b6bb2 02/06/2013 15:19:28.53 w3wp.exe (0x1FEC) 0x0880 Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Memory Manager: CurrentSize=406478848. 53fed7f1-1cd6-27fa-0000-000050f7b00c 02/06/2013 15:19:30.19 w3wp.exe (0x207C) 0x328C Excel Services Application Browser 147s Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler: started processing 'GetRangeContent' web method call 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.20 w3wp.exe (0x207C) 0x328C SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.20 w3wp.exe (0x207C) 0x328C SharePoint Server Logging Correlation Data xmnv Medium User=EWBC\KSURAPANENI 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.20 w3wp.exe (0x207C) 0x328C SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.20 w3wp.exe (0x207C) 0x328C Excel Services Application Web Front End abvf Medium ServerSession.ExecuteWebMethodCore: sending request of type GetRange, to server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, state id=8, health score=0, error delta=0 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.20 w3wp.exe (0x207C) 0x328C Excel Services Application Excel Calculation Services d51n Medium MossHost.GetEndpointAddress: Server endpoint Uri: http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx. 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.20 w3wp.exe (0x207C) 0x328C SharePoint Foundation Topology e5mc Medium WcfSendRequest: RemoteAddress: 'http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'Microsoft.Office.Excel.Server.CalculationServer.Proxy.IExcelServiceSoap' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:e47ec6e9-639d-4d12-9848-051ee03ce67f' 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.20 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium User=EWBC\KSURAPANENI 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.20 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium Session=36.0769cf06-c88d-4a01-81cd-57b05ade6815162.1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.20 w3wp.exe (0x207C) 0x2254 Excel Services Application Browser 147s Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler: started processing 'GetRangeContent' web method call 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.20 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.21 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium User=EWBC\KSURAPANENI 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.21 w3wp.exe (0x207C) 0x2254 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.21 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:e47ec6e9-639d-4d12-9848-051ee03ce67f' 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.21 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.21 w3wp.exe (0x1FEC) 0x1B14 SharePoint Server Logging Correlation Data xmnv Medium ECS RequestId=4465 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.21 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services eca6 Medium ExcelService.LogRequest: starting request of type GetRange. Caller ip=fe80::ad54:68e5:345b:52d7%12 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.21 w3wp.exe (0x1FEC) 0x1B14 SharePoint Server Logging Correlation Data xmnv Medium User=0#.w|ewbc\ksurapaneni 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.21 w3wp.exe (0x1FEC) 0x1B14 SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.21 w3wp.exe (0x1FEC) 0x1B14 SharePoint Server Logging Correlation Data xmnv Medium Document=http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.21 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services 7up6 Medium Session.HandleTrimmedWorkbookReloading: userOperation GetRangeOperation doesn't require Baseworkbook To be untrimmed. 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.21 w3wp.exe (0x207C) 0x2254 Excel Services Application Web Front End abvf Medium ServerSession.ExecuteWebMethodCore: sending request of type GetRange, to server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, state id=8, health score=0, error delta=0 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.21 w3wp.exe (0x207C) 0x2254 Excel Services Application Excel Calculation Services d51n Medium MossHost.GetEndpointAddress: Server endpoint Uri: http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx. 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.21 w3wp.exe (0x207C) 0x2254 SharePoint Foundation Topology e5mc Medium WcfSendRequest: RemoteAddress: 'http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'Microsoft.Office.Excel.Server.CalculationServer.Proxy.IExcelServiceSoap' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:2ed186f1-5333-44bb-9866-bf26e43e1f67' 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:2ed186f1-5333-44bb-9866-bf26e43e1f67' 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium ECS RequestId=4466 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services eca6 Medium ExcelService.LogRequest: starting request of type GetRange. Caller ip=fe80::ad54:68e5:345b:52d7%12 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium User=0#.w|ewbc\ksurapaneni 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Document=http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services 7up6 Medium Session.HandleTrimmedWorkbookReloading: userOperation GetRangeOperation doesn't require Baseworkbook To be untrimmed. 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x1B14 SharePoint Server Logging Correlation Data xmnv Medium Result=Success 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services eci4 Medium ExcelService.PostProcessRequest: finished request of type GetRange 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=12.6300270006383 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:e47ec6e9-639d-4d12-9848-051ee03ce67f' 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services ecc3 Medium ExcelServiceBase.EndProcessOperation: Called. UserOperation was finished synchronously: True 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services d64g Medium UserOperation.Dispose: Disposing Microsoft.Office.Excel.Server.CalculationServer.Operations.GetRangeOperation, WebMethod: GetRange. 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.22 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=0.324971469837647 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.22 w3wp.exe (0x207C) 0x328C Excel Services Application Web Front End abvg Medium ServerSession.ExecuteWebMethodCore: request of type GetRange succeeded, from server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, new state id=8, health score=0, error delta=0 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.22 w3wp.exe (0x207C) 0x328C SharePoint Server Logging Correlation Data xmnv Medium Result=Success 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.23 w3wp.exe (0x1FEC) 0x2B14 SharePoint Server Logging Correlation Data xmnv Medium Result=Success 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.23 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services eci4 Medium ExcelService.PostProcessRequest: finished request of type GetRange 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.23 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=14.2543954608756 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.23 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetRange' MessageId: 'urn:uuid:2ed186f1-5333-44bb-9866-bf26e43e1f67' 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.23 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.23 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services ecc3 Medium ExcelServiceBase.EndProcessOperation: Called. UserOperation was finished synchronously: True 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:26.24 w3wp.exe (0x0864) 0x1368 Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Memory Manager: CurrentSize=475635712. 53fed7f1-fd48-7254-0000-000050f7b00c 02/06/2013 15:19:30.23 w3wp.exe (0x1FEC) 0x2B14 Excel Services Application Excel Calculation Services d64g Medium UserOperation.Dispose: Disposing Microsoft.Office.Excel.Server.CalculationServer.Operations.GetRangeOperation, WebMethod: GetRange. 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.23 w3wp.exe (0x1FEC) 0x2B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=0.282019083430995 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.23 w3wp.exe (0x207C) 0x2254 Excel Services Application Web Front End abvg Medium ServerSession.ExecuteWebMethodCore: request of type GetRange succeeded, from server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, new state id=8, health score=0, error delta=0 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.23 w3wp.exe (0x207C) 0x2254 SharePoint Server Logging Correlation Data xmnv Medium Result=Success 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:30.23 w3wp.exe (0x207C) 0x328C Excel Services Application Browser 147u Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler: complete processing 'GetRangeContent' web method call 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:27.05 OWSTIMER.EXE (0x22C4) 0x1B94 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Timer Job Health Statistics Updating). Execution Time=67.1818624992841 03e08421-ca03-4e83-928b-04853283f0ff 02/06/2013 15:19:31.25 w3wp.exe (0x0864) 0x1368 Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Memory Manager: CurrentSize=475930624. 53fed7f1-fd48-7254-0000-000050f7b00c 02/06/2013 15:19:30.24* w3wp.exe (0x207C) 0x328C SharePoint Foundation Monitoring b4ly Medium ...%7D%2C%22ClusterId%22%3Anull%7D&ewaControlId=%22ctl00_PlaceHolderMain_m_excelWebRenderer_ewaCtl_m_ewa%22¤tObject=%22Sheet4%22&isNamedItem=false&row=28&column=0&rowCount=28&columnCount=30&blockX=0&blockY=1&revision=8)). Execution Time=48.8078792136989 718fc4cd-d8da-47e9-a765-004ae279a832 02/06/2013 15:19:30.25 w3wp.exe (0x207C) 0x2254 Excel Services Application Browser 147u Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler: complete processing 'GetRangeContent' web method call 921cdb88-343d-4285-83e4-cf060f0261c4 02/06/2013 15:19:31.45 w3wp.exe (0x207C) 0x328C Excel Services Application Browser 147s Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler: started processing 'ApplySlicerSelection' web method call ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.45 w3wp.exe (0x207C) 0x328C SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.45 w3wp.exe (0x207C) 0x328C SharePoint Server Logging Correlation Data xmnv Medium User=EWBC\KSURAPANENI ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.45 w3wp.exe (0x207C) 0x328C SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.45 w3wp.exe (0x207C) 0x328C Excel Services Application Web Front End abvf Medium ServerSession.ExecuteWebMethodCore: sending request of type ApplySlicerSelection, to server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, state id=-1, health score=0, error delta=0 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.45 w3wp.exe (0x207C) 0x328C Excel Services Application Excel Calculation Services d51n Medium MossHost.GetEndpointAddress: Server endpoint Uri: http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx. ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.45 w3wp.exe (0x207C) 0x328C SharePoint Foundation Topology e5mc Medium WcfSendRequest: RemoteAddress: 'http://stvbrdg101w:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'Microsoft.Office.Excel.Server.CalculationServer.Proxy.IExcelServiceSoap' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelection' MessageId: 'urn:uuid:a479f83d-1b81-414c-87b0-a059b073664c' ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.46 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelection' MessageId: 'urn:uuid:a479f83d-1b81-414c-87b0-a059b073664c' ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.46 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.46 w3wp.exe (0x1FEC) 0x1B14 SharePoint Server Logging Correlation Data xmnv Medium ECS RequestId=4467 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.46 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services eca6 Medium ExcelService.LogRequest: starting request of type ApplySlicerSelection. Caller ip=fe80::ad54:68e5:345b:52d7%12 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.46 w3wp.exe (0x1FEC) 0x1B14 SharePoint Server Logging Correlation Data xmnv Medium User=0#.w|ewbc\ksurapaneni ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.46 w3wp.exe (0x1FEC) 0x1B14 SharePoint Server Logging Correlation Data xmnv Medium Session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.46 w3wp.exe (0x1FEC) 0x1B14 SharePoint Server Logging Correlation Data xmnv Medium Document=http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.46 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services bccc Medium Session.HandleTrimmedWorkbookReloading: userOperation ApplySlicerSelectionOperation requires BaseWorkbook: "http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx" [0x409] [Wednesday, 06 February 2013 23:02:12] [BaseWB ID: 1] to be untrimmed if it is currently trimmed. The workbook is currently NOT trimmed. ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.46 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services f1va Medium CWorkbookWrapper::CWorkbookWrapper: Created with ID=9 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.46 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services eq3r Medium ConnectionRequest.ConnectionRequest: New connection request. SessionId=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, WorkbookVersion=ConnectionInfo.WorkbookVersion: Uri=http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx, Version=Wednesday, 06 February 2013 23:02:12 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services aysl Medium Succeeded to initialize a chart. ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services 8xk9 Medium ExternalSource.ExecuteOperation: We exhausted all available connection information. Exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException: Exception of type 'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException' was thrown. at Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request request, String externalSourceName, Int32 externalSourceIndex, Boolean& shouldReportFailure) at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request request, ExternalSourceStateInfo externalSourceStateInfo, ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index, ConnectionInfoManager connectionInfoManager, ExternalDataScenario scenario, DataOperation dataOpe... ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47* w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services 8xk9 Medium ...ration, Boolean verifyPreOperationConnection), Data Connection Name: PowerPivot Data, SessionId: 1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, UserId: 0#.w|ewbc\ksurapaneni ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 SharePoint Server Logging Correlation Data xmnv Medium Result=Success ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services f1ve Medium CWorkbookWrapper::FinalRelease: Heap is still referenced! refCount=199, ID=9 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services f1vb Medium CWorkbookWrapper::~CWorkbookWrapper: Destroying. ID=9 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services eci4 Medium ExcelService.PostProcessRequest: finished request of type ApplySlicerSelection ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=13.3268334383281 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://stvbrdg101w.ewbc.net:32843/458235b064be486497756d61ec860a8d/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelection' MessageId: 'urn:uuid:a479f83d-1b81-414c-87b0-a059b073664c' ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services ecc3 Medium ExcelServiceBase.EndProcessOperation: Called. UserOperation was finished synchronously: True ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services d64g Medium UserOperation.Dispose: Disposing Microsoft.Office.Excel.Server.CalculationServer.Operations.ApplySlicerSelectionOperation, WebMethod: ApplySlicerSelection. ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=0.281460353201315 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x207C) 0x328C Excel Services Application Web Front End abvg Medium ServerSession.ExecuteWebMethodCore: request of type ApplySlicerSelection succeeded, from server=http://STVBRDG101W:32843/458235b064be486497756d61ec860a8d/ExcelService*.asmx, session=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, new state id=9, health score=0, error delta=0 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x207C) 0x328C SharePoint Server Logging Correlation Data xmnv Medium Result=Success ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x207C) 0x328C Excel Services Application Browser 147u Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler: complete processing 'ApplySlicerSelection' web method call ed830fc3-92a2-4ce8-b4de-90a42596d3f7
- Reply
- Quote

Wednesday, February 06, 2013 11:58 PM

I am using Data connection file name PowerPivot Data.odc saved in dataconnection library on same site. I guess something wrong with data connection file.

please find below details in data connection file.

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/x-ms-odc; charset=utf-8">
<meta name=ProgId content=ODC.Cube>
<meta name=SourceType content=OLEDB>
<title>PowerPivot Data</title>
<!--[if gte mso 9]><xml>
 <o:CustomDocumentProperties>
  <o:ContentType dt:dt="string">Office Data Connection File</o:ContentType>
  <o:Comments dt:dt="string">This connection is used by Excel for communication between the workbook and embedded PowerPivot data, and should not be manually edited or deleted.</o:Comments>
 </o:CustomDocumentProperties>
</xml><![endif]--><xml id=docprops><o:DocumentProperties
  xmlns:o="urn:schemas-microsoft-com:office:office"
  xmlns="http://www.w3.org/TR/REC-html40">
  <o:Description>This connection is used by Excel for communication between the workbook and embedded PowerPivot data, and should not be manually edited or deleted.</o:Description>
  <o:Name>PowerPivot Data</o:Name>
 </o:DocumentProperties>
</xml><xml id=msodc><odc:OfficeDataConnection
  xmlns:odc="urn:schemas-microsoft-com:office:odc"
  xmlns="http://www.w3.org/TR/REC-html40">
  <odc:Connection odc:Type="OLEDB">
   <odc:ConnectionString>Provider=MSOLAP.4;Persist Security Info=True;Initial Catalog=Microsoft_SQLServer_AnalysisServices;Data Source=$Embedded$;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Optimize Response=3;Cell Error Mode=TextValue</odc:ConnectionString>
   <odc:CommandType>Cube</odc:CommandType>
   <odc:CommandText>Sandbox</odc:CommandText>
   <odc:SSOApplicationID>PowerPivotUnattendedAccount</odc:SSOApplicationID>
   <odc:CredentialsMethod>Stored</odc:CredentialsMethod>
  </odc:Connection>
 </odc:OfficeDataConnection>
</xml>
<style>
<!--
    .ODCDataSource
    {
    behavior: url(dataconn.htc);
    }
-->
</style>

data connection file.

Thursday, February 07, 2013 12:35 AM

0
Hi,

Maybe but lets look at a coulple of other issues

PowerPivot for SharePoint will impersonate a SharePoint user in the following cases:
- Queries to PivotTables or PivotCharts that have data connections to a PowerPivot database, where a PowerPivot service application establishes connections on behalf of a user to a specific PowerPivot shared service instance that processes the data.
- Loading PowerPivot data from cache or a library if the data is not otherwise available. If a data connection request is made for PowerPivot data that is not already loaded in the system, the Analysis Services service instance will use the identity of the SharePoint user to retrieve the data source from a content library and load it into memory.
- Data refresh operations that save an updated copy of the data source to the workbook in a content library. In this case, an actual log on operation is performed using the user name and password that is retrieved from a target application in Secure Store Service. Credentials can be the PowerPivot unattended data refresh account, or credentials that were stored with the data refresh schedule when it was created.
- This is the important first issue: Are you storing the ODC is a Trusted Data Connection Library by default there are not any Trusted Data Connection Library defined in Central Administration and they have to be added. But all libraries are trusted file locations due to the single entry http:// in the Trusted File location
- There are two other issues the Excel Services Application authentication, communication and web service settings. File Access Method: Impersonation or Process Account, which one are you using? and is its process does it have access to the data. The second issue is your Unattended Service account / Application ID for external Data. Does this application ID exist in the Secure Store and does the account it was created with have access to the External data
I have bolded the key connection information below

Excel Services Application Excel Calculation Services eq3r Medium ConnectionRequest.ConnectionRequest: New connection request. SessionId=1.V21.5N2pufwVRUZwlIqt0uxW290.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.fa97da1c-4667-4583-9808-64a710c360d71.N, WorkbookVersion=ConnectionInfo.WorkbookVersion: Uri=http://stg.bridgenet.ewbc.net/departments/PowerPivot/Teller.xlsx, Version=Wednesday, 06 February 2013 23:02:12 ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services aysl Medium Succeeded to initialize a chart. ed830fc3-92a2-4ce8-b4de-90a42596d3f7 02/06/2013 15:19:31.47 w3wp.exe (0x1FEC) 0x1B14 Excel Services Application Excel Calculation Services 8xk9 Medium ExternalSource.ExecuteOperation: We exhausted all available connection information. Exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException: Exception of type 'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException' was thrown. at Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request request, String externalSourceName, Int32 externalSourceIndex, Boolean& shouldReportFailure) at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request request, ExternalSourceStateInfo externalSourceStateInfo, ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index, ConnectionInfoManager connectionInfoManager, ExternalDataScenario scenario, DataOperation dataOpe... ed830fc3-92a2-4ce8-b4de-90a42596d3f7

Please let us know what you find....

-Ivan

Ivan Sanders My LinkedIn , My Blog, @iasanders, BI in SP2013, SP2013 Content Packs.
- Reply
- Quote
Thursday, February 07, 2013 10:35 PM

0

Thanks for your response. Answers for your questions This is the important first issue: Are you storing the ODC is a Trusted Data Connection Library by default there are not any Trusted Data Connection Library defined in Central Administration and they have to be added. But all libraries are trusted file locations due to the single entry http:// in the Trusted File location YES I ADDED MY DATA CONNECTION LIBRARY IN TRUSTED DATA CONNECTION. There are two other issues the Excel Services Application authentication, communication and web service settings. File Access Method: Impersonation or Process Account, which one are you using? and is its process does it have access to the data. The second issue is your Unattended Service account / Application ID for external Data. Does this application ID exist in the Secure Store and does the account it was created with have access to the External data I AM USING MY FARM ADMIN ACCOUNT IN SECURE STORE AND FARM ACCOUNT HAS SYSADMIN IN SQL 2008 R2 DATA BASE. my observations: 1. When i create pivot chart in excel 2010 power pivot, i am getting data from SQL 2008 R2 using my own windows Account(Ksurapaneni) locally in my laptop. Once created power pivot chart then i am able to filter my chart locally on PowerPivot Excel 2010 in my laptop. Problem is once imported pivot chart to SharePoint then if i try to apply any filter then i am getting above error. Please find Sky drive link to show how i created Power Pivot chart. https://skydrive.live.com/?cid=6b2d2a2926f61180&id=6B2D2A2926F61180%2130746&sff=1 I am exporting my data connection to data connection library. Please help to resolve this issue. Thanks Kiran
- Reply
- Quote

Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh: Power Pivot Data

All Replies

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support by product

Other support links

Not an IT pro?