Vertica Duplicate Key errors

Document ID : KB000116777
Last Modified Date : 02/10/2018
Show Technical Document Details
Issue:
CAPC reports started showing up with errors instead of data. Log file reports: 2018-09-20 11:57:50,697 - Caused by: com.vertica.support.exceptions.IntegrityConstraintViolationException: [Vertica][VJDBC](3149) ERROR: Duplicate primary/unique key detected in join [(dauser.item_facet x dauser.item) using item_facet_super and item_super (PATH ID: 1)]; value [item_id=15052] stderr -- 2018-09-20 11:57:50,698 - ... 74 more
Environment:
IM 3.5
Resolution:
The solution is as following: drop vertica database, and create a new vertica databse via vertica adminTools, it only takes a few mins. then uninstall, followed by re-install the DA