When generating lists of computer reports, the Console can be either very slow or errors out with "Database timeout expired".
An error similar to this may show up in \Program Files (x86)\Bit9\Parity Server\Support\PHPErrors-date-here.log
Query: "WITH _inner AS (SELECT ROW_NUMBER() OVER( ORDER BY Upgrade_Status ASC ) AS RowNum, * FROM dbo.DetailedHostsGUI WHERE ( Deleted = 0 ) AND ( Host_Agent_Version = N'22.214.171.12462' ) ) SELECT * FROM _inner WHERE RowNum BETWEEN 1 AND 181 " caused error: DB Error: Could not continue scan with NOLOCK due to data movement.
This problem is triggered by including any of these columns in the Computer report: Processor_Count, Machine_Model, Processor_Speed, Processor_Model, Memory_Size
Code change EP-5109 is currently pending (March, 2018). The workaround is to avoid selecting any of the five columns
that trigger the very expensive join between two views.
Check Patch Release Notes to see if EP-5109 is fixed.