Web Intelligence Report which has more than 5000 rows does not display.

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

This issue occurs because of the option "Limit size of result set to" is set to 5000 by default.

Solution:

To resolve this issue, increase the value of "Limit size of result set to" to 10000 by following the below steps:

1. Login to the designer with administrator credentials.
   
   
2. Click on File and Import the Universe. Once imported, click on File and then Parameters.
   
   
3. In the Universe parameters window, click on controls tab and check the option "Limit size of result set to" and change the value to 10000 as shown in the below screenshot:
   
   

   <Please see attached file for image>

   
   
   
4. Click on OK and then click on File and then click on Export.
   
   
5. Once export in the designer is completed, login to Infoview and run the report.

You should now able fetch more than 5000 rows.

Environment

Release:
Component: ARGIS