NetBackup IT Analytics - Inventory reports fail with: Please reduce the scope of your report

Problem

When running the Storage Arrays Group Overview report on the NetBackup IT Analytics Portal Inventory page, the report fails to run and displays the error message:  
Please reduce the scope of your report

Error Message

The Portal UI displays the error message:  
Please reduce the scope of your report
 

The portal log shows this error:
navigationHistory:arrayGroupSummary - java.lang.String
reportScope:[] - java.util.ArrayList
consolidatedReport:Y - java.lang.String
IS_OCN_REPORT:true - java.lang.String
, userId=100000} - Error occurred while generating report for user
DD MMM YYYY HH:MM:SS ERROR com.aptare.sc.gwt.portal.server.objectExplorer.ObjectExplorerRpcImpl$2.call  - {parameters=[key=groupById value=11 domainId=null, key=byteSize value=TB domainId=null, key=consolidatedReport value=Y domainId=null, key=IS_OCN_REPORT value=true domainId=null, key=systemName value=arrayGroupSummary domainId=null, key=arrayIds value=100027 domainId=null], randomReportName=1726650782} - Error occurred while generating report
com.aptare.sc.domain.report.InvalidParameterException: Please reduce the scope of your report
at com.aptare.sc.domain.report.transformers.PivotBarChartReportTransformer.transform(PivotBarChartReportTransformer.java:43) ~[classes/:?]

Note:  If the portal log does not show this PivotBarChartReportTransformer entry, the source of the Please reduce the scope of your report might be due to a different root cause.  

Cause

The pivot page size is too small.
 

Solution

Increase the pivot page size by following these steps:

1.) Go to: Admin > Advanced > System Configuration > Custom Parameters

2.) Click the Add button

3.) In the Custom Parameter Name field enter: portal.report.maxPivotPageSize

4.) In the Custom Parameter Value field enter: 100000

5.) Click the Save button

6.) Click the Save and Apply button

7.) Click the OK button to acknowledge the change

8.) Restart the portal services