Rows missing while exporting Asset Intelligence reports to an excel file

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager

Issue/Introduction

Description:

In the following example, the report for listing 'Microsoft Windows XP Professional' machines displays 13592 assets. However, when I try to export the report to an Excel file using the EXPORT tab, not all the rows are exported correctly. Usually 300/400 rows are exported, and then the last exported row was truncated.

<Please see attached file for image>

Solution:

This is a timeout problem, and can be solved in the following way:

1. Stop the IIS service
   
   
2. Modify the following parameter:
   
   CGITimeout="300" to "1800" in the xml file named metabase.xml in the directory C:\windows\system32\inetsrv
   
   

   <Please see attached file for image>

   
   
   
3. Restart the IIS service.

Environment

Release:
Component: UASINT