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 URL | Status Code |
---|---|
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:
Request Method URL | Status Code |
---|---|
0 | |
0 | |
GET wss://jira-spreadsheets.services.atlassian.com/ws | 0 |
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.