Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
ms project 2010 - Excel services - unable to process request

已答复 ms project 2010 - Excel services - unable to process request

  • Tuesday, 22 June 2010 3:31 PM
     
     
    Sign In to Vote
    0

    When I try to run any of the Excel business intelligence reports, i get the following message:

     

    Excel

    Unable to process request

    Wait a few minutes and try performing this operation again.

    ---------

    Any ideas?

    Thanks!

     

All Replies

  • Tuesday, 22 June 2010 3:40 PM
    Owner
     
     
    Sign In to Vote
    0
    Check the ULS for additional clues on what the issue is
    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
     
  • Tuesday, 22 June 2010 4:36 PM
     
     
    Sign In to Vote
    0
    Thanks - sorry for the noob question, but how do I get to the ULS?
     
  • Tuesday, 22 June 2010 5:53 PM
    Owner
     
     
    Sign In to Vote
    0
    By default: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS, I then use this tool view the logs: http://blogs.msdn.com/b/chrisfie/archive/2009/10/30/sharepoint-and-project-server-uls-viewer-tool-released.aspx
    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
     
  • Tuesday, 22 June 2010 6:03 PM
     
     
    Sign In to Vote
    0

    ok, thx - I am seeing quite a few errors for excel services, for example:

     

    ExcelService.PostProcessRequest: Excel Server Exception: System.TypeInitializationException: The type initializer for 'Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp' threw an exception. ---> System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)     at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)     at Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag(UInt32 tagID, ULSCatBase categoryID, String output, Boolean fRethrowException, TryBlock tryBlock, CatchBlock catchBlock, FinallyBlock finallyBlock)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp..ctor()     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp..cctor()     --- End of inner exception stack trace ---     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.SafeSetContext()     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.BeginProcessOperation(CommandParameter parameter, WebMethodBehaviorAttribute webMethodBehavior, WebMethodType webMethodType, AsyncCallback callback, Object state, UserOperation operation)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.BeginGetHealthScore(AsyncCallback callback, Object asyncState)     at AsyncInvokeBeginBeginGetHealthScore(Object , Object[] , AsyncCallback , Object )     at System.ServiceModel.Dispatcher.AsyncMethodInvoker.InvokeBegin(Object instance, Object[] inputs, AsyncCallback callback, Object state) System.TypeInitializationException: The type initializer for 'Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp' threw an exception. ---> System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)     at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)     at Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag(UInt32 tagID, ULSCatBase categoryID, String output, Boolean fRethrowException, TryBlock tryBlock, CatchBlock catchBlock, FinallyBlock finallyBlock)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp..ctor()     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp..cctor()     --- End of inner exception stack trace ---     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.SafeSetContext()     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.BeginProcessOperation(CommandParameter parameter, WebMethodBehaviorAttribute webMethodBehavior, WebMethodType webMethodType, AsyncCallback callback, Object state, UserOperation operation)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.BeginGetHealthScore(AsyncCallback callback, Object asyncState)     at AsyncInvokeBeginBeginGetHealthScore(Object , Object[] , AsyncCallback , Object )     at System.ServiceModel.Dispatcher.AsyncMethodInvoker.InvokeBegin(Object instance, Object[] inputs, AsyncCallback callback, Object state)

     
  • Wednesday, 23 June 2010 8:50 AM
    Moderator
     
     
    Sign In to Vote
    0

    The type initializer for 'Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp' threw an exception. ---> System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)    

    -Are you able to stop / start Excel application service?

      Central admin -> Application management -> Manage Services on server

    -If Dev server, Can you delete the existing Excel service application and try to create new one?

      Central admin -> Application management -> Manage Services applications

    -Otherwise use configuration wizard to configure the excel service once again with appropriate credentials.

    Thanks Sriram E - MSFT Enterprise Project Management
     
  • Wednesday, 23 June 2010 4:09 PM
     
     
    Sign In to Vote
    0

    Thanks! I rebooted the server and got past the previosu error. I am now getting this message:

     

    The Data Connection File http://project2010/pwa/ProjectBICenter/Data%20Connections%20for%20PerformancePoint/English%20(United%20States)/Project%20Server%20-%20Issue%20Data.odc used in the workbook is not in a trusted location. The following connections failed to refresh:

    Project Server - Issue Data

    I looked at the settings in central admin --> excel services application --> trusted file locations

    and everything look normal and setup correctly per:
    http://technet.microsoft.com/en-us/library/cc262899(office.12).aspx

    Not sure what is wrong...

     

    Thanks,

     

     
  • Wednesday, 23 June 2010 4:13 PM
    Owner
     
     Answered
    Sign In to Vote
    0
    That's because you need to setup trusted file locations, please follow the step by step procedure documented here:  Configure reporting for Project Server 2010 http://technet.microsoft.com/en-us/library/ee662106.aspx
    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
     
  • Wednesday, 23 June 2010 6:51 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Manage service applications
    Excel Service applications
    Trusted data connection libraries
    Add Trusted Data connection Library

    http://Project2010/PWA/ProjectBICenter/Data%20Connections%20for%20PerformancePoint/English%20(United%20States)/

    Thanks Sriram E - MSFT Enterprise Project Management
     
  • Thursday, 29 March 2012 4:04 PM
     
     
    Sign In to Vote
    0

    Hi I had the same error, in the log it said "The remote server returned an error: (403) Forbidden".

    Solution:

    In C:\Windows\System32\inetsrv\config\applicationHost.config file, look for the <location path="SharePint Web Services" section and make sure it says <handlers accessPolicy="Read, Execute, Script">. This can also be in the web.config of the root, in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\Root.

    Cheers

    Maurice