Red bar error returned in the web console after clicking on any of the product summary page

Red bar error returned in the web console after clicking on any of the product summary page

Symptoms

When trying to click on any of the applications in the 'product summary page', a red bar error is returned in the UI. And in the WebUI.log (located in the C:\ProgramData\Flexera Software\Compliance\Logging\WebUI directory on the application server), the corresponding error message looks similar to the following stack trace -
[INFO  2016-01-29 09:07:03,469 490988ms ortSnapshotManagerBase] Saving report 'All Computers' for user 'NA\NummerdorB' to snapshot 'Report_op15_Reports_View_657_fba84bd3f0514cd4b0227c3c58006224'.
[INFO  2016-01-29 09:07:08,750 496269ms ken=b77a5c561934e089]]] Saved 113336 rows to snapshot 'Report_op15_Reports_View_657_fba84bd3f0514cd4b0227c3c58006224'.
[ERROR 2016-01-29 09:36:25,617 2253136ms UiHelper_Grid         ] Error retrieving data
DevExpress.Xpo.DB.Exceptions.SqlExecutionErrorException: Executing Sql 'DECLARE @Groups xml;SET @Groups = N'<ArrayOfString />';
SELECT  [N0].[SoftwareTitleProductID],[N0].[ProductName],[N0].[PublisherName],[N0].[ComplianceStatus],[N0].[ComplianceStatusText],[N0].[InstallationsInBreach],[N0].[Liability],[N0].[Consumed],[N0].[ConsumedPercentage],[N0].[LicenseRecords],[N0].[IncompleteLicenses]
FROM [dbo].Grid_ProductComplianceListModel(1, @Groups) [N0]
WHERE ((([N0].[PublisherName] = @p0) and (([N0].[SoftwareTitleProductID] = -31971) or ... [SoftwareTitleProductID] = -11870) or ([N0].[SoftwareTitleProductID] = -13166))))' with parameters '{Microsoft}' exception 'System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type int.

Cause

A license that has an especially high number of entitlements could potentially cause this issue. This can be confirmed by verifying whether the following SQL query returns an arithmetic overflow error message -

USE FNMSCompliance
SELECT
CASE WHEN SUM(lic.Licensed) > 0 THEN 100.0 * SUM(lic.Consumed) / SUM(lic.Licensed) ELSE NULL END AS test
FROM TableLicenseComplianceSummary(1,'<ArrayOfString />') AS lic
GROUP BY lic.SoftwareTitleProductID, lic.ProductName, lic.PublisherID, lic.PublisherName, lic.Liability_CurrencyFormat


Resolution

If the debug SQL query fails with returns an arithmetic overflow error, then the stored procedure used to generate the product summary page can be modified to account for licenses that have been assigned a large number of entitlements. Please download and run the attached .sql script

Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Oct 10, 2018 03:30 PM
Updated by: