Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Dear Community,
I'm trying to get OOS and PBIRS integrated successfully however after publishing an Excel file to PBIRS I see that the file is deployed but I can neither view it online (You do not have permissions to open this file in the browser) nor successfully download it. I'm being offered the download but neither Open / Save will complete.
Here's the output from RSOffice.log
2019-12-04 08:48:29.3956|INFO|33|Received request GET /files/202dbfc5-8a46-4832-91d9-3abf68c15bf1| RequestID = s_981f4773-d3df-4faa-ab8c-edfd2f665995
2019-12-04 08:48:29.4268|INFO|33|Loading office proof keys from https://oos.tld.url/hosting/discovery.| RequestID = s_981f4773-d3df-4faa-ab8c-edfd2f665995
2019-12-04 08:48:29.4737|INFO|33|Retrying proof key validation with updated office proof keys| RequestID = s_981f4773-d3df-4faa-ab8c-edfd2f665995
2019-12-04 08:48:29.4737|ERROR|33|WOPI proof key validation failed.| RequestID = s_981f4773-d3df-4faa-ab8c-edfd2f665995
Here's what RSPortal.log has to offer:
2019-12-04 08:48:27.4424|INFO|136|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test%27%29| RequestID = s_13f45275-10c3-4d7f-83e3-9c2568b9cff7
2019-12-04 08:48:27.6611|INFO|116|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,2224888| RequestID = s_13f45275-10c3-4d7f-83e3-9c2568b9cff7
2019-12-04 08:48:28.9581|INFO|136|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test/tabular-test.xlsx%27%29| RequestID = s_c7ed7acc-20e3-45ff-9b48-70d19626068f
2019-12-04 08:48:28.9581|INFO|60|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,0060778| RequestID = s_c7ed7acc-20e3-45ff-9b48-70d19626068f
2019-12-04 08:48:28.9893|INFO|136|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test/tabular-test.xlsx%27%29| RequestID = s_3472b110-d11f-4dd6-bcc2-f8a6df7827f5
2019-12-04 08:48:29.0049|INFO|76|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,0058407| RequestID = s_3472b110-d11f-4dd6-bcc2-f8a6df7827f5
2019-12-04 08:48:29.0205|INFO|136|Received request GET /api/v2.0/CatalogItems%28202dbfc5-8a46-4832-91d9-3abf68c15bf1%29/Model.AccessToken| RequestID = s_783ef77c-8849-479c-b2b9-4e6aaef91069
2019-12-04 08:48:29.0362|INFO|116|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,0057521| RequestID = s_783ef77c-8849-479c-b2b9-4e6aaef91069
2019-12-04 10:04:38.3415|INFO|74|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test%27%29| RequestID = s_a0a095d2-c086-4864-8ac1-6e7de97f18b7
2019-12-04 10:04:38.4665|INFO|115|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,1290803| RequestID = s_a0a095d2-c086-4864-8ac1-6e7de97f18b7
2019-12-04 10:04:39.4041|INFO|74|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test/tabular-test.xlsx%27%29| RequestID = s_f8529cab-706a-4e40-a5c4-4d53350a1f3d
2019-12-04 10:04:39.4197|INFO|76|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,0109516| RequestID = s_f8529cab-706a-4e40-a5c4-4d53350a1f3d
2019-12-04 10:04:39.4509|INFO|74|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test/tabular-test.xlsx%27%29| RequestID = s_24c4bd99-99a2-4f3d-be22-58b02ed789cf
2019-12-04 10:04:39.4665|INFO|76|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,010891| RequestID = s_24c4bd99-99a2-4f3d-be22-58b02ed789cf
2019-12-04 10:04:39.4978|INFO|74|Received request GET /api/v2.0/CatalogItems%28202dbfc5-8a46-4832-91d9-3abf68c15bf1%29/Model.AccessToken| RequestID = s_e447755d-d0ba-4e9c-8d5c-130dbf30a830
2019-12-04 10:04:39.4978|INFO|76|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,0061392| RequestID = s_e447755d-d0ba-4e9c-8d5c-130dbf30a830
and here is the Output from RSManagement.log
2019-12-04 01:17:00.5926|ERROR|11|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request
at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult)
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of inner exception stack trace ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_aceaa855-ef46-489b-afdf-58cfa44fc888
2019-12-04 01:17:00.5926|INFO|11|Domain\dom_s_dev-sqlsrs010 127.0.0.1: GET /api/v1.0/ManagementState - 0:00:00.087999
Connection dropped| RequestID = s_aceaa855-ef46-489b-afdf-58cfa44fc888 System.Threading.Tasks.TaskCanceledException: A task was canceled.
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<InvokeCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.BIServer.Management.WebHost.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext()
2019-12-04 02:25:09.5824|ERROR|11|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request
at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult)
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of inner exception stack trace ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_50acbe1e-6d5e-46b7-a369-73500d1047b8
2019-12-04 02:25:09.6136|INFO|11|Domain\dom_s_dev-sqlsrs010 127.0.0.1: GET /api/v1.0/ManagementState - 0:00:00.0940827
Connection dropped| RequestID = s_50acbe1e-6d5e-46b7-a369-73500d1047b8 System.Threading.Tasks.TaskCanceledException: A task was canceled.
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<InvokeCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.BIServer.Management.WebHost.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext()
2019-12-04 03:03:09.1768|ERROR|11|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request
at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult)
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of inner exception stack trace ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_8b0f5374-ba77-451d-89b1-96391a2563aa
2019-12-04 03:03:09.1768|INFO|11|Domain\dom_s_dev-sqlsrs010 127.0.0.1: GET /api/v1.0/ManagementState - 0:00:00.0410533
Connection dropped| RequestID = s_8b0f5374-ba77-451d-89b1-96391a2563aa System.Threading.Tasks.TaskCanceledException: A task was canceled.
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<InvokeCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.BIServer.Management.WebHost.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext()
2019-12-04 03:56:32.1653|ERROR|14|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request
at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult)
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of inner exception stack trace ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_50f86365-d65d-45ed-877f-26d2e111a7f7
2019-12-04 03:56:32.1653|INFO|14|Domain\dom_s_dev-sqlsrs010 127.0.0.1: GET /api/v1.0/ManagementState - 0:00:00.0541593
Connection dropped| RequestID = s_50f86365-d65d-45ed-877f-26d2e111a7f7 System.Threading.Tasks.TaskCanceledException: A task was canceled.
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<InvokeCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.BIServer.Management.WebHost.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext()
2019-12-04 09:25:49.4330|ERROR|4|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request
at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult)
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of inner exception stack trace ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_7524741a-cb00-4c48-afe3-63b06b10f0b3
Both OOS and PBIRS reside on the same server, there is a valid certificate with SANs for both
https://oos.tld.url and https://powerbi.tld.url and the Server name. I am able to open the discovery url without any issues.
Any help would be really appreciated.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
5 | |
4 | |
4 | |
4 |