Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-538

Jira Cloud for sheets throws EN-510 error when using auto-import with too many results

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 1.0
    • Jira Cloud for Google Sheets
    • None
    • Severity 3 - Minor

      Issue Summary

      Jira Cloud for sheets throws EN-510 error when using auto-import with a query that returns too many issues.

      Steps to Reproduce

      1. Configure an auto-import with a filter that returns over 4k issues
      2. It will eventually throw an EN-510 error

      Expected Results

      All results are imported into the spreadsheet

      Actual Results

      An EN-510 error appears

      Workaround

      Tweaking the query to return fewer results, such as including a time range delimiter:

      <query> AND updated >= -90d

            [API-538] Jira Cloud for sheets throws EN-510 error when using auto-import with too many results

            Tibor Borcsok added a comment - - edited

            What does "too many" mean? 100 000 or 200 000 or 500 000?  Any value can be set in the tool. It doesn't warn, it doesn't limit, it just doesn't work.
            What is the reason why a query that is interrupted 8 out of 10 times in a scheduled way, runs 9 out of 10 times in the morning when started manually?
            What is the proposal for a regular scheduled nightly migration of data to a data warehouse?

            Tibor Borcsok added a comment - - edited What does "too many" mean? 100 000 or 200 000 or 500 000?  Any value can be set in the tool. It doesn't warn, it doesn't limit, it just doesn't work. What is the reason why a query that is interrupted 8 out of 10 times in a scheduled way, runs 9 out of 10 times in the morning when started manually? What is the proposal for a regular scheduled nightly migration of data to a data warehouse?

              Unassigned Unassigned
              4f1a164b9e97 Andre Dias (Inactive)
              Affected customers:
              1 This affects my team
              Watchers:
              6 Start watching this issue

                Created:
                Updated: