nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Cloud for Sheets - getting no jira auth error

Yuliia Levchenko

Hi all,

JIRA Cloud of Sheets was working normally previously for my Google sheet, but today when trying to extract data it shows me "no jira auth" error and a blank panel.

All functions are enabled http://prntscr.com/12f3jtz

I even tried to disconnect and connect the site once again but without luck. All formulas look correct.

Interesting that when I made a copy of file and execute the same steps, everything works fine.

Could you please advise what can be an issue or what else should be checked on my side?

Thanks

Accepted answers

All comments

Earl McCutcheon

Hello @Yuliia Levchenko ,

Thanks for reaching out, and the error "no jira auth" can have a few different causes but it is going to be tied to the google authentication token being interrupted or blocked in some way.

The first thing to check is for a local browser issue, check out the KB article "Browser Troubleshooting Guide" under the "Indispensable tests" section. With a primary focus on the options to try logging into your Sheet from another browser and/or Incognito mode, as well as flushing cache.

Next, make sure the browser is up to date with the most recent version, and log out of the Browser, and then log back in to establish a new authentication token.

Then verify the document owner, and try changing the owner if there is a known issue with the current owner's account. Alternatively, try creating a new document where you are the owner to verify if the issue exists in the specification sheet.

Let me know what you find while testing.

Regards,
Earl

dinesh.ck

Hello @Earl McCutcheon

I'm facing the same issue. Asked a few of my colleagues to refresh the sheet in which I'm having the problem and everyone got the same error. It had been working fine for a couple of months. Making a copy of the sheet works. I tried disconnecting, disabling and re-enabling JIRA() but didn't work. Also, tried by uninstalling and re-installing JIRA Addon.

Regards,

Dinesh

Stephen Sifers

Hello Dinesh,

Thanks for reach out about this issue. From what you stated about Copying the sheet allows it to start working which leads me to believe the original sheet is having an issue with the 'owners' token and thus not working.

For the original sheet, could you verify or change the owner and let us know if that allows it to start working?

Regards,
Stephen Sifers

dinesh.ck

Hi @Stephen Sifers

Thanks for your response. I got ownership moved to me and still facing the same issue. After transferring ownership to me I even tried by disconnecting and then reconnecting.

Regards,

Dinesh

Sergey Kurguzenkov

Faced the same issue, and found out that Jira Cloud for Sheets works correctly only when authorized in Jira on the behalf of the owner of the google account. If you have editing rights and authorize in Jira, then that gizmo will show whatever error from jira no auth (though JQL works, and it fetches some data from jira) and syntax error to Jira - unkown function. Truly misleading.

Solution that worked for me - create a new google sheet in your google account, copy-paste the data (or simply the formula), revoke the Jira Cloud access (if any), give it again, disable and enable the JIRA function switch on the Get issues from Jira tab.

ecoulon

Hi, I experienced the same issue. After trying different things such as uninstalling/reinstalling etc., what made it work again was from the Google Sheet to go to "Extensions" -> "Jira Cloud for Sheets" -> Open. You'll see a widget on the right, where you can disconnect/connect to JIRA. That fixed the "no jira auth" issue when using the "JIRA()" function. Thanks.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud