Known Issue: Application Installation Details report may perform poorly or fail after some time with a red bar error due to large volume of data (IOJ-1892311)

[#1]

Summary

The License Compliance > Applications > Application Installation Details report may take a very long time to load and/or fail to load with red error bar displayed, particularly when the report is used in a way that results in large volumes of data being processed.

Symptoms

Various types of errors related to database timeout conditions may appear in the C:\ProgramData\Flexera Software\Compliance\Logging\WebUI\webui.log file on FlexNet Manager Suite On Premises Edition web servers. Some examples of possible errors appearing in the logging that may be symptomatic of this specific issue are:

[WARN  2020-03-02 13:52:46,262 28342573ms ken=b77a5c561934e089]]                 ] The table 'Report_op41_Reports_View_30_cec34697e6d740daa06ae621c029a059' could not be deleted and may become orphaned.
[...]
ClientConnectionId:e23501dd-bf4e-4454-8583-097a3aef5e3c' ---> System.Data.SqlClient.SqlException: Lock request time out period exceeded.

 And:

[ERROR 2020-08-13 11:22:54,291 82640457ms UnhandledErrors       ] An unexpected error occurred (a41b74a6-4156-4cf3-a758-d1ee36fd56ab)
Flexera.Web.Logic.Exceptions.ReportTimeoutException: The Timeout period for generating the report of 3600s was exceeded ---> System.AggregateException: One or more errors occurred. ---> System.Threading.Tasks.TaskCanceledException: A task was canceled.

Workaround

Consider applying filters to limit which publisher(s) and application(s) are covered by the report so that less data is returned.

Fix status

This issue has been fixed in the following FlexNet Manager Suite releases: 2023 R2.1 / Jan 2024 (Cloud), 2024 R1 (On Premises)

Other information

Affected components: Inventory, Reports

Master issue ID: IOJ-1892311

Also known as: ITAM-614