Errors running the remove_not_present_items.sh script

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Trying to clean up retired items and devices in DX NetOps Performance Management.

 

Running the remove_not_present_items.sh script returns an error. We see the following.

 

[root@<DA_Host> scripts]# ./remove_not_present_items.sh -h <DA_Host>  -s -F
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0   281    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
curl: (52) Empty reply from server
returnedRetireItems.xml:1: parser error : Document is empty

####### RESULT OF SEARCH  ##########################################
Items found to be deleted:  0

 

When we run the following VSql command in a vsql prompt on the Data Repository database we see it has many retired items.

 

select facet_qname, count(*) from drdata.v_item_facet where item_id in (select item_id from drdata.v_poll_item where is_filtered = 1) group by 1 order by 2 desc;

 

If we try to go to <DA_Host>:<Port>/rest/retired in a browser we receive a 413 error.

Environment

All supported DX NetOps Performance Management releases

Cause

To many retired items for the remove_not_present_items.sh script to work with.

Resolution

Use the deleteAllDevicesInFile.pl and deleteRetiredItemsInFile.pl scripts to remove the retired items.

After the retired items are removed, regular runs of the remove_not_present_items.sh should function normally to keep the system clean.

If too many items build up in a short time period, or over time without runs of the remove_not_present_items.sh, these scripts might be needed again.

How to use the deleteAllDevicesInFile.pl script is documented in the How to delete Retired Devices in Performance Management Knowledge Base Article.

How to use the deleteRetiredItemsInFile.pl script is documented in the How to delete Retired Items in Performance Management Knowledge Base Article.