Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.