Reports are failing with the following error Query failed. See the logs for details. (Query ID: identifier)

Products

• CA Performance Management
• Network Observability

Issue/Introduction

Reports are failing with the following error Query failed. See the logs for details. (Query ID: identifier)

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Cause

Upon further investigation errors along the lines of the following appear in the PCService.log:

Error occurred while running a RIB query on Data Aggregator RIB Source. Query ID: RIBQuery_a24a367e_7b37_458f_8f23_310de6be30d3
  Possible reason: PreparedStatementCallback; SQL []; [Vertica][VJDBC](3149) ERROR: Duplicate primary/unique key detected in join [(dauser.nrm_rttmon_stats_icmp_rate x dauser.poll_item) using nrm_rttmon_stats_icmp_rate_super and poll_item_is_filtered_in_order_by_node0001 (PATH ID: 61)]; value [1501188];

When checking for the existence of the mentioned item_id in the Data Repository, you find that the item is NOT part of the item table:

select * from dauser.item where item_id = 1501188;

Resolution

This message is due to the referenced device being only partially deleted and purged from only the item table.  Utilize the CleanupDeletedItems.sh script to clean up the remaining references:

cleanupDeletedItems.sh -u dradmin -w dbpass -s dauser

Add the -c switch to the above call to "check" what the script finds to purge.