search cancel

Export to Excel function produces duplicate rows in the output spreadsheet


Article ID: 49176


Updated On:


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



After exporting data from Service Desk Manager via the "Export to Excel" functionality, it can happen that you see duplicate data in the output Excel spreadsheet. This occurs when sorting of the data is different than the default (such as in a filtered list) and a large number of items (approximately 500 or higher) are in the list.


Adding the NX variable, NX_EXPORT_FETCH_GROUP_SIZE to NX.env, and then restarting the Service Desk Manager service solves the problem.

To implement this change, via pdm_options_mgr, go into an Admin command prompt and run:

pdm_options_mgr -c -s EXPORT_FETCH_GROUP_SIZE -v 5000 -a pdm_option.inst"

To avoid losing the change when you run pdm_configure, please run the above command with the '-t' flag as follows:

pdm_options_mgr -c -s EXPORT_FETCH_GROUP_SIZE -v 5000 -a pdm_option.inst -t"

The above will set the given variable to a value of "5000".

Note: The default value, when the environment variable is not specified, is 300.

Remember to recycle Service Desk Manager services after making the above change.


Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration


Please Update This Required Field