Excel Web Access Sharepoint 2010 An Error Has Occurred
Contents |
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Excel Web App error
Excel Web Access Web Part Sharepoint 2010
“An error has occurred. Please try again.” SharePoint > SharePoint 2010 excel web access web part sharepoint 2010 download - Setup, Upgrade, Administration and Operations Question 0 Sign in to vote Error: Excel Web App excel web access web part sharepoint 2010 unable to process the request error “An error has occurred. Please try again.” Analysis: 1) It is not user-specific, as its happening to multiple users for same file. 2) It is
Sharepoint 2010 Excel Web Part An Error Has Occurred
not File specific, as the file which is giving error, works fine on another environment. 3) It is not Environment specific, as other files in same environment are opening properly. 4) I had made sure that Excel Calculation Services and Microsoft SharePoint Foundation Web Application are working (started state). 5) I had made sure
An Error Has Occurred Sharepoint 2010 Excel
that Excel service application is working (started state). 6) I had made sure that Excel service application service account has permission on the site. 7) I had made sure that Excel Service application’s trusted file location has added the site with excel files. 8) I had Check the SecurityTokenServiceApplicationPool has started. 9) I had done Recycle the application pool and reset IIS with no force. Please suggest any solution other than mentioned above workarounds to resolve this issue. Thanks! Keshav Edited by KESHAV RANJAN DEY Friday, December 11, 2015 9:00 AM Friday, December 11, 2015 4:18 AM Reply | Quote Answers 0 Sign in to vote Error: ” An Error has occurred. Please try again. Investigations: The previous night there has been a power outage to the data center and next morning this is not working. When the same file is renamed and saved again it works fine with excel web app so it could be something
thought: "At least the servers are running, so it could be worse on a Monday morning." And it got worse. The Excel WebApps weren't working. With the best error message ever, thanks to Microsoft for clearing up the problem that might occured: An error has occurred. Please try again. Actually. It's not okay. It's one of those error message that could mean anything. Maybe a planet in outer space just exploded and forced Excel WebApps to stop working. So, my first idea was: Maybe the service is missing some rights or something. So I used a little PowerShell https://social.technet.microsoft.com/Forums/office/en-US/63407b2d-bb14-478a-93c8-7e031627af20/excel-web-app-error-an-error-has-occurred-please-try-again?forum=sharepointadminprevious script, but that didn't help. I'm posting it so it may help you. $web = Get-SPWebApplication http://applicationurl/ $web.GrantAccessToProcessIdentity("DomainName\ServiceAccount") So I tried to search for this error, but nothing helped. I checked the App Settings, check if any error occurred. In the end one simple thing did the trick: Restarting the service fixed the problem. But why did this help? Well, we deleted files from the TEMP directory... and http://www.sprocks.io/2012/07/sharepoint-2010-error-has-occurred.html there are all those Excel WebApp Temp files, which are needed to display. These files will get initialized when you restart the service. Problem solved. *Update 7/16/12* In my case I restarted the Excel Web Services. Thanks to Taras Kun for his tip: "I got it fixed simply by restarting Microsoft SharePoint Foundation Web Application service In Central Administration > Application Management > Services on Server." Posted by PKo3 at 12:03 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Excel WebApp, PowerShell, SharePoint, SharePoint 2010, WebApp 8 comments: Taras KuJuly 11, 2012 at 1:32 PMHi,I have the same problem here.Could you please specify what services did you restart?Maybe it will do that trick for me too...Thanks, TarasReplyDeleteTaras KuJuly 13, 2012 at 2:34 AMI got it fixed simply by restarting Microsoft SharePoint Foundation Web Application service In Central Administration > Application Management > Services on Server.ReplyDeleteAnonymousMarch 13, 2013 at 6:06 AMHi, i had the same problem (for some users).I've cleaned the tempory files in Internet Explorer and it solved my problem.ReplyDeleteRepliesPKo3March 26, 2013 at 11:18 PMThat would work, but it's not that great of a solution if you have to do this for a couple of thousand people. :
SharePoint 2010 » SharePoint 2010 Cookbook: SharePoint 2010 Excel Services - An Error Has Occurred SharePoint 2010 Cookbook: SharePoint 2010 Excel Services - An Error Has Occurred SharePoint 2010 offers a wide variety of features that http://community.bamboosolutions.com/blogs/sharepoint-2010/archive/2011/09/15/sharepoint-2010-cookbook-sharepoint-2010-excel-services-an-error-has-occurred.aspx make our work lives easier, butevery now and again, SharePoint can still beless than http://ramesh-learningmoss2007.blogspot.com/2012/03/error-has-occurred-please-try-again.html kind to users. Challenge: When I was trying to open an Excel 2007 spreadsheet once, this error came up unexpectedly: And then: Which was followed by: Hmm. So I started investigating to determinethesource of the problem, gathered all of the solutions I found to be potentially relevant, and was finally able to get my Excel Service up sharepoint 2010 and running. If you are experiencing any of the above errors, hopefully the information below will help you to find the solution to your own problem. Solution: Possible Causes: The SharePoint 2010 Excel Services Application has not started properly. The Security Token Service Application is not started properly. The Excel Service account does not have permissionsfor the SharePoint content database. Resolutions Checklist: Step 1: Go to Central Administration -> Application Management excel web access -> Manage service applications -> Verify that the Excel Services Application and Security Token Service Applicationhave started. Step 2: Go to Central Administration -> System Settings -> Manage services on server -> Verify that Excel Calculation Services has started. Step 3: Go to Central Administration -> Security -> Configure service accounts -> select Service Application Pool - SharePoint Web Services Default if you are using out-of-the-box SharePoint Excel Service; if you have created a new application pool for your Excel Service, select it instead. Note the service account currently beingused. Step 4: Verify that your service accountincludes thedb_owner role in the SharePoint content database of that Web application. You can do this in SQL Management Studio on your SQL Server, or by using the following PowerShell commands to grant permission to your service account: On the SharePoint Server, click Start -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management Shell. Enter these commands: 1: $w = Get-SPWebApplication -Identity http://portal 2: $w.GrantAccessToProcessIdentity("domain\serviceaccount") Step 5: Provision the Excel Services Application by running these PowerShell commands: 1: $excel = Get-SPExcelServiceApplication 2: $excel.Provision() Step 6: Open IIS Manager on the SharePoint Server, and verify that SecurityTokenServiceApplicationPoolhas started. Step 7: Reset IIS Notes: This blog post only applies to SharePoint Server 2010 Enterprise. Th
I found one more error while opening the excel sheet. i.e. Error: An error has occurred. Please try again later And this error will come only once when we open the excel in the first time only, if we try after that we won't get the same error message but SharePoint event viewer Application and ULS will log the error as below every time after opening the excel file. "There was an error in communicating with Excel Calculation Services http://server /ExcelService*.asmx exception: An error has occurred.[Session: User: SHAREPOINT\system]" SharePoint event viewer application and ULS logs: Error 1: There was an error in communicating with Excel Calculation Services http://server /ExcelService*.asmx exception: An error has occurred.[Session: User: SHAREPOINT\system] Event ID: 5240 Plan A: Verified the following services and are running correctly: Excel Services are started and running fine. Need to reboot the server. Ref1: http://community.bamboosolutions.com/blogs/sharepoint-2010/archive/2011/09/15/sharepoint-2010-cookbook-sharepoint-2010-excel-services-an-error-has-occurred.aspx Ref2: http://social.msdn.microsoft.com/Forums/ar-SA/sqlkjpowerpointforsharepoint/thread/5db143b5-0701-4dba-8221-e86bf869984b Plan B: Delete the existing excel service application and need to create the new one and associate the same to the appropriate web apps. Plan C: Verify the Current SharePoint Version and if it is not up to date then requires a latest service Pack1. http://www.etechplanet.com/blog/fixes-included-in-sharepoint-2010-service-pack-1-%28sp1%29.aspx Error: Excel Services --The user receives the "An Error Has Occurred" message on the server when the TREND, LINEST, LOGEST, or GROWTH are used with external references on the Excel client and then the file is uploaded to the server. Need to execute the plans and will have to cross verify logs . Posted by RameshBabu M at 12:02 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: SharePoint2010 No comments: Post a Comment Note: Only a member of this blog may post a comment. Newer Post Older Post Home Subscribe to: Post Comments (Atom) About Me RameshBabu M View my complete profile ShrePoint 2007/2010 Administrator Followers Labels SharePoint 2013 (1) SharePoint2007 (21) SharePoint2010 (40) Bl