Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-15620

Sorting objects by reference attribute can cause inaccessible object view

      Issue Summary

      Sorting objects by reference attribute can cause inaccessible object view if the request cannot be completed within 1 minute due to the complexity of the data

      Steps to Reproduce

      1. Create a parent object type and configure its inheritance with the following
      2. Create children object types
      3. Update parent attribute to add references to the children object types
      4. Generate 20k for each children 
      5. With an object type that has more than 30k objects, and each object with a different referenced object, sort the objects by the reference attribute by clicking on the column name in the object type view.

      Expected Results

      The object list shows up sorted as expected

      Actual Results

      The object type becomes inaccessible as the object list doesn't load and the page becomes blank. It remains this way each time the same object type is accessed either via refreshing the page or navigating away and back.

      While checking the developer tools, we see that the request is cancelled after 1 minute.

      Workaround

      Extend AJAX timeout temporarily so that the request can be completed and the object list becomes accessible again. Then, remove the sorting of the reference attribute by sorting another non-reference type attribute.

      The script below shall be added to the announcement banner. This example extends the default AJAX timeout from 1 minute to 5 minutes.

      <script type="module">
      AJS.$.ajaxSetup({
      	timeout: 300000 // Milliseconds, wait for 5 minutes.
      });
      </script>
      

      Versions Tested

      Please confirm all versions that have been tested for this issue, and indicate whether the tested version is affected or not affected, below: 

      Testing Requirements Version Affected Version
      Customers Reported Version 5.12.13 Yes
      Most Recent Bug-Fix Release    
      Previous Major Release    
      Most Recent LTS 5.12.13  Yes 
      Previous Supported LTS    

        1. image (9).png
          image (9).png
          379 kB
        2. image-2024-10-10-14-59-26-915.png
          image-2024-10-10-14-59-26-915.png
          183 kB
        3. image-2024-10-10-15-14-54-856.png
          image-2024-10-10-15-14-54-856.png
          477 kB
        4. image-2024-12-13-15-34-13-082.png
          image-2024-12-13-15-34-13-082.png
          28 kB
        5. image-2024-12-13-15-35-41-329.png
          image-2024-12-13-15-35-41-329.png
          80 kB

              f31f2aa3fba9 Andrew Bui
              michin Michelle Chin
              Affected customers:
              0 This affects my team
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: