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, or over time without runs of the remove_not_present_items.sh, these scripts might be needed again.

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