“We’re sorry. We ran into a problem completing your request. Please try that again in few minutes.” Excel Service SharePoint

This article explains about Excel related issue in our SharePoint 2013 Environment. Whenever user tries to open excel files uploaded in document library, it launches browser to open the file and then displays below error-

We’re sorry. We ran into a problem completing your request. Please try that again in few minutes.”

Also see below screenshot-

ExcelIssue

As part of issue analysis, following checks were performed-

1.) Check if Excel Services is running. (This was running in our case.)
Open Central Administration -> System Settings -> Manage Services on Server -> Excel Calculation Service -> Started

2.) Check if Excel Service Application is associated to Web Application in question. (This was configured in our case.)
Open Central Administration -> Application Management -> Manage Web Applications -> Select Web Application -> Select Configure Service Associations

3.) Check if Trusted File Location is configured for Excel Service Application. (This was configured in our case.)
Open Central Administration -> Application Management -> Manage Service Applications -> Excel Service Application and perform below steps-

  • Select Trusted file location
  • Add  trusted file location
  • Add address as https:// and Location Type as Microsoft SharePoint Foundation
  • Keep rest of the fields as it is
4.) Check if document library configured to open documents in browser. (This was configured in our case.)Navigate to Site -> Library -> Library Settings -> Advanced Settings -> Check selected value for “Opening Documents in the Browser” section. It should be either Server Default(Open in Browser) or Open in the Browser.

After performing above checks, i came across below PowerShell script that grants “Excel Service Account” access to SharePoint Content database-

$wp = Get-SPWebApplication -identity <Web Application URL>
$wp.GrantAccessToProcessIdentity("DomainAccount that Run Excel Service")

To check for service account – Open CA -> Security -> Configure service accounts  Still issue not fixed, getting same error. I started checking SharePoint Logs and Event Viewer errors.

Then i found below error logged multiple times in event viewer –
“Event Viewer: Event 5239, Excel Services Application. There was an error in communicating with Excel Calculation Service (server address on port 32843, standard port for web services address ending with /ExcelService*.asmx)  exception: The underlying connection was closed: An unexpected error occurred on a receive.”

I started looking in this direction and stumbled on this helpful post which suggests of disabling ASP.Net Impersonation authentication for SharePoint Services Web Site.Please follow below steps to achieve this-

  • Launch IIS Manager (Start Administrative Tools -> Internet Information Services (IIS) Manager)
  • Expand Servers and Expand Sites
  • Select SharePoint Web Services from list of available of sites.
  • Select Authentication from right panel and available authentications are displayed.
  • Disable ASP.NET Impersonation if enabled.
Hope this helps.
Advertisements
Advertisements

filename invalid or too long sharepoint

The filename invalid or too long. Specify a different filename

"The filename invalid or too long Specify a different filename" error while opening document library in windows explorer mode.

File name invalid or too long

File name invalid or too long

For testing  I tried to upload a single file using browser but its generated error as below:

Sorry, something went wrong.The URL ‘Shared documents/Project budget.xlsx’ is invalid.

File name invalid or too long

File name invalid or too long

Actually filename is not very long at all, including the full path. I looked into the ULS logs (for the time i tried to upload file) and found log as as below:

Exception thrown storing stream in new SqlRemoteBlob: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> Microsoft.Data.SqlRemoteBlobs.BlobStoreException: There was a generic database error. For more information, see the included exception. —> System.Data.SqlClient.SqlException: RBS Error. Original Error: Number 297, Severity 16, State 1, Procedure rbs_fs_sp_check_pool_size, Line 31, Message: The user does not have permission to perform this action.  Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

I have RBS (Remote Blob Storage) enabled for this content database so it appears that, this has got messed up somehow.  After reading various other blog posts and TechNet articles I began some trial and error with the database permissions.

Solution :

So as to resolve this issue we need to grant the service account used by the application pool "db_owner" rights on the content database, in addition to the "db_rbs_* " permissions.

File name invalid or too long

File name invalid or too long

The original error about the filename being too long or invalid is very misleading, there is no hint of a permissions.