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

book

Article ID: 192513

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

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

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;

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

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.

Attachments

1591661036513__cleanupDeletedItems.zip get_app