-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Low
-
Affects Version/s: 10.3.8, 11.1.1
-
Component/s: Assets - Report
-
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
- Create an Assets Object Schema with a single object type in it
- Add a Select Type attribute: "Select", and an Integer attribute "INT".
- Create a CSV file with a single column: Name, with sequential numeric values 1-2000
- 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
- Synchronize the import.
- See that 2000 objects were created, and Select and INT attributes are populated on all.
- In a separate tab/window, open the UPM: Jira Administration>Manage Apps>Manage Apps.
Here we will monitor the Widget batch process' progress bar. - 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. - Once the Report is saved, start measuring the time it takes for the batch process to finish and close.
- 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 |
- links to