none
Excel Services - Locale change causes Exception RRS feed

  • Question

  • I am running SharePoint 2013 Enterprise and reside in the UK where we use it for our intranet.

    I have created an Excel Services service application and then a web application and a site collection beneath it with a BI site.

    When I load up the Excel Services Sample Workbook and click on the slicers everything works fine. However, when I change the Regional Settings of the BI site from English(United States) to English(United Kingdom) and repeat the process I get the error: "We don't know what happened, but something went wrong"

    This error also occurs when I load Excel spread sheets containing PowerPivot slicers.

    Checking the ULS log there are a number of messages for the correlation ID, the most significant is this one:

    ExcelService.PostProcessRequest: The server encountered a very serious error and will continue to function. Please log this as a bug. Exception was: System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.   

    at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.PostProcessRequest(EcsCommandResult result, Exception ex) System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.   

    at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.PostProcessRequest(EcsCommandResult result, Exception ex) StackTrace:

    at Microsoft.Office.Server.Native.dll: (sig=1f86b0bf-2440-4b16-9099-860a571153c2|2|microsoft.office.server.native.pdb, offset=131CE)

    at Microsoft.Office.Server.Native.dll: (offset=21C85)

    If I then change the Regional Settings of the BI site back to English(United States) the problem goes away, although obviously currency and dates in the reports are US and not UK.

    I have found a couple of articles that refer to missing file directories for the 2057 locale id but they haven't been any help (they refer to a different problem but I thought it might be the same principle) - 2057 is, I believe, the locale id for United Kingdom.

    Does anyone have a clue how to address this issue?

    Friday, December 6, 2013 10:32 AM

Answers

  • The solution, thanks to Microsoft Support, is as follows:

    Install the August 2013 Cumulative Updates  for SharePoint 2013.
    All updates for SharePoint 2013 require March 2013 PU for SharePoint 2013 to be installed first.

    March PU:

    * KB 2768000 - SharePoint Foundation 2013

    * KB 2767999 - SharePoint Server 2013

    August 2013 Cumulative Updates

    * KB 2817517 - SharePoint Foundation 2013 August 2013 CU

    * KB 2817616 - SharePoint Server 2013 August 2013 CU

    This means you need to download and install 4 updates( 2 for March and 2 for August) the right order to install is:

    1. March Foundation CU – installation
    2. Run PS Config Wizard

    3. March Server CU installation
    4. Run PS Config Wizard

    5. August 2013 CU Foundation Installation
    6. Run PS Config Wizard

    7. August 2013 CU Server Installation
    8. Run PS Config Wizard


    JE Mason

    Monday, January 20, 2014 2:09 PM

All replies

  • did you create the 2057 folder with required files?

    could you please share complete trace of the ULS logs?


    Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog

    Saturday, December 7, 2013 7:05 AM
    Moderator
  • Hi Waqas

    thank you for replying.

    Basically, I did a search on 1033 and wherever I found a directory I copied it and renamed the copy 2057.
    The places where I copied 1033 directories and files to 2057 are:
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\HCCab
    C:\Program Files (x86)\Microsoft Office\Office15
    C:\Program Files\Common Files\Microsoft Shared\OFFICE15
    C:\Program Files (x86)\Microsoft.NET\ADOMD.NET\90\Resources
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\INC
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\LAYOUTS
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\LAYOUTS\INC
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\LAYOUTS\IPFS.x64
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\LAYOUTS\IPFS.x86
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\FEATURES\BICenterSampleData
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\FEATURES\BICenterSampleData
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\ppsma
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\LAYOUTS\ppsma
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\FEATURES\EawfWeb\Templates
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\FEATURES\EawfWeb\Templates
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\BIN\2057
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\LAYOUTS\ddm
    C:\Program Files\Common Files\Microsoft Shared\DW
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\Help
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE
    C:\Windows\SysWOW64
    C:\Windows\System32
    C:\Windows\Microsoft.NET\Framework\v4.0.30319
    C:\Windows\Microsoft.NET\Framework64\v4.0.30319
    C:\Program Files\Microsoft Office\Office15
    C:\Program Files\Microsoft Office\Templates
    C:\Program Files (x86)\Common Files\microsoft shared\OFFICE15
    C:\Program Files (x86)\Common Files\microsoft shared\Portal
    C:\Windows\Microsoft.NET\Framework\v3.5
    C:\Windows\Microsoft.NET\Framework64\v3.5
    C:\Windows\Microsoft.NET\Framework\v2.0.50727
    C:\Windows\Microsoft.NET\Framework64\v2.0.50727

    At this point I lost the will to live and stopped :-(
    I ignored any which referred to SQL Server or Visual Studio.

    Here is the log for the correlation id of the error:

    12/09/2013   09:16:02.54 w3wp.exe (0x21D0) 0x1F78 SharePoint Foundation Logging   Correlation Data xmnv Medium Name=Request (POST:http://[our   intranet]:80/sites/BI/_vti_bin/EwaInternalWebService.json/ApplySlicerSelection) 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.54 w3wp.exe   (0x21D0) 0x1F78 SharePoint Foundation Authentication   Authorization agb9s Medium Non-OAuth request. IsAuthenticated=True   UserIdentityName=0#.w|[domain\username] "   ClaimsCount=51 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.55 w3wp.exe   (0x21D0) 0x1F78 Excel Services   Application Browser ajcm6 Medium ApplySlicerSelection " before   delegate 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.55 w3wp.exe   (0x21D0) 0x1F78 SharePoint Server Logging Correlation   Data xmnv Medium Name=EWAWS:   ApplySlicerSelection 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.55 w3wp.exe   (0x21D0) 0x1F78 SharePoint Server Logging Correlation   Data xmnv Medium Session=36.cba43e7d-bbdf-484a-9675-92efb59d56881.A90.1.V22.84R2u+G59lx5RbXGKx33K314.5.en-US5.en-GB36.a80910e1-ccb0-48ce-9f98-0ba87db3e1091.A1.N 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.55 w3wp.exe   (0x21D0) 0x1F78 Excel Services   Application Browser 147s Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler:   started processing 'ApplySlicerSelection' web method   call 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.55 w3wp.exe   (0x21D0) 0x1F78 SharePoint Server Logging Correlation   Data xmnv Medium Name=ProxyMethod:   ApplySlicerSelection 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.55 w3wp.exe   (0x21D0) 0x1F78 SharePoint Server Logging Correlation   Data xmnv Medium Session=1.V22.84R2u+G59lx5RbXGKx33K314.5.en-US5.en-GB36.a80910e1-ccb0-48ce-9f98-0ba87db3e1091.A1.N 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.55 w3wp.exe   (0x21D0) 0x1F78 SharePoint Foundation Logging Correlation   Data xmnv Medium Site=/sites/BI 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.56 w3wp.exe   (0x21D0) 0x1F78 Excel Services Application Web Front   End abvf Medium ServerSession.ExecuteWebMethodCore: sending request of type   ApplySlicerSelection to server=http://[sharepoint   server]:32843/87d17166a7ea44f4b80f213be6c22112/ExcelService*.asmx   session=1.V22.84R2u+G59lx5RbXGKx33K314.5.en-US5.en-GB36.a80910e1-ccb0-48ce-9f98-0ba87db3e1091.A1.N   state id=-1 health score=0 " error   delta=0 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.56 w3wp.exe   (0x21D0) 0x1F78 Excel Services Application Excel Calculation   Services d51n Medium MossHost.GetEndpointAddress: Server endpoint Uri:   http://[sharepoint   server]:32843/87d17166a7ea44f4b80f213be6c22112/ExcelService.asmx. 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.56 w3wp.exe   (0x21D0) 0x1F78 SharePoint Foundation Topology e5mc Medium WcfSendRequest:   RemoteAddress: 'http://[sharepoint   server]:32843/87d17166a7ea44f4b80f213be6c22112/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:0bee8385-9f36-4c69-a347-62ad33889e9a' 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.57 w3wp.exe   (0x19BC) 0x2B00 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest:   LocalAddress: 'http://[sharepoint   server].:32843/87d17166a7ea44f4b80f213be6c22112/ExcelService.asmx' Channel:   'System.ServiceModel.Channels.ServiceChannel' Action:   'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelection'   MessageId:   'urn:uuid:0bee8385-9f36-4c69-a347-62ad33889e9a' 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.57 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Logging Correlation Data xmnv Medium ECS   RequestId=9399 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.57 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Logging Correlation   Data xmnv Medium Name=WebMethod:   ApplySlicerSelection 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.57 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services eca6 Medium ExcelService.LogRequest: starting request of type   ApplySlicerSelection. Request received from [sharepoint   server] 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.57 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Logging Correlation   Data xmnv Medium Session=1.V22.84R2u+G59lx5RbXGKx33K314.5.en-US5.en-GB36.a80910e1-ccb0-48ce-9f98-0ba87db3e1091.A1.N 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.57 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Logging Correlation   Data xmnv Medium User=0#.w|[domain\username] 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.57 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services ajo52 Medium BaseIdentityResolver.SetUserPrincipalForUserRequest:   UserPrincipal 0#.w|[domain\username] successfully set on the   thread 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.57 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Logging Correlation   Data xmnv Medium Document=http://[our   intranet]/sites/BI/Reports/Excel%20Services%20Sample%20Workbook.xlsx 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.57 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services abnr9 Medium ExcelServiceBase.BeginProcessOperation:   Microsoft.Office.Excel.Server.CalculationServer.Operations.ApplySlicerSelectionOperation "   WebMethod: ApplySlicerSelection is queued on   SessionOperationQueue 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.57 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services f1va Medium CWorkbookWrapper::CWorkbookWrapper: Created with   ID=30 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.58 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services eq3r Medium ConnectionRequest.ConnectionRequest: New connection   request.   SessionId=1.V22.84R2u+G59lx5RbXGKx33K314.5.en-US5.en-GB36.a80910e1-ccb0-48ce-9f98-0ba87db3e1091.A1.N   WorkbookVersion=ConnectionInfo.WorkbookVersion: Uri=http://[our   intranet]/sites/BI/Reports/Excel Services Sample Workbook.xlsx   Version=Friday " 29 November 2013   09:03:46 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.61 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services 2jix Assert ShipAssert location: (0)    condition:   StackTrace:  at Microsoft.Office.Server.Native.dll:   (sig=c3cf111a-d6fc-4ec5-ba1c-c9b8ebb47e41|2|microsoft.office.server.native.pdb   offset=1F074) at xlsrv.dll:   (sig=1802e739-f5fa-4ac5-903a-67a70587ed6e|2|xlsrv.pdb offset=E69D55) at   xlsrv.dll: (offset=E6947A) at xlsrv.dll: (offset=5B79E5) at xlsrv.dll:   (offset=DF9826) at xlsrv.dll: (offset=DF9D40) at xlsrv.dll: (offset=DFC505)   at xlsrv.dll: (offset=DFF4FC) at xlsrv.dll: (offset=E055F6) at xlsrv.dll:   (offset=DC4830) at xlsrv.dll: (offset=DC9708) at xlsrv.dll: (offset=E055F6)   at xlsrv.dll: (offset=F72426) at MSVCR100.dll:   (sig=25656ec1-1750-43b6-96d8-93aea9e1984b|1|msvcr100.amd64.pdb offset=68A40)   at MSVCR100.dll: (offset=5FDC5) at MSVCR100.dll: (offset=5F5D2) at   MSVCR100.dll: (offset=61366) at MSVCR100.dll: (offset=5F66B) at ntdll.dll:   (sig=9d04eb0a-a387-494f-bd81-ed062072b99c|2|ntdll.pdb offset=29DAD) at   ntdll.dll: (offset=18A4C) at clr.dll:   (sig=ad25374e-6b2f-4798-b4fd-fdb14e19d79b|2|clr.pdb offset=216CE4) at   clr.dll: (offset=216CA2) at ntdll.dll:   (sig=9d04eb0a-a387-494f-bd81-ed062072b99c|2|ntdll.pdb offset=29D2D) at   ntdll.dll: (offset=191CF) at ntdll.dll: (offset=197C8) at KERNELBASE.dll:   (sig=88d04dc8-e39b-4cbb-9cb1-2366c2ae475f|2|kernelbase.pdb offset=940D) at   MSVCR100.dll: (sig=25656ec1-1750-43b6-96d8-93aea9e1984b|1|msvcr100.amd64.pdb   offset=614F1) at xlsrv.dll:   (sig=1802e739-f5fa-4ac5-903a-67a70587ed6e|2|xlsrv.pdb " offset=A8215E)   at xlsrv.dll: (offset=A81FFF) at xlsrv.dll: (offset=AB2AD7) at xlsrv.dll: (offset=9DF0BB)   at xlsrv.dll: (offset=9DF713) at xlsrv.dll: (offset=9DDDA5) at xlsrv.dll:   (offset=D8A4EF) at xlsrv.dll: (offset=D8A230) at xlsrv.dll: (offset=D6B13C)   at xlsrv.dll: (offset=5AC36E) at xlsrv.dll: (offset=5AC590) at xlsrv.dll:   (offset=5A2DDF) at xlsrv.dll:   (offset=561B24) 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.61 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Unified Logging   Service c91s Monitorable Watson bucket parameters: SharePoint Server 2013   ULSShipAssert12 2jix "   15.0.4481.0 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.61 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Unified Logging Service b6ig Medium Data   collection is not enabled for tag '2jix' in the configuration or   configuration file not available. Not reporting to   Watson 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.63 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services 2jiy Assert ShipAssert location: (0)    condition:   StackTrace:  at Microsoft.Office.Server.Native.dll:   (sig=c3cf111a-d6fc-4ec5-ba1c-c9b8ebb47e41|2|microsoft.office.server.native.pdb   offset=1F074) at xlsrv.dll:   (sig=1802e739-f5fa-4ac5-903a-67a70587ed6e|2|xlsrv.pdb offset=E69D55) at   xlsrv.dll: (offset=E6947A) at xlsrv.dll: (offset=5B79E5) at xlsrv.dll:   (offset=DF9842) at xlsrv.dll: (offset=DF9D40) at xlsrv.dll: (offset=DFC505)   at xlsrv.dll: (offset=DFF4FC) at xlsrv.dll: (offset=E055F6) at xlsrv.dll:   (offset=DC4830) at xlsrv.dll: (offset=DC9708) at xlsrv.dll: (offset=E055F6)   at xlsrv.dll: (offset=F72426) at MSVCR100.dll:   (sig=25656ec1-1750-43b6-96d8-93aea9e1984b|1|msvcr100.amd64.pdb offset=68A40)   at MSVCR100.dll: (offset=5FDC5) at MSVCR100.dll: (offset=5F5D2) at   MSVCR100.dll: (offset=61366) at MSVCR100.dll: (offset=5F66B) at ntdll.dll:   (sig=9d04eb0a-a387-494f-bd81-ed062072b99c|2|ntdll.pdb offset=29DAD) at   ntdll.dll: (offset=18A4C) at clr.dll:   (sig=ad25374e-6b2f-4798-b4fd-fdb14e19d79b|2|clr.pdb offset=216CE4) at   clr.dll: (offset=216CA2) at ntdll.dll:   (sig=9d04eb0a-a387-494f-bd81-ed062072b99c|2|ntdll.pdb offset=29D2D) at   ntdll.dll: (offset=191CF) at ntdll.dll: (offset=197C8) at KERNELBASE.dll:   (sig=88d04dc8-e39b-4cbb-9cb1-2366c2ae475f|2|kernelbase.pdb offset=940D) at   MSVCR100.dll: (sig=25656ec1-1750-43b6-96d8-93aea9e1984b|1|msvcr100.amd64.pdb   offset=614F1) at xlsrv.dll:   (sig=1802e739-f5fa-4ac5-903a-67a70587ed6e|2|xlsrv.pdb " offset=A8215E)   at xlsrv.dll: (offset=A81FFF) at xlsrv.dll: (offset=AB2AD7) at xlsrv.dll: (offset=9DF0BB)   at xlsrv.dll: (offset=9DF713) at xlsrv.dll: (offset=9DDDA5) at xlsrv.dll:   (offset=D8A4EF) at xlsrv.dll: (offset=D8A230) at xlsrv.dll: (offset=D6B13C)   at xlsrv.dll: (offset=5AC36E) at xlsrv.dll: (offset=5AC590) at xlsrv.dll:   (offset=5A2DDF) at xlsrv.dll:   (offset=561B24) 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.63 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Unified Logging   Service c91s Monitorable Watson bucket parameters: SharePoint Server 2013   ULSShipAssert12 2jiy "   15.0.4481.0 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.63 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Unified Logging Service b6ig Medium Data   collection is not enabled for tag '2jiy' in the configuration or   configuration file not available. Not reporting to   Watson 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.63 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services 4n13 High [Forced due to logging gap " Original Level: Verbose]   UserWorkbook.Dispose: {0}:   {1} 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.63 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services f1ve Medium CWorkbookWrapper::FinalRelease: Heap is still   referenced! refCount=123 "   ID=30 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.63 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services f1vb Medium CWorkbookWrapper::~CWorkbookWrapper: Destroying.   ID=30 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.63 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Logging Correlation   Data xmnv Medium Result=System.Runtime.InteropServices.SEHException   (0x80004005): External component has thrown an exception.     at   Microsoft.Office.Excel.Server.CalculationServer.Interop.WorkbookInterop.Clone(WorkbookInterop   source IUserWorkbookExtSrcEvents userWorkbookExtSrcEvents Object   connectionRequest Boolean cloneSheetDataCacheFromSourceWorkbook   IUserWorkbookWebExtensionEvents userWorkbookWebExtensionEvents)     at   Microsoft.Office.Excel.Server.CalculationServer.UserWorkbook.CreatePrivateCopyAndMarkUsed(Request   request " UserKey userKey)     at   Microsoft.Office.Excel.Server.CalculationServer.UserWorkbook.CreatePrivateCopyAndMarkUsed(Request   request)     at   Microsoft.Office.Excel.Server.CalculationServer.SessionWorkbook.PrepareForStateChangingOperation(UserOperation   operation)     at   Microsoft.Of 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.63 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services ech0 Medium ExcelService.PostProcessRequest: web method:   ApplySlicerSelection got exception   System.Runtime.InteropServices.SEHException (0x80004005): External component   has thrown an exception.     at   Microsoft.Office.Excel.Server.CalculationServer.Interop.WorkbookInterop.Clone(WorkbookInterop   source IUserWorkbookExtSrcEvents userWorkbookExtSrcEvents Object connectionRequest   Boolean cloneSheetDataCacheFromSourceWorkbook   IUserWorkbookWebExtensionEvents userWorkbookWebExtensionEvents)     at   Microsoft.Office.Excel.Server.CalculationServer.UserWorkbook.CreatePrivateCopyAndMarkUsed(Request   request " UserKey userKey)     at   Microsoft.Office.Excel.Server.CalculationServer.UserWorkbook.CreatePrivateCopyAndMarkUsed(Request   request)     at Microsoft.Office.Excel.Server.CalculationServer.SessionWorkbook.PrepareForStateChangingOperation(UserOperation   operation)     at   Microsoft.Office.Excel.Server.CalculationServer.SessionWorkbook.PreProcessOperation(UserOperation   userOperation)     at   Microsoft.Office.Excel.Server.CalculationServer.Operations.OperationSite.PrepareAndRunOperation()     at   Microsoft.Office.Excel.Server.CalculationServer.Operations.OperationSite.PrepareComplete(PrepareAsyncArgs   args) 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.64 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services eci1 Exception ExcelService.PostProcessRequest: Excel Server   Exception: System.Runtime.InteropServices.SEHException (0x80004005): External   component has thrown an exception.       at   Microsoft.Office.Excel.Server.CalculationServer.Interop.WorkbookInterop.Clone(WorkbookInterop   source IUserWorkbookExtSrcEvents userWorkbookExtSrcEvents Object   connectionRequest Boolean cloneSheetDataCacheFromSourceWorkbook   IUserWorkbookWebExtensionEvents userWorkbookWebExtensionEvents)     at   Microsoft.Office.Excel.Server.CalculationServer.UserWorkbook.CreatePrivateCopyAndMarkUsed(Request   request UserKey userKey)     at   Microsoft.Office.Excel.Server.CalculationServer.UserWorkbook.CreatePrivateCopyAndMarkUsed(Request   request)     at   Microsoft.Office.Excel.Server.CalculationServer.SessionWorkbook.PrepareForStateChangingOperation(UserOperation   operation)     at   Microsoft.Office.Excel.Server.CalculationServer.SessionWorkbook.PreProcessOperation(UserOperation   userOperation)     at   Microsoft.Office.Excel.Server.CalculationServer.Operations.OperationSite.PrepareAndRunOperation()     at   Microsoft.Office.Excel.Server.CalculationServer.Operations.OperationSite.PrepareComplete(PrepareAsyncArgs   args) System.Runtime.InteropServices.SEHException (0x80004005): External   component has thrown an exception.       at Microsoft.Office.Excel.Server.CalculationServer.Interop.WorkbookInterop.Clone(WorkbookInterop   source IUserWorkbookExtSrcEvents userWorkbookExtSrcEvents Object   connectionRequest Boolean cloneSheetDataCacheFromSourceWorkbook   IUserWorkbookWebExtensionEvents userWorkbookWebExtensionEvents)     at   Microsoft.Office.Excel.Server.CalculationServer.UserWorkbook.CreatePrivateCopyAndMarkUsed(Request   request UserKey userKey)     at   Microsoft.Office.Excel.Server.CalculationServer.UserWorkbook.CreatePrivateCopyAndMarkUsed(Request   request)     at   Microsoft.Office.Excel.Server.CalculationServer.SessionWorkbook.PrepareForStateChangingOperation(UserOperation   operation)     at   Microsoft.Office.Excel.Server.CalculationServer.SessionWorkbook.PreProcessOperation(UserOperation   userOperation)     at   Microsoft.Office.Excel.Server.CalculationServer.Operations.OperationSite.PrepareAndRunOperation()     at   Microsoft.Office.Excel.Server.CalculationServer.Operations.OperationSite.PrepareComplete(PrepareAsyncArgs   args) StackTrace:  at   Microsoft.Office.Server.Native.dll:   (sig=c3cf111a-d6fc-4ec5-ba1c-c9b8ebb47e41|2|microsoft.office.server.native.pdb "   offset=131CE) at Microsoft.Office.Server.Native.dll:   (offset=21BFD) 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.64 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Unified Logging   Service c91s Monitorable Watson bucket parameters: SharePoint Server 2013   ULSException14 " 5f9be61a ""excel services   application""" " 0f001181   ""15.0.4481.0""" " 69f888f4   ""microsoft.office.excel.server.calculationserver.interop""" "   0f001144 ""15.0.4420.0""" " 506725a5   ""sat sep 29 17:45:25 2012""" " 00000431   ""00000431""" " 000000ec   ""000000ec""" " 0edc6e99   ""sehexception""" " 65636931   ""eci1"" 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.64 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Unified Logging Service b6ig Medium Data   collection is not enabled for tag 'eci1' in the configuration or   configuration file not available. Not reporting to   Watson 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.64 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services eci4 Medium ExcelService.PostProcessRequest: finished request of   type ApplySlicerSelection " deferred dispose:   False 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.64 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services eci8 Exception ExcelService.PostProcessRequest: The server   encountered a very serious error and will continue to function. Please log   this as a bug. Exception was: System.Runtime.InteropServices.SEHException   (0x80004005): External component has thrown an exception.     at   Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.PostProcessRequest(EcsCommandResult   result Exception ex) System.Runtime.InteropServices.SEHException   (0x80004005): External component has thrown an exception.     at   Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.PostProcessRequest(EcsCommandResult   result Exception ex) StackTrace:  at   Microsoft.Office.Server.Native.dll:   (sig=c3cf111a-d6fc-4ec5-ba1c-c9b8ebb47e41|2|microsoft.office.server.native.pdb "   offset=131CE) at Microsoft.Office.Server.Native.dll:   (offset=21BFD) 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.64 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Unified Logging   Service c91s Monitorable Watson bucket parameters: SharePoint Server 2013   ULSException14 " 5f9be61a ""excel services   application""" " 0f001181   ""15.0.4481.0""" " e6cb4d65   ""microsoft.office.excel.server.calculationserver""" "   0f001144 ""15.0.4420.0""" " 50672bac   ""sat sep 29 18:11:08 2012""" " 0000080d   ""0000080d""" " 00000956   ""00000956""" " 0edc6e99   ""sehexception""" " 65636938   ""eci8"" 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.64 w3wp.exe   (0x19BC) 0x2B00 SharePoint Server Unified Logging Service b6ig Medium Data   collection is not enabled for tag 'eci8' in the configuration or   configuration file not available. Not reporting to   Watson 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.65 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services eci9 Unexpected ExcelService.PostProcessRequest: Baseworkbook caused   a bad error - will now force it to be stale. Will also make all its sessions   unresponsive. 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.65 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services ai2v1 Warning An unexpected serious error occurred when executing   http://[our intranet]/sites/BI/Reports/Excel Services Sample Workbook.xlsx.   The workbook will be unloaded by the Excel Calculation Services. If this   error continues to occur " an administrator should look at the file and   verify its   contents. 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.65 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services nlcg Medium Session.SetUnresponsive: Called. Session is   1.V22.84R2u+G59lx5RbXGKx33K314.5.en-US5.en-GB36.a80910e1-ccb0-48ce-9f98-0ba87db3e1091.A1.N 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.65 w3wp.exe   (0x19BC) 0x2B00 SharePoint Foundation Monitoring b4ly Medium Leaving   Monitored Scope (ExecuteWcfServerOperation). Execution   Time=73.0391711795773 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.65 w3wp.exe   (0x19BC) 0x2B00 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest:   LocalAddress: 'http://[sharepoint   server].:32843/87d17166a7ea44f4b80f213be6c22112/ExcelService.asmx' Channel:   'System.ServiceModel.Channels.ServiceChannel' Action:   'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelection'   MessageId:   'urn:uuid:0bee8385-9f36-4c69-a347-62ad33889e9a' 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.65 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services ecc3 Medium ExcelServiceBase.EndProcessOperation: Called.   UserOperation was finished synchronously:   True 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.65 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services d64g Medium UserOperation.Dispose: Disposing   Microsoft.Office.Excel.Server.CalculationServer.Operations.ApplySlicerSelectionOperation "   WebMethod: ApplySlicerSelection. 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.65 w3wp.exe   (0x19BC) 0x2B00 Excel Services Application Excel Calculation   Services ecc4 Medium ExcelServiceBase.EndProcessOperation: Found an exception   on the AsyncResult of an operation which has not been departed from.   Exception is Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase+EcsFaultException:   We don't know what happened " but something went wrong. (Fault Detail is   equal to   Microsoft.Office.Excel.Server.ExcelServerMessage). 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.65 w3wp.exe   (0x19BC) 0x2B00 SharePoint Foundation Monitoring b4ly Medium Leaving   Monitored Scope (ExecuteWcfServerOperation). Execution   Time=0.504254032286226 128d5e9c-e6a6-206a-7bed-af387469e7c4
    12/09/2013 09:16:02.78 w3wp.exe   (0x21D0) 0x1F78 Excel Services Application Web Front End 145g High [Forced   due to logging gap Original Level: Verbose]   ServerSession.ExecuteWithSecurityContext: After issuing the request to server   {0} [id: {1}]. ServerRequestCount: {2} AllServersRequestCount: {3}   workerThreads: {4} " completionPortThreads:   {5} 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.78 w3wp.exe   (0x21D0) 0x1F78 Excel Services Application Web Front   End d718 Medium ServerSession.ProcessServerSessionException: An exception   during ExecuteWebMethod has occurred for server: http://[sharepoint   server]:32843/87d17166a7ea44f4b80f213be6c22112/ExcelService*.asmx method:   ApplySlicerSelection ex:   Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSessionException:   We don't know what happened " but something went   wrong.. 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.79 w3wp.exe   (0x21D0) 0x1F78 SharePoint Server Logging Correlation   Data xmnv Medium Result=Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSessionException:   We don't know what happened but something went wrong.     at   Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.ExecuteWebMethodCore(WebMethodType   webMethodType WebMethodBehaviorAttribute webMethodBehavior CommandParameter   parameter CoreWebMethod coreWebMethod)       at   Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.ExecuteWebMethod(WebMethodType   webMethodType WebMethodBehaviorAttribute webMethodBehavior CommandParameter   parameter " CoreWebMethod   coreWebMethod) 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.79 w3wp.exe   (0x21D0) 0x1F78 Excel Services   Application Browser 147t Medium WebServiceHelperMethods.ExecuteWebServiceRequestHandler:   An exception occured   Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSessionException:   We don't know what happened but something went wrong.     at   Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.ExecuteWebMethodCore(WebMethodType   webMethodType WebMethodBehaviorAttribute webMethodBehavior CommandParameter   parameter CoreWebMethod coreWebMethod)       at   Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.ExecuteWebMethod(WebMethodType   webMethodType WebMethodBehaviorAttribute webMethodBehavior CommandParameter   parameter CoreWebMethod coreWebMethod)       at   Microsoft.Office.Excel.WebServices.Internal.EwaInternalWebService.<>c__DisplayClass79.<ApplySlicerSelection>b__78()     at   Microsoft.Office.Excel.WebServices.Internal.WebServiceHelperMethods.ExecuteWebServiceRequestHandler(String   webMethodName WebServiceMethodExecutionDelegate methodDelegate   ExcelServerMessageTranslationDelegate messageDelegate String sessionId   String uiCultureTag String dataCultureTag String timeZone Boolean   safeSetCultures HttpContext context " Boolean   useDefaultCachePolicy) 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.80 w3wp.exe   (0x21D0) 0x1F78 Excel Services   Application Browser aeh12 Monitorable WebServiceHelperMethods.ExecuteWebServiceRequestHandler:   completed processing 'ApplySlicerSelection' web method call with errors.   [MessageId: InternalError " MessageIdHash:   -1100324317] 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.80 w3wp.exe   (0x21D0) 0x1F78 Excel Services   Application Browser ai2sp Medium ApplySlicerSelection " after   delegate 128d5e9c-e6a6-206a-7bed-af387469e7c4"
    12/09/2013 09:16:02.81 w3wp.exe   (0x21D0) 0x1F78 SharePoint Foundation Monitoring b4ly Medium Leaving   Monitored Scope (Request (POST:http://[our   intranet]:80/sites/BI/_vti_bin/EwaInternalWebService.json/ApplySlicerSelection)).   Execution Time=269.90804697245 128d5e9c-e6a6-206a-7bed-af387469e7c4

    Monday, December 9, 2013 11:24 AM
  • Hi JE,

    According to your description, my understanding is that you got an error after you changed the Regional Settings of the BI site.

    For resolving your issue, please recycle the application pool of the problematic web application, then check the result.

    If this issue still exists, please repair SharePoint 2013 under Control Panel, then test it again.

    Here are some similar posts for you to take a look at:
    http://social.technet.microsoft.com/Forums/sharepoint/en-US/8b8a2867-a9e6-4f44-9cde-8e5e2c2f4fad/error-accessing-excel-workbook-in-excel-services?forum=sharepointadminprevious
    http://social.msdn.microsoft.com/Forums/windowsazure/en-US/0fe95be6-68e3-4e0b-a12d-3c6d6abe17f1/external-component-has-thrown-an-exception?forum=windowsazuredevelopment

    I hope this helps.

    Thanks,

    Wendy


    Wendy Li
    TechNet Community Support

    Friday, December 27, 2013 7:49 AM
    Moderator
  • Hi Wendy

    thank you for replying, unfortunately neither of your suggestions made the slightest bit of difference.

    I find it incredible that this is such a fundamental problem.

     


    JE Mason

    Tuesday, January 7, 2014 9:16 AM
  • did you try to create  new workbook and check if that works?

    also try to start and stop the ECS services? If still not then reboot the ECS servers.


    Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog

    Tuesday, January 7, 2014 6:51 PM
    Moderator
  • The solution, thanks to Microsoft Support, is as follows:

    Install the August 2013 Cumulative Updates  for SharePoint 2013.
    All updates for SharePoint 2013 require March 2013 PU for SharePoint 2013 to be installed first.

    March PU:

    * KB 2768000 - SharePoint Foundation 2013

    * KB 2767999 - SharePoint Server 2013

    August 2013 Cumulative Updates

    * KB 2817517 - SharePoint Foundation 2013 August 2013 CU

    * KB 2817616 - SharePoint Server 2013 August 2013 CU

    This means you need to download and install 4 updates( 2 for March and 2 for August) the right order to install is:

    1. March Foundation CU – installation
    2. Run PS Config Wizard

    3. March Server CU installation
    4. Run PS Config Wizard

    5. August 2013 CU Foundation Installation
    6. Run PS Config Wizard

    7. August 2013 CU Server Installation
    8. Run PS Config Wizard


    JE Mason

    Monday, January 20, 2014 2:09 PM