Rows missing while exporting Asset Intelligence reports to an excel file

book

Article ID: 50129

calendar_today

Updated On:

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>

Figure 1

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>

    Figure 2

  3. Restart the IIS service.

Environment

Release:
Component: UASINT

Attachments

1558709998723000050129_sktwi1f5rjvs16ros.gif get_app
1558709996888000050129_sktwi1f5rjvs16ror.gif get_app