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; } } }

Unable to use JIRA add on in Google sheets

Mohammed Malubhoy

Hello Team,

I have been using the JIRA add on in Google sheets for a while now, it's absolutely great. However, for the past weeks I am unable to use it effectively. When I try to run a query to get more that 500 tickets I get the error 'Hmmm ... looks like we stumbled a bit, please try again or contact Atlassian support if the issue persists'. Can someone please help me with this, as I need this on a regular basis.

Thank you in advance.

Mohammed Malubhoy

Accepted answers

All comments

Earl McCutcheon

Hello @Mohammed Malubhoy ,

Thanks for bringing this up, and we have picked up a few errors on the backend that we believe are related to what you are seeing. Our Dev teams are looking into this now and I will give you an update when we have more info.

Regards,
Earl

Grant Apodaca

Hello @Mohammed Malubhoy ,

I am a Dev from the Jira AddOn in Google Sheets team. We believe this error may be related to the Google Sheets Cell size limit. If during your import, it fails, and your Google Sheet currently has over 5,000,000 cells, the import will not complete, as Google Sheets will not allow for any more cells. If you are able to run the import in a brand new, empty sheet, it should complete. Otherwise, if your import is containing results too large, it may continue to fail.

However, if this is not related to your problem, and running the import in a new sheet did not help, please reach out to us via the in application feedback (Top Left Menu icon --> Give Feedback) as this will allow us to provide much more detailed and personalized help with your issue.

Regards,
Grant

Mohammed Malubhoy

Thank you for getting back to me @Grant Apodaca .

I tried reducing the headers and line items to keep the cells under 10000, but I am still getting the same error. Maybe I am doing something wrong (But it was working until recently). I have raised it via 'Give Feedback' per your suggestion. Hopefully will get a resolution soon on this.

Regards,

Mohammed Malubhoy

Arpit Kabra

Hi @Grant Apodaca ,

I tried the given suggestion but I am still facing the same error.

Raised a ticket "PIF-1862 sheets-jira : bug" via 'Give Feedback' option. Please resolve this issue.

Rachel Barna

Hello - we are coming across the same error (Hmmm ... looks like we stumbled a bit, please try again or contact Atlassian support if the issue persists.) in our Google sheets. We noticed this today (3/27/20) but were previously able to use this about two weeks ago without this error (3/13 through 3/16). We've tried updating the formulas but the error is persisting.

This happens in cells that we are using formulas for and it's on each sheet within the document (9 sheets total). I'm not sure of the total number of cells we have on this. We are using Jira cloud.

Grant Apodaca

Rachel,

We are sorry to hear you're getting the same error. If you can please submit these details via the in application feedback (Top Left Menu icon --> Give Feedback), that's will allow us to provide much more detailed and personalized help with your issue, as it may or may not be related to the topic of this post.

Yury Kniazhevich

I'm experiencing the same issue for two days.

Rachel Barna

Hi Grant - thank you for the feedback. I'm not seeing this icon within Jira or Confluence (not sure if this is because I'm on cloud or not). Should I create a new question within Atlassian Community?

Mohammed Malubhoy

@Rachel Barna - The option is available in Google Sheets.

'Add-ons' -> 'JIRA Cloud for sheets' -> 'Open' -> 'Give Feedback', and you will get the options in the attached image.

rohit.gohri

I'm having the same issue. For a workaround you can still use `=JIRA()` formula and it will populate the results in the cells below and right to that starting from that cell.

Lam Ton

Try to clear browser cache

Tetiana Kovalenko_disvwm

Can you please fix this issue

Tq-xgfc91b809ad1cc19594fad83438a9b45b5

Matt C_ Wilson

I have been trying to figure this out for almost a year and this tip helped me fix it!

I have (apparently) a too-large spreadsheet that I've been trying to import into, and getting the dreaded "Hmmm ... looks like we stumbled a bit, please try again or contact Atlassian support if the issue persists. (§GS-404)" error.

It didn't matter if I switched from using a filter to using Basic, or =JIRA(), or JQL. Nothing would load - even trying to pull a single ticket row by id/key.

I just now created a new, blank spreadsheet, and set up the same query, and what do you know, it pulled in.

This is fantastic. I'm just going to have to copy over / link between the spreadsheets to get the data to my main spreadsheet, but that's fine by me.

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-cloud

google-sheets