Excel Web Access Web Parts & Remote Blob Storage – "We don't know what happened, but something went wrong."


We have seen several cases where customers can view an Excel Workbook in the browser, but not in the Excel Web Access Web Part.  They are seeing the below error in the Excel Web Access Web Part:

“Excel Services

 

We don’t know what happened, but

something went wrong. 

 

Could you please try that again?”

 

When reviewing the ULS logs, we are seeing:

11/24/2014 11:37:37.26 w3wp.exe (0x2864) 0x0BBC SharePoint Foundation Database d0d6 High System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'rbs_fn_get_blob_reference', database 'SharePoint_Content_80', schema 'mssqlrbs'.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)     at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)     at System.Data.SqlClient.SqlDataReader.Read()     at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock)     at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock)  ClientConnectionId:932b5260-fed3-44df-9e6a-72292182dfd9 c057cf9c-9345-605f-7c08-0f50fcd1dfd4

 

This has to do with permissions and to resolve this, grant the following permissions to the Application Pool account on the content database:

db_rbs_admin

db_rbs_filestream_maintaner_1

db_rbs_filestream_reader_1

db_rbs_filestream_writer_1

db_rbs_maintainer

db_rbs_reader

db_rbs_writer

 

 

 

 

Comments (0)

Skip to main content