Troubleshooting verification code for Microsoft Excel export - blocked WebSocket protocol

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Cloud のみ - この記事は クラウド プラットフォームのアトラシアン製品に適用されます。

要約

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.

診断

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ステータス コード

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:


原因

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

ソリューション

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.


最終更新日 2023 年 6 月 13 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.