cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dino
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.

0 REPLIES 0

Helpful resources

Announcements
collabdays lisbon

CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.