Uploaded image for project: 'Jira Service Management Cloud'
  1. Jira Service Management Cloud
  2. JSDCLOUD-12774

Export of a large number of objects with references times out and shows an "unresponsive" page error or returns an export CSV of 0 bytes

XMLWordPrintable

      Issue Summary

      When exporting a large number of Objects with a large number of Object References on those Objects, the Export will timeout resulting in the user seeing a page saying the Site is unresponsive or the Export CSV is of size Zero Bytes, or the error message "upstream request timeout."

      Steps to Reproduce

      1. Create a lot of objects (19,000+) in an Object Type.
      2. Create a lot of object references on those objects (10+ each).
      3. Attempt to export them all from the Object Type.

      Expected Results

      The Export completes successfully.

      Actual Results

      The Export time outs and an unresponsive site page is returned or the Export CSV is Zero Bytes.

      Workaround

      Export fewer objects at a time, such as with these AQL queries:

      Key < ABC-5000
      Key > ABC-4999 AND Key < ABC-10000
      Key > ABC-9999 AND Key < ABC-15000
      etc...
      

      That's just one of the examples. You can also use ObjectId:

      objectid > 1 and objectid < 1000
      objectid > 1001 and objectid < 2000
      etc...
      

              60168db0127c Nishchal Prakash
              992127aa63ec Payden Pringle (Inactive)
              Votes:
              41 Vote for this issue
              Watchers:
              41 Start watching this issue

                Created:
                Updated:
                Resolved: