cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

OOS and PBIRS Integration WOPI proof key validation failed

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.

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021