Troubleshooting verification code for Microsoft Excel export - blocked WebSocket protocol

Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.

Summary

When attempting to export a Filter using the Microsoft Excel app option, it redirects to a new tab of the browser and requires a verification code for first-time use. The code is generated in the original Jira tab, whereas, it is required in the newly appeared second tab. Sometimes users are having trouble obtaining the code - the page does not display the code and remains blank, thus, preventing the user from successfully downloading the results from the Filter. One of the reasons this might happen is due to a firewall/proxy which is blocking the WebSocket protocol Jira uses in this action.

Diagnosis

It is possible in the process of troubleshooting that a HAR file is requested from the user experiencing the problem. In a HAR file excerpt, we can see that Jira is switching the HTTPS protocol with WebSocket (WSS) when the verification code is generated:


Request Method URLStatus Code

GET wss://jira-spreadsheets.services.atlassian.com/ws

101

Full Response:
101 Switching Protocols HTTP/1.1 More info about HTTP status codes in Wikipedia.


However, if the WSS protocol is getting blocked on the network level then the same request will be retried multiple times without any response:


Cause

Network devices like a firewall or a proxy are blocking the WSS protocol.

Solution

Request assistance from the user's networking team to enable WSS protocol so the verification code can be generated to complete the first-time Microsoft Excel authentication.


Last modified on Jun 13, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.