Assets two dimensional report takes a very long time to synchronize

XMLWordPrintable

    • 3
    • Severity 3 - Minor
    • 14

      Issue Summary

      The Assets two dimensional report sync time increases exponentially as the report's scope increases

      Steps to Reproduce

      1. Create an Assets Object Schema with a single object type in it
      2. Add a Select Type attribute: "Select", and an Integer attribute "INT".
      3. Create a CSV file with a single column: Name, with sequential numeric values 1-2000
      4. Configure an Assets CSV import, using the CSV mapped to your object type:
        -Ensure that "Unknown Values" is set to "ADD", to add new options to the Select Attribute.
      • Map Name datalocator to the Name attribute (Identifier)
      • Map Name datalocator to both the Select and INT attributes
      1. Synchronize the import.
      2. See that 2000 objects were created, and Select and INT attributes are populated on all.
      3. In a separate tab/window, open the UPM: Jira Administration>Manage Apps>Manage Apps. 
        Here we will monitor the Widget batch process' progress bar.
      4. In Assets > Reports, create a new two dimensional report, indicate your Schema and object type, and use either the Name or Select attribute for both X and Y axis.
        Set an AQL in the report configuration: INT < n
        Where n is a number between 1 and 1000 - see below.
      5. Once the Report is saved, start measuring the time it takes for the batch process to finish and close.
      6. Repeat steps 8-10 for n=100, n=500, n=1000, n=1500

      Expected Results

      "Reasonable" time to sync an import; minutes or hours but not days

      Actual Results

      Tested with 16GB JVM Memory, 8 CPUs

      No. of objects / Attribute type in x/y Sync time
      100 / text ~5s
      500 / text 40s
      1000 / text 4m 30a
      1500 / text 16m
      1000 / select 2h 20m and still running!

      ~42K objects in the report took almost 1 week to sync!

      Due to https://jira.atlassian.com/browse/JSDSERVER-16424 it will appear as if the import is not progressing / stuck for days

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

      Versions Tested

      Testing Requirements Version Affected Version
      Customers Reported Version 10.3.8 Y
      Most Recent Bug-Fix Release 11.1.1 Y
      Previous Major Release    
      Most Recent LTS    
      Previous Supported LTS 10.3.10 Y
      Other Versions.. 9.12.26 Y
           

              Assignee:
              Luke Ellis
              Reporter:
              Yinon Negev (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: